{"id":36567,"date":"2023-11-10T00:54:58","date_gmt":"2023-08-21T10:08:48","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e7%94%a8apache-drill%e7%bc%96%e7%a8%8b%e7%9a%84%e4%bd%93%e9%aa%8c\/"},"modified":"2024-05-04T08:17:19","modified_gmt":"2024-05-04T00:17:19","slug":"%e6%88%91%e5%b0%9d%e8%af%95%e7%94%a8apache-drill%e7%bc%96%e7%a8%8b%e7%9a%84%e4%bd%93%e9%aa%8c","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e7%94%a8apache-drill%e7%bc%96%e7%a8%8b%e7%9a%84%e4%bd%93%e9%aa%8c\/","title":{"rendered":"\u6211\u5c1d\u8bd5\u7528Apache Drill\u7f16\u7a0b\u7684\u4f53\u9a8c"},"content":{"rendered":"

\u5728\u5348\u9910\u65f6\uff0c\u6211\u7a0d\u5fae\u542c\u8bf4\u4e86Apache Drill\u7684\u4e8b\u60c5\u3002
\n\u542c\u8bf4\u5b83\u53ef\u4ee5\u4f7f\u7528\u7c7b\u4f3cSQL\u7684\u67e5\u8be2\u5c06\u4efb\u4f55RDS\u3001DynamoDB\u7684\u8868\u548c\u6587\u4ef6\u7cfb\u7edf\u4e0a\uff0c\u4ee5\u53caS3\u4e0a\u7684JSON\/tsv\/csv\u6587\u4ef6\u8fdb\u884c\u8fde\u63a5\u3002<\/p>\n

\u56e0\u4e3a\u770b\u8d77\u6765\u6709\u8da3\uff0c\u6240\u4ee5\u6211\u60f3\u8bd5\u4e00\u8bd5\u3002<\/p>\n

\u6587\u4ef6<\/h1>\n

\u5b89\u88c5<\/h1>\n

\u4f7f\u7528brew\u8fdb\u884c\u4e00\u51fb<\/p>\n

brew install apache-drill\r\n<\/code><\/pre>\n
\u6a21\u62df\u6570\u636e\u521b\u5efa<\/h1>\n
\u4f7f\u7528Mockaroo\u521b\u5efa\u6a21\u62df\u6570\u636e\u3002<\/p>\n
JSON\uff08\u5217\u7684\u53c2\u6570\u4fdd\u6301\u9ed8\u8ba4\u8bbe\u7f6e\uff09\u3002<\/h2>\n
[{<\/span>\"id\"<\/span>:<\/span>1<\/span>,<\/span>\"gender\"<\/span>:<\/span>\"Male\"<\/span>,<\/span>\"first_name\"<\/span>:<\/span>\"Willie\"<\/span>,<\/span>\"last_name\"<\/span>:<\/span>\"Gardner\"<\/span>,<\/span>\"email\"<\/span>:<\/span>\"wgardner0@csmonitor.com\"<\/span>,<\/span>\"ip_address\"<\/span>:<\/span>\"171.75.157.165\"<\/span>},<\/span>\r\n{<\/span>\"id\"<\/span>:<\/span>2<\/span>,<\/span>\"gender\"<\/span>:<\/span>\"Female\"<\/span>,<\/span>\"first_name\"<\/span>:<\/span>\"Lois\"<\/span>,<\/span>\"last_name\"<\/span>:<\/span>\"Jacobs\"<\/span>,<\/span>\"email\"<\/span>:<\/span>\"ljacobs1@photobucket.com\"<\/span>,<\/span>\"ip_address\"<\/span>:<\/span>\"188.171.106.166\"<\/span>},<\/span>\r\n{<\/span>\"id\"<\/span>:<\/span>3<\/span>,<\/span>\"gender\"<\/span>:<\/span>\"Male\"<\/span>,<\/span>\"first_name\"<\/span>:<\/span>\"Shawn\"<\/span>,<\/span>\"last_name\"<\/span>:<\/span>\"Rivera\"<\/span>,<\/span>\"email\"<\/span>:<\/span>\"srivera2@storify.com\"<\/span>,<\/span>\"ip_address\"<\/span>:<\/span>\"160.224.138.213\"<\/span>},<\/span>\r\n{<\/span>\"id\"<\/span>:<\/span>4<\/span>,<\/span>\"gender\"<\/span>:<\/span>\"Female\"<\/span>,<\/span>\"first_name\"<\/span>:<\/span>\"Stephanie\"<\/span>,<\/span>\"last_name\"<\/span>:<\/span>\"Hernandez\"<\/span>,<\/span>\"email\"<\/span>:<\/span>\"shernandez3@shinystat.com\"<\/span>,<\/span>\"ip_address\"<\/span>:<\/span>\"77.67.203.114\"<\/span>},<\/span>\r\n{<\/span>\"id\"<\/span>:<\/span>5<\/span>,<\/span>\"gender\"<\/span>:<\/span>\"Male\"<\/span>,<\/span>\"first_name\"<\/span>:<\/span>\"Ralph\"<\/span>,<\/span>\"last_name\"<\/span>:<\/span>\"Wright\"<\/span>,<\/span>\"email\"<\/span>:<\/span>\"rwright4@booking.com\"<\/span>,<\/span>\"ip_address\"<\/span>:<\/span>\"89.240.134.189\"<\/span>},<\/span>\r\n....<\/span>\r\n<\/code><\/pre>\n
\u8bf7\u6dfb\u52a0CSV\u4e2d\u7684color\u548ccompany_name\u5b57\u6bb5\u3002<\/h2>\n
id,first_name,last_name,email,gender,ip_address,color,company_name\r\n1,Kenneth,Wheeler,kwheeler0@domainmarket.com,Male,54.230.82.29,Khaki,Voonyx\r\n2,Brenda,Young,byoung1@networkadvertising.org,Female,79.121.226.209,Goldenrod,Feedbug\r\n3,Steven,Knight,sknight2@hud.gov,Male,161.79.31.161,Purple,Aimbo\r\n4,Timothy,Daniels,tdaniels3@ovh.net,Male,233.15.252.170,Mauv,Oba\r\n5,Adam,Wright,awright4@cbc.ca,Male,56.247.113.21,Indigo,Kwilith\r\n....\r\n<\/code><\/pre>\n
\u786e\u8ba4\u52a8\u4f5c<\/h1>\n
\u9996\u5148\u8fdb\u5165\u94bb\u5b54\u58f3\u3002\u5c31\u94bb\u4e0b\u53bb\u5427\uff01\uff01<\/p>\n
$ sqlline -u jdbc:drill:zk=local\r\nJava HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=512M; support was removed in 8.0\r\nJan 05, 2016 3:32:08 PM org.glassfish.jersey.server.ApplicationHandler initialize                                                                  INFO: Initiating Jersey application, version Jersey: 2.8 2014-04-29 01:25:26...                                                                  apache drill 1.4.0\r\n\"just drill it\"\r\n 0: jdbc:drill:zk=local>\r\n<\/code><\/pre>\n
\u4e5f\u63d0\u4f9b\u4e86Web\u63a7\u5236\u53f0\uff0c\u5728\u8fdb\u5165shell\u72b6\u6001\u4e0b\u53ef\u8bbf\u95eehttp:\/\/127.0.0.1:8047\/<\/p>\n
\"Screen<\/div>\n
\u8ba9\u6211\u4eec\u6765\u89e3\u6790\u4e00\u4e0b JSON \u6570\u636e<\/h2>\n
0: jdbc:drill:zk=local> SELECT tbl.* FROM dfs.`\/tmp\/work\/MOCK_DATA.json` AS tbl LIMIT 10;\r\n+-----+---------+-------------+------------+------------------------------------+------------------+\r\n| id  | gender  | first_name  | last_name  |               email                |    ip_address    |\r\n+-----+---------+-------------+------------+------------------------------------+------------------+\r\n| 1   | Male    | Willie      | Gardner    | wgardner0@csmonitor.com            | 171.75.157.165   |\r\n| 2   | Female  | Lois        | Jacobs     | ljacobs1@photobucket.com           | 188.171.106.166  |\r\n| 3   | Male    | Shawn       | Rivera     | srivera2@storify.com               | 160.224.138.213  |\r\n| 4   | Female  | Stephanie   | Hernandez  | shernandez3@shinystat.com          | 77.67.203.114    |\r\n| 5   | Male    | Ralph       | Wright     | rwright4@booking.com               | 89.240.134.189   |\r\n| 6   | Male    | Donald      | Graham     | dgraham5@google.com.br             | 239.6.250.80     |\r\n| 7   | Male    | Justin      | Howell     | jhowell6@dion.ne.jp                | 159.104.8.8      |\r\n| 8   | Male    | Russell     | Mills      | rmills7@nsw.gov.au                 | 245.130.6.110    |\r\n| 9   | Female  | Rose        | Gonzalez   | rgonzalez8@scientificamerican.com  | 16.9.119.25      |\r\n| 10  | Female  | Mildred     | Ramos      | mramos9@unc.edu                    | 82.232.80.156    |\r\n+-----+---------+-------------+------------+------------------------------------+------------------+\r\n10 rows selected (0.215 seconds)\r\n<\/code><\/pre>\n
\u54c7\u54c8\u54c8\u54c8\u3002\u8fd9\u771f\u4e0d\u9519\u3002\u800c\u4e14\u8fd8\u633a\u5feb\u7684\u3002<\/p>\n
\u8ba9\u6211\u4eec\u4e5f\u5c1d\u8bd5\u4e00\u4e0bcsv\u7684\u65b9\u6cd5<\/h2>\n
0: jdbc:drill:zk=local> SELECT tbl.* FROM dfs.`\/tmp\/work\/MOCK_DATA.csv` AS tbl  LIMIT 10;\r\n+----------------------------------------------------------------------------------------------------------+\r\n|                                                 columns                                                  |\r\n+----------------------------------------------------------------------------------------------------------+\r\n| [\"id\",\"first_name\",\"last_name\",\"email\",\"gender\",\"ip_address\",\"color\",\"company_name\"]                     |\r\n| [\"1\",\"Kenneth\",\"Wheeler\",\"kwheeler0@domainmarket.com\",\"Male\",\"54.230.82.29\",\"Khaki\",\"Voonyx\"]            |\r\n| [\"2\",\"Brenda\",\"Young\",\"byoung1@networkadvertising.org\",\"Female\",\"79.121.226.209\",\"Goldenrod\",\"Feedbug\"]  |\r\n| [\"3\",\"Steven\",\"Knight\",\"sknight2@hud.gov\",\"Male\",\"161.79.31.161\",\"Purple\",\"Aimbo\"]                       |\r\n| [\"4\",\"Timothy\",\"Daniels\",\"tdaniels3@ovh.net\",\"Male\",\"233.15.252.170\",\"Mauv\",\"Oba\"]                       |\r\n| [\"5\",\"Adam\",\"Wright\",\"awright4@cbc.ca\",\"Male\",\"56.247.113.21\",\"Indigo\",\"Kwilith\"]                        |\r\n| [\"6\",\"Jane\",\"Wheeler\",\"jwheeler5@unc.edu\",\"Female\",\"42.132.133.182\",\"Teal\",\"Gabcube\"]                    |\r\n| [\"7\",\"Jack\",\"Smith\",\"jsmith6@domainmarket.com\",\"Male\",\"199.219.253.212\",\"Fuscia\",\"Pixope\"]               |\r\n| [\"8\",\"James\",\"Hayes\",\"jhayes7@businessinsider.com\",\"Male\",\"237.34.224.202\",\"Purple\",\"Yabox\"]             |\r\n| [\"9\",\"Susan\",\"Murphy\",\"smurphy8@joomla.org\",\"Female\",\"85.200.49.196\",\"Turquoise\",\"Jaloo\"]                |\r\n+----------------------------------------------------------------------------------------------------------+\r\n<\/code><\/pre>\n
\u54e6\u54e6\u3002\u539f\u6765CSV\u662f\u8fd9\u6837\u7684\u3002\u8fd9\u6837\u5c31\u53ef\u4ee5\u7528JOIN\u4e86\u5417\uff1f\u53ef\u80fd\u6709\u4e9b\u9009\u9879\u5427\u3002<\/p>\n
\u6211\u6253\u7b97\u67e5\u770b\u6587\u6863\uff0c\u4f46\u53ea\u662f\u7c97\u7565\u5730\u770b\u4e86\u4e00\u4e0b\u53d1\u73b0\u6709\u8fd9\u4e2a\u5185\u5bb9\u3002<\/p>\n
\u53ea\u8981\u5b9a\u4e49\u8fd9\u4e2a\u8303\u56f4\uff0c\u5c31\u53ef\u4ee5\u4e86\u3002<\/p>\n
  \"skipFirstLine\": false,\r\n  \"extractHeader\": true,\r\n<\/code><\/pre>\n
\u542c\u8bf4\u4e0d\u662f\u5728cfg\u6587\u4ef6\u4e2d\u8bbe\u7f6e\uff0c\u800c\u662f\u8981\u5728Web\u63a7\u5236\u53f0\u6216\u4f7f\u7528curl\u8fdb\u884c\u8bbe\u7f6e\u3002
\n\u8fd9\u6b21\u6211\u4eec\u51b3\u5b9a\u5728Web\u63a7\u5236\u53f0\u4e0a\u4fee\u6539\u73b0\u6709csv\u7684\u5b9a\u4e49\u3002<\/p>\n
\u70b9\u51fb\u83dc\u5355\u9009\u9879\u5361\u4e2d\u7684\u5b58\u50a8\uff0c\u7136\u540e\u70b9\u51fbdfs\u7684\u201c\u66f4\u65b0\u201d\u6309\u94ae\u3002<\/p>\n
\"Screen_Shot_2016-01-05_at_16_16_36.png\"<\/div>\n
\"Screen_Shot_2016-01-05_at_16_27_39.png\"<\/div>\n
0: jdbc:drill:zk=local> SELECT tbl.* FROM dfs.`\/tmp\/work\/MOCK_DATA.csv` AS tbl  LIMIT 10;\r\n+-----+-------------+------------+---------------------------------+---------+------------------+------------+---------------+\r\n| id  | first_name  | last_name  |              email              | gender  |    ip_address    |   color    | company_name  |\r\n+-----+-------------+------------+---------------------------------+---------+------------------+------------+---------------+\r\n| 1   | Kenneth     | Wheeler    | kwheeler0@domainmarket.com      | Male    | 54.230.82.29     | Khaki      | Voonyx        |\r\n| 2   | Brenda      | Young      | byoung1@networkadvertising.org  | Female  | 79.121.226.209   | Goldenrod  | Feedbug       |\r\n| 3   | Steven      | Knight     | sknight2@hud.gov                | Male    | 161.79.31.161    | Purple     | Aimbo         |\r\n| 4   | Timothy     | Daniels    | tdaniels3@ovh.net               | Male    | 233.15.252.170   | Mauv       | Oba           |\r\n| 5   | Adam        | Wright     | awright4@cbc.ca                 | Male    | 56.247.113.21    | Indigo     | Kwilith       |\r\n| 6   | Jane        | Wheeler    | jwheeler5@unc.edu               | Female  | 42.132.133.182   | Teal       | Gabcube       |\r\n| 7   | Jack        | Smith      | jsmith6@domainmarket.com        | Male    | 199.219.253.212  | Fuscia     | Pixope        |\r\n| 8   | James       | Hayes      | jhayes7@businessinsider.com     | Male    | 237.34.224.202   | Purple     | Yabox         |\r\n| 9   | Susan       | Murphy     | smurphy8@joomla.org             | Female  | 85.200.49.196    | Turquoise  | Jaloo         |\r\n| 10  | Ann         | Hill       | ahill9@youku.com                | Female  | 254.251.33.227   | Red        | Yadel         |\r\n+-----+-------------+------------+---------------------------------+---------+------------------+------------+---------------+\r\n<\/code><\/pre>\n
\u592a\u597d\u4e86\uff01<\/p>\n
\u5927\u5bb6\u52a0\u5165\u5927\u6b63\u7fa9\u5427\uff01<\/h2>\n
\u5982\u679c\u4f60\u80fd\u505a\u5230\u8fd9\u4e2a\uff0c\u6211\u611f\u5230\u975e\u5e38\u5174\u594b\u3002<\/p>\n
0: jdbc:drill:zk=local> SELECT tbl1.first_name, tbl1.last_name, tbl2.color, tbl2.company_name FROM dfs.`\/tmp\/work\/MOCK_DATA.json` AS tbl1\r\n. . . . . . . . . . . > JOIN\r\n. . . . . . . . . . . > dfs.`\/tmp\/work\/MOCK_DATA.csv` AS tbl2 ON tbl1.first_name=tbl2.first_name and tbl1.last_name=tbl2.last_name;\r\n+-------------+-------------+-------------+----------------+\r\n| first_name  |  last_name  |    color    |  company_name  |\r\n+-------------+-------------+-------------+----------------+\r\n| Scott       | Ray         | Maroon      | Twinte         |\r\n| Andrew      | Brown       | Orange      | Photolist      |\r\n| Rose        | Washington  | Orange      | Livetube       |\r\n| Steven      | Adams       | Maroon      | Zoombeat       |\r\n| Nancy       | Porter      | Indigo      | Kwinu          |\r\n| Lois        | Williams    | Purple      | Flashset       |\r\n| Justin      | Hart        | Red         | Miboo          |\r\n| Arthur      | Scott       | Indigo      | Thoughtbeat    |\r\n| Wanda       | Peters      | Khaki       | Teklist        |\r\n| Christine   | Dean        | Aquamarine  | Buzzshare      |\r\n| Paula       | Nelson      | Green       | Kare           |\r\n| Betty       | Wagner      | Aquamarine  | Photobean      |\r\n| Jerry       | Ross        | Mauv        | Linktype       |\r\n| Harry       | Washington  | Green       | Reallinks      |\r\n| Nancy       | Lynch       | Turquoise   | Twitternation  |\r\n| Heather     | Moore       | Violet      | Buzzbean       |\r\n| Linda       | Gray        | Violet      | Fadeo          |\r\n+-------------+-------------+-------------+----------------+\r\n17 rows selected (1.026 seconds)\r\n<\/code><\/pre>\n
\u867d\u7136\u8fd9\u4e2a\u67e5\u8be2\u6ca1\u6709\u592a\u591a\u610f\u4e49\uff0c\u4f46\u662f\u80fd\u6210\u529f\u5730\u8fdb\u884c\u4e86\u8fde\u63a5\u3002\u592a\u597d\u4e86\u3002<\/p>\n
\u5982\u679c\u6709\u53ef\u7528\u4e8e\u5de5\u4f5c\u7684\u6848\u4f8b\uff0c\u6211\u5c06\u5c1d\u8bd5\u5728\u5927\u89c4\u6a21\u6570\u636e\u548cSpark\u4e0a\u8fdb\u884c\u9a8c\u8bc1\u548c\u6bd4\u8f83\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5728\u5348\u9910\u65f6\uff0c\u6211\u7a0d\u5fae\u542c\u8bf4\u4e86Apache Drill\u7684\u4e8b\u60c5\u3002 \u542c\u8bf4\u5b83\u53ef\u4ee5\u4f7f\u7528\u7c7b\u4f3cSQL\u7684\u67e5\u8be2\u5c06\u4efb\u4f55RDS\u3001Dynam […]<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-36567","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\n\u6211\u5c1d\u8bd5\u7528Apache Drill\u7f16\u7a0b\u7684\u4f53\u9a8c - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u6211\u5c1d\u8bd5\u7528apache-drill\u7f16\u7a0b\u7684\u4f53\u9a8c\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u6211\u5c1d\u8bd5\u7528Apache Drill\u7f16\u7a0b\u7684\u4f53\u9a8c\" \/>\n<meta property=\"og:description\" content=\"\u5728\u5348\u9910\u65f6\uff0c\u6211\u7a0d\u5fae\u542c\u8bf4\u4e86Apache Drill\u7684\u4e8b\u60c5\u3002 \u542c\u8bf4\u5b83\u53ef\u4ee5\u4f7f\u7528\u7c7b\u4f3cSQL\u7684\u67e5\u8be2\u5c06\u4efb\u4f55RDS\u3001Dynam […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u6211\u5c1d\u8bd5\u7528apache-drill\u7f16\u7a0b\u7684\u4f53\u9a8c\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-21T10:08:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-04T00:17:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d29ca37434c4406c453ba\/18-0.png\" \/>\n<meta name=\"author\" content=\"\u5b87, \u534e\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u5b87, \u534e\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e7%94%a8apache-drill%e7%bc%96%e7%a8%8b%e7%9a%84%e4%bd%93%e9%aa%8c\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e7%94%a8apache-drill%e7%bc%96%e7%a8%8b%e7%9a%84%e4%bd%93%e9%aa%8c\/\",\"name\":\"\u6211\u5c1d\u8bd5\u7528Apache Drill\u7f16\u7a0b\u7684\u4f53\u9a8c - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-08-21T10:08:48+00:00\",\"dateModified\":\"2024-05-04T00:17:19+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/513018e4e121d3add1b7c5de8be21458\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e7%94%a8apache-drill%e7%bc%96%e7%a8%8b%e7%9a%84%e4%bd%93%e9%aa%8c\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e7%94%a8apache-drill%e7%bc%96%e7%a8%8b%e7%9a%84%e4%bd%93%e9%aa%8c\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e7%94%a8apache-drill%e7%bc%96%e7%a8%8b%e7%9a%84%e4%bd%93%e9%aa%8c\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u6211\u5c1d\u8bd5\u7528Apache Drill\u7f16\u7a0b\u7684\u4f53\u9a8c\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/513018e4e121d3add1b7c5de8be21458\",\"name\":\"\u5b87, \u534e\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/63cd45cbc05a35fc4ff7637a163c83c4962ef58d27472726c3a3e0c9c5194f0f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/63cd45cbc05a35fc4ff7637a163c83c4962ef58d27472726c3a3e0c9c5194f0f?s=96&d=mm&r=g\",\"caption\":\"\u5b87, \u534e\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/yuhua\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e7%94%a8apache-drill%e7%bc%96%e7%a8%8b%e7%9a%84%e4%bd%93%e9%aa%8c\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u6211\u5c1d\u8bd5\u7528Apache Drill\u7f16\u7a0b\u7684\u4f53\u9a8c - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u6211\u5c1d\u8bd5\u7528apache-drill\u7f16\u7a0b\u7684\u4f53\u9a8c\/","og_locale":"zh_CN","og_type":"article","og_title":"\u6211\u5c1d\u8bd5\u7528Apache Drill\u7f16\u7a0b\u7684\u4f53\u9a8c","og_description":"\u5728\u5348\u9910\u65f6\uff0c\u6211\u7a0d\u5fae\u542c\u8bf4\u4e86Apache Drill\u7684\u4e8b\u60c5\u3002 \u542c\u8bf4\u5b83\u53ef\u4ee5\u4f7f\u7528\u7c7b\u4f3cSQL\u7684\u67e5\u8be2\u5c06\u4efb\u4f55RDS\u3001Dynam […]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u6211\u5c1d\u8bd5\u7528apache-drill\u7f16\u7a0b\u7684\u4f53\u9a8c\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-08-21T10:08:48+00:00","article_modified_time":"2024-05-04T00:17:19+00:00","og_image":[{"url":"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d29ca37434c4406c453ba\/18-0.png"}],"author":"\u5b87, \u534e","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u5b87, \u534e","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"4 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e7%94%a8apache-drill%e7%bc%96%e7%a8%8b%e7%9a%84%e4%bd%93%e9%aa%8c\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e7%94%a8apache-drill%e7%bc%96%e7%a8%8b%e7%9a%84%e4%bd%93%e9%aa%8c\/","name":"\u6211\u5c1d\u8bd5\u7528Apache Drill\u7f16\u7a0b\u7684\u4f53\u9a8c - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-08-21T10:08:48+00:00","dateModified":"2024-05-04T00:17:19+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/513018e4e121d3add1b7c5de8be21458"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e7%94%a8apache-drill%e7%bc%96%e7%a8%8b%e7%9a%84%e4%bd%93%e9%aa%8c\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e7%94%a8apache-drill%e7%bc%96%e7%a8%8b%e7%9a%84%e4%bd%93%e9%aa%8c\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e7%94%a8apache-drill%e7%bc%96%e7%a8%8b%e7%9a%84%e4%bd%93%e9%aa%8c\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u6211\u5c1d\u8bd5\u7528Apache Drill\u7f16\u7a0b\u7684\u4f53\u9a8c"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/513018e4e121d3add1b7c5de8be21458","name":"\u5b87, \u534e","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/63cd45cbc05a35fc4ff7637a163c83c4962ef58d27472726c3a3e0c9c5194f0f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/63cd45cbc05a35fc4ff7637a163c83c4962ef58d27472726c3a3e0c9c5194f0f?s=96&d=mm&r=g","caption":"\u5b87, \u534e"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/yuhua\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e6%88%91%e5%b0%9d%e8%af%95%e7%94%a8apache-drill%e7%bc%96%e7%a8%8b%e7%9a%84%e4%bd%93%e9%aa%8c\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/36567","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=36567"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/36567\/revisions"}],"predecessor-version":[{"id":97185,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/36567\/revisions\/97185"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=36567"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=36567"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=36567"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}