drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sharath Akinapally (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-3037) Unable to query on hdfs after moving to 0.9.0 version
Date Tue, 12 May 2015 15:11:00 GMT

    [ https://issues.apache.org/jira/browse/DRILL-3037?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14539989#comment-14539989

Sharath Akinapally commented on DRILL-3037:

Issue resolved after adding the proxy user settings to HDFS core-site.xml. Thanks to venki
for pointing this out.
For those who is facing the same issue had to add the following to core-site.xml


<DrillbitUser> should be replaced by user who is runing the drillbit process.

I will close the issue now.

> Unable to query on hdfs after moving to 0.9.0 version
> -----------------------------------------------------
>                 Key: DRILL-3037
>                 URL: https://issues.apache.org/jira/browse/DRILL-3037
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - Other
>    Affects Versions: 0.9.0
>            Reporter: Sharath Akinapally
>            Assignee: Jacques Nadeau
>             Fix For: 0.9.0
> I  recently moved from drill 0.8.0 to 0.9.0. Since then,I am unable to query on json
files present in hadoop file system( queries working fine on other storage plugins cp and
> I had registered a storage plugin named hadoop in drill. I had all my files in /user/hadoop
in hdfs. 
> When I query "use hadoop;" it returns "true". 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
> Query failed: PARSE ERROR: From line 1, column 15 to line 1, column 20: Table 'hadoop./home/hadoop/donuts.json'
not found
> Same queries worked fine when I use apache drill 0.8.0.
> So are there any extra things I should configure in drill 0.9.0 or is it a bug?

This message was sent by Atlassian JIRA

View raw message