You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Sharath Akinapally <sh...@innovaccer.com> on 2015/05/07 13:55:14 UTC
Unable to detect files in hadoop file system from apache drill 0.9.0
Hi,
I recently moved drill from 0.8.0 to 0.9.0. Since then, I am unable to
query on json files present in hadoop file system(hdfs).
I had registered a storage plugin named hadoop in drill. I had all my files
in /user/hadoop in hdfs.
But from drill when I query "show files in hadoop.`/user/hadoop/`;" gives
me following error
Query failed: SYSTEM ERROR: Failure handling SQL.
Error: exception while executing query: Failure while executing query.
(state=,code=0)
And when I do query "select * from hadoop.`/user/hadoop/donuts.json`;"
gives me the following error
Query failed: PARSE ERROR: From line 1, column 15 to line 1, column 20:
Table 'hadoop./home/hadoop/donuts.json' not found
I also noticed that web interface of apache drill(<ip-address>:8047) is
unable to load js and css files.
Same queries works fine when I use apache drill 0.8.0.
So are there any extra things I should configure in drill 0.9.0 or am I
missing something?
It would be great if anyone help me with this issue.
Thanks,
--
Regards,
Sharath Akinapally,
Re: Unable to detect files in hadoop file system from apache drill 0.9.0
Posted by Venki Korukanti <ve...@gmail.com>.
Hi Sharath,
Sorry for the trouble. Could you try after adding the following to your
core-site.xml of HDFS on all nodes and restart?
Replace <DrillbitUser> with userName of the user who is running the
Drillbit process.
<property>
<name>hadoop.proxyuser.<DrillbitUser>.hosts</name>
<value>*</value>
</property>
<property>
<name>hadoop.proxyuser.<DrillbitUser>.groups</name>
<value>*</value>
</property>
This seems to be a regression from one of the impersonation changes we
added in 0.9.0
Thanks
Venki
On Thu, May 7, 2015 at 4:55 AM, Sharath Akinapally <
sharath.akinapally@innovaccer.com> wrote:
> Hi,
>
> I recently moved drill from 0.8.0 to 0.9.0. Since then, I am unable to
> query on json files present in hadoop file system(hdfs).
>
> I had registered a storage plugin named hadoop in drill. I had all my files
> in /user/hadoop in hdfs.
>
>
> But from drill when I query "show files in hadoop.`/user/hadoop/`;" gives
> me following error
>
> Query failed: SYSTEM ERROR: Failure handling SQL.
> Error: exception while executing query: Failure while executing query.
> (state=,code=0)
>
> And when I do query "select * from hadoop.`/user/hadoop/donuts.json`;"
> gives me the following error
>
> Query failed: PARSE ERROR: From line 1, column 15 to line 1, column 20:
> Table 'hadoop./home/hadoop/donuts.json' not found
>
> I also noticed that web interface of apache drill(<ip-address>:8047) is
> unable to load js and css files.
>
> Same queries works fine when I use apache drill 0.8.0.
>
> So are there any extra things I should configure in drill 0.9.0 or am I
> missing something?
>
> It would be great if anyone help me with this issue.
>
> Thanks,
> --
> Regards,
> Sharath Akinapally,
>