Could you try running 'show files' from the sqllline prompt to see if that gives you any results for files Drill is able to find?
On Thu, Oct 23, 2014 at 10:43 AM, Mohit Anchlia <[email protected]> wrote: > Could somebody look at this error and advise what might be wrong? It seems > I am doing everything that's documented. > On Wed, Oct 22, 2014 at 2:20 PM, Mohit Anchlia <[email protected]> > wrote: > > > I am getting the following error even though that file exists in hdfs > > > > 0: jdbc:drill:zk=local> select * from > > hdfs.`/user/train/xd/tweets/tmp/tweets-0.txt`; > > Oct 22, 2014 5:16:31 PM org.eigenbase.sql.validate.SqlValidatorException > > <init> > > SEVERE: org.eigenbase.sql.validate.SqlValidatorException: Table > > 'hdfs./user/train/xd/tweets/tmp/tweets-0.txt' not found > > Oct 22, 2014 5:16:31 PM org.eigenbase.util.EigenbaseException <init> > > SEVERE: org.eigenbase.util.EigenbaseContextException: From line 1, column > > 15 to line 1, column 18: Table > > 'hdfs./user/train/xd/tweets/tmp/tweets-0.txt' not found > > Query failed: Failure while parsing sql. Table > > 'hdfs./user/train/xd/tweets/tmp/tweets-0.txt' not found > > [7e1d5c73-0521-480e-b74b-a4fa50e3f4a7] > > Error: exception while executing query: Failure while trying to get next > > result batch. (state=,code=0) > > > > > > I created new plugin called hdfs. > > > > { > > "type": "file", > > "enabled": true, > > "connection": "hdfs://10.225.156.201:9000/", > > "workspaces": { > > "json": { > > "location": "/user/train/xd/tweets/tmp", > > "writable": false, > > "storageformat": "json" > > } > > }, > > "formats": { > > "json": { > > "type": "json" > > } > > } > > } > > >
