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
|