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
