[ https://issues.apache.org/jira/browse/DRILL-3945?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14962153#comment-14962153 ]
ganesh semalty commented on DRILL-3945: --------------------------------------- Hi, The issue resolved. I was using DRILL in embeded mode. I tried with storage plugin as:- "connection": "hdfs://localhost:54310/", Earlier I was getting connection error. I restarted "HADOOP" and then tried again, and it worked. I am not sure why hadoop needs to be restarted. I haven't changed any configurations. The issue can be closed now. > Unable to connect to Haddop file system through apache drill > ------------------------------------------------------------ > > Key: DRILL-3945 > URL: https://issues.apache.org/jira/browse/DRILL-3945 > Project: Apache Drill > Issue Type: Bug > Components: Functions - Drill > Affects Versions: 1.1.0 > Environment: Environment > hduser@ubuntu:~/apache-drill-1.1.0/log$ cd > hduser@ubuntu:~$ hadoop version > Hadoop 2.6.0 > Reporter: ganesh semalty > > 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/", > 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 -- This message was sent by Atlassian JIRA (v6.3.4#6332)