[ https://issues.apache.org/jira/browse/DRILL-3945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ganesh semalty updated DRILL-3945: ---------------------------------- Environment: hduser@ubuntu:~/apache-drill-1.1.0/log$ cd hduser@ubuntu:~$ hadoop version Hadoop 2.6.0 Subversion https://git-wip-us.apache.org/repos/asf/hadoop.git -r e3496499ecb8d220fba99dc5ed4c99c8f9e33bb1 Compiled by jenkins on 2014-11-13T21:10Z Compiled with protoc 2.5.0 >From source with checksum 18e43357c8f927c0695f1e9522859d6a This command was run using /home/hduser/hadoop/share/hadoop/common/hadoop-common-2.6.0.jar > 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: hduser@ubuntu:~/apache-drill-1.1.0/log$ cd > hduser@ubuntu:~$ hadoop version > Hadoop 2.6.0 > Subversion https://git-wip-us.apache.org/repos/asf/hadoop.git -r > e3496499ecb8d220fba99dc5ed4c99c8f9e33bb1 > Compiled by jenkins on 2014-11-13T21:10Z > Compiled with protoc 2.5.0 > From source with checksum 18e43357c8f927c0695f1e9522859d6a > This command was run using > /home/hduser/hadoop/share/hadoop/common/hadoop-common-2.6.0.jar > 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)