Abhishek, there is no reason to ask Ganesh to move to using distributed mode. That has nothing to do with the error he is experiencing.
Ganesh, I'm currently running Drill on HDFS 2.7.1 and use the following path successfully: hdfs://<ip address>:54310/ -- Jacques Nadeau CTO and Co-Founder, Dremio On Sat, Oct 17, 2015 at 12:31 PM, Abhishek Girish <[email protected] > wrote: > 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.* > > >
