./bin/drill-embedded
OpenJDK 64-Bit Server VM warning: ignoring option MaxPermSize=512M; support was removed in 8.0
Apr 19, 2017 4:53:50 PM org.glassfish.jersey.server.ApplicationHandler initialize
INFO: Initiating Jersey application, version Jersey: 2.8 2014-04-29 01:25:26...
apache drill 1.10.0
"drill baby drill"
Now visit link http://localhost:8047 to open up Apache Drill explorer and configure S3 storage plugin refer
0: jdbc:drill:zk=local> USE `s3-lake`.`root`;
+-------+--------------------------------------------+
| ok | summary |
+-------+--------------------------------------------+
| true | Default schema changed to [s3-lake.root] |
+-------+--------------------------------------------+
1 row selected (19.958 seconds)
0: jdbc:drill:zk=local>
Download Lake Erie Fishing DataSet and upload to lake
bucket using mc
.
mc cp *.csv myminio/lake
Fetch and query the csv file from Minio server.
0: jdbc:drill:zk=local> SELECT * FROM `WB_Catch.csv`;
+---------+
| columns |
+---------+
| ["541","1312","17","9","2015","Autumn","10.9728","7.8","923.0932326","7200.127214","0.720012721","Yellow Perch","YAO","0","0","0","0","41.46292","-82.24912\r"] |
| ["541","1312","17","9","2015","Autumn","10.9728","7.8","923.0932326","7200.127214","0.720012721","Yellow Perch","YOY","5.136012696","0.020919384","7.133224933","0.029054186","41.46292","-82.24912\r"] |
+---------+
36,901 rows selected (14.931 seconds)