It looks like you started Drill in embedded mode and tried querying a distributed file system. Can you connect using distributed mode [1] and connect to the file system [2]. Also I'd expect that port 8020 would work.
[1] https://drill.apache.org/docs/starting-drill-in-distributed-mode/ [2] https://drill.apache.org/docs/file-system-storage-plugin/ On Sat, Oct 17, 2015 at 6:13 AM, Geercken, Uwe <[email protected]> wrote: > Ganesh, > > I think I tried it - cannot verify it right now - on port 9000 and that > did work. > > Give it a try and let me know. I will see if I find time to check during > the day. > > Uwe > ________________________________________ > From: ganesh [[email protected]] > Sent: Saturday, October 17, 2015 6:50 AM > To: [email protected]; [email protected] > Subject: APACHE DRILL : Connect with Hadoop File System // hdfs > > Hello, > > I am new to Apache Drill and need some help. I am able to connect to Local > File systema nd Hive and query the files/ tables respectively. > > But I want to access file on Hadoop. For that I created a new Storage > Plugin, (copied from default dfs) as "hadoop" and changed connection as: > > "connection": "file:///", *ß**----------- "connection" : > "hdfs://192.168.108.133:8020/ <http://192.168.108.133:8020/>",* > > > > Now when I am checking data from DRILL Explorer, its giving connection > error. > I tried to run query after selecting: > *use hadoop;* > 0: jdbc:drill:zk=local> select * from hadoop.`/user/hduser/drill_1.csv`; > Oct 16, 2015 9:35:15 PM > org.apache.calcite.sql.validate.SqlValidatorException <init> > SEVERE: org.apache.calcite.sql.validate.SqlValidatorException: Table > 'hadoop./user/hduser/drill_1.csv' not found > Oct 16, 2015 9:35:15 PM org.apache.calcite.runtime.CalciteException <init> > SEVERE: org.apache.calcite.runtime.CalciteContextException: From line 1, > column 15 to line 1, column 20: Table 'hadoop./user/hduser/drill_1.csv' not > found > Error: PARSE ERROR: From line 1, column 15 to line 1, column 20: Table > 'hadoop./user/hduser/drill_1.csv' not found > > > [Error Id: b97de3f1-d190-48ac-b2f1-a1fb23493fbf on ubuntu:31010] > (state=,code=0) > 0: jdbc:drill:zk=local> > > > Unable to get much help for this on Internet. > I changed port number to: > *50070* ------------> namenode which I can successfully access as: > http://localhost:50070/dfshealth.html#tab-overview > > *54310* -----------------> /home/hduser/hadoop/etc/hadoop/core-site.xml > > > None of these working. Please help > > > > -- > *Name: Ganesh Semalty* > *Location: Gurgaon,Haryana(India)* > *Email Id: [email protected] <[email protected]>* > > > P > > *Please consider the environment before printing this e-mail - SAVE TREE.* >
