Sorry, I meant I can not query a remote CDH 4 cluster.
-----Original Message----- From: Alan Miller [mailto:alan.mil...@synopsys.com] Sent: Friday, May 22, 2015 8:58 AM To: user@drill.apache.org Subject: RE: [newbie]: how to query HDFS 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