incubator-drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mohit Anchlia <mohitanch...@gmail.com>
Subject Re: Error in running select over hdfs
Date Thu, 23 Oct 2014 17:59:23 GMT
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"
> > >     }
> > >   }
> > > }
> > >
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message