Mailing-List: contact drill-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: drill-user@incubator.apache.org
MIME-Version: 1.0
In-Reply-To: 
 <CAH-_v4Ju317mBmmeLpPQ4EkUVE-W5DtDGiev+N5bzMA+gyJRiw@mail.gmail.com>
References: 
 <CAOT3TWqtdaxWu-3qLzNhmsFUH=_Toncwu8QPPscHEFRgc-C=sA@mail.gmail.com>
	<CAOT3TWouoDXC+z0w78ywDz0o-pwg+9EHZE5gnPRQiGR_HxGk-g@mail.gmail.com>
	<CAMpYv7AKy3rT_nunRwqcpyQotMh5VdPUC9m1mbpi1eGq1tOrdg@mail.gmail.com>
	<CAOT3TWo81ceeH65pwH5U74WFOkRr8ybP7Prb-Y4PjGPxdp0tVg@mail.gmail.com>
	<CAH-_v4Ju317mBmmeLpPQ4EkUVE-W5DtDGiev+N5bzMA+gyJRiw@mail.gmail.com>
Date: Thu, 23 Oct 2014 11:11:30 -0700
Message-ID: 
 <CAOT3TWpFbVvLNcZziwHrn_a8a=YFA-wQdGdKQFwnnZBCtcBhdA@mail.gmail.com>
Subject: Re: Error in running select over hdfs
From: Mohit Anchlia <mohitanchlia@gmail.com>
To: drill-user@incubator.apache.org
Content-Type: multipart/alternative; boundary=089e0111bffe61dd5205061afef0

--089e0111bffe61dd5205061afef0
Content-Type: text/plain; charset=UTF-8

I've tried that too

Error: exception while executing query: Failure while trying to get next
result batch. (state=,code=0)
0: jdbc:drill:zk=local> select * from hdfs.json.`/tweets-0.txt`;
Oct 23, 2014 2:10:40 PM org.eigenbase.sql.validate.SqlValidatorException
<init>
SEVERE: org.eigenbase.sql.validate.SqlValidatorException: Table
'hdfs.json./tweets-0.txt' not found
Oct 23, 2014 2:10:40 PM org.eigenbase.util.EigenbaseException <init>
SEVERE: org.eigenbase.util.EigenbaseContextException: From line 1, column
15 to line 1, column 18: Table 'hdfs.json./tweets-0.txt' not found
Query failed: Failure while parsing sql. Table 'hdfs.json./tweets-0.txt'
not found [619f0469-0606-4e8e-9ae5-17a305f527fe]
Error: exception while executing query: Failure while trying to get next
result batch. (state=,code=0)
0: jdbc:drill:zk=local>

On Thu, Oct 23, 2014 at 11:04 AM, Neeraja Rentachintala <
nrentachintala@maprtech.com> wrote:

> can you just try this.
> select * from hdfs.json.`/tweets-0.txt`;
>
> On Thu, Oct 23, 2014 at 10:59 AM, Mohit Anchlia <mohitanchlia@gmail.com>
> wrote:
>
> > This is what I see, looks like that file is showing up
> >
> > sqlline version 1.1.6
> > 0: jdbc:drill:zk=local> use hdfs.json;
> > +------------+------------+
> > |     ok     |  summary   |
> > +------------+------------+
> > | true       | Default schema changed to 'hdfs.json' |
> > +------------+------------+
> > 1 row selected (1.112 seconds)
> > 0: jdbc:drill:zk=local> show files
> > . . . . . . . . . . . > ;
> >
> >
> +------------+-------------+------------+------------+------------+------------+-------------+------------+------------------+
> > |    name    | isDirectory |   isFile   |   length   |   owner    |
> > group    | permissions | accessTime | modificationTime |
> >
> >
> +------------+-------------+------------+------------+------------+------------+-------------+------------+------------------+
> > | tweets-0.txt | false       | true       | 2097437    | root       |
> > supergroup | rw-r--r--   | 2014-10-22 19:26:15.458 | 2014-10-22
> > 14:04:26.585 |
> > | tweets-1.txt | false       | true       | 1998156    | root       |
> > supergroup | rw-r--r--   | 2014-10-22 14:04:26.616 | 2014-10-22
> > 14:04:37.123 |
> >
> >
> +------------+-------------+------------+------------+------------+------------+-------------+------------+------------------+
> > 2 rows selected (0.264 seconds)
> > 0: jdbc:drill:zk=local>
> >
> > On Thu, Oct 23, 2014 at 10:56 AM, Jason Altekruse <
> > altekrusejason@gmail.com>
> > wrote:
> >
> > > 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 <
> mohitanchlia@gmail.com>
> > > 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 <
> mohitanchlia@gmail.com
> > >
> > > > 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"
> > > > >     }
> > > > >   }
> > > > > }
> > > > >
> > > >
> > >
> >
>

--089e0111bffe61dd5205061afef0--