drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alan Miller <Alan.Mil...@synopsys.com>
Subject RE: [newbie]: how to query HDFS
Date Fri, 22 May 2015 15:58:25 GMT
Thanks, yes it works now! The backtick was my problem.

I can query a remote CDH5 HDFS from node1 (not part of the cluster) but I 
can't query a remote CDH5 HDFS. But that's not an issue for me. 
Thanks for the quick responses.

0: jdbc:drill:drillbit=localhost>  select job_number,submit_time from hdfs_cdh5.root.`/tmp/test.par`
limit 5;
+-------------+--------------+
| job_number  | submit_time  |
+-------------+--------------+
| 1700692497  | 1430313605   |
| 1786732386  | 1430319046   |
| 290092620   | 1430315818   |
| 1556821944  | 1430321161   |
| 157926450   | 1430313079   |
+-------------+--------------+

Alan
Mime
View raw message