Return-Path: 
 <issues-return-17151-apmail-drill-issues-archive=drill.apache.org@drill.apache.org>
X-Original-To: apmail-drill-issues-archive@minotaur.apache.org
Delivered-To: apmail-drill-issues-archive@minotaur.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 5EE0817BDA
	for <apmail-drill-issues-archive@minotaur.apache.org>;
 Tue, 12 May 2015 15:11:00 +0000 (UTC)
Received: (qmail 57003 invoked by uid 500); 12 May 2015 15:11:00 -0000
Delivered-To: apmail-drill-issues-archive@drill.apache.org
Received: (qmail 56974 invoked by uid 500); 12 May 2015 15:11:00 -0000
Mailing-List: contact issues-help@drill.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:issues-help@drill.apache.org>
List-Unsubscribe: <mailto:issues-unsubscribe@drill.apache.org>
List-Post: <mailto:issues@drill.apache.org>
List-Id: <issues.drill.apache.org>
Reply-To: dev@drill.apache.org
Delivered-To: mailing list issues@drill.apache.org
Received: (qmail 56960 invoked by uid 99); 12 May 2015 15:11:00 -0000
Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 May 2015 15:11:00 +0000
Date: Tue, 12 May 2015 15:11:00 +0000 (UTC)
From: "Sharath Akinapally (JIRA)" <jira@apache.org>
To: issues@drill.apache.org
Message-ID: <JIRA.12829189.1431437632000.87627.1431443460021@Atlassian.JIRA>
In-Reply-To: <JIRA.12829189.1431437632000@Atlassian.JIRA>
References: <JIRA.12829189.1431437632000@Atlassian.JIRA>
 <JIRA.12829189.1431437632144@arcas>
Subject: [jira] [Commented] (DRILL-3037) Unable to query on hdfs after
 moving to 0.9.0 version
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394


    [ 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)