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: 
 <CAOT3TWqtdaxWu-3qLzNhmsFUH=_Toncwu8QPPscHEFRgc-C=sA@mail.gmail.com>
References: 
 <CAOT3TWqtdaxWu-3qLzNhmsFUH=_Toncwu8QPPscHEFRgc-C=sA@mail.gmail.com>
Date: Thu, 23 Oct 2014 10:43:32 -0700
Message-ID: 
 <CAOT3TWouoDXC+z0w78ywDz0o-pwg+9EHZE5gnPRQiGR_HxGk-g@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=001a1141bd5867a45b05061a9ae8

--001a1141bd5867a45b05061a9ae8
Content-Type: text/plain; charset=UTF-8

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"
>     }
>   }
> }
>

--001a1141bd5867a45b05061a9ae8--