[
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
<property>
<name>hadoop.proxyuser.<DrillbitUser>.hosts</name>
<value>*</value>
</property>
<property>
<name>hadoop.proxyuser.<DrillbitUser>.groups</name>
<value>*</value>
</property>
<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 dfs)
> 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 error
> 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
(v6.3.4#6332)
