Return-Path: X-Original-To: apmail-hadoop-mapreduce-user-archive@minotaur.apache.org Delivered-To: apmail-hadoop-mapreduce-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 636DB10C0D for ; Thu, 20 Mar 2014 21:00:53 +0000 (UTC) Received: (qmail 54846 invoked by uid 500); 20 Mar 2014 21:00:36 -0000 Delivered-To: apmail-hadoop-mapreduce-user-archive@hadoop.apache.org Received: (qmail 54698 invoked by uid 500); 20 Mar 2014 21:00:30 -0000 Mailing-List: contact user-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hadoop.apache.org Delivered-To: mailing list user@hadoop.apache.org Received: (qmail 54677 invoked by uid 99); 20 Mar 2014 21:00:25 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 20 Mar 2014 21:00:25 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,NORMAL_HTTP_TO_IP,RCVD_IN_DNSWL_NONE,SPF_PASS,WEIRD_PORT X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [98.138.91.247] (HELO nm25-vm5.bullet.mail.ne1.yahoo.com) (98.138.91.247) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 20 Mar 2014 21:00:20 +0000 Received: from [98.138.101.132] by nm25.bullet.mail.ne1.yahoo.com with NNFMP; 20 Mar 2014 20:59:58 -0000 Received: from [98.138.87.12] by tm20.bullet.mail.ne1.yahoo.com with NNFMP; 20 Mar 2014 20:59:58 -0000 Received: from [127.0.0.1] by omp1012.mail.ne1.yahoo.com with NNFMP; 20 Mar 2014 20:59:58 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 714381.77947.bm@omp1012.mail.ne1.yahoo.com Received: (qmail 37545 invoked by uid 60001); 20 Mar 2014 20:59:58 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1395349198; bh=DKsIRmD4xGBV5YEjmD66mXYZdR1NSaeFEnAZPxknIbg=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=4UcxM3cS7gayqjDsFXozwvNOPXQVHvzYm+KiAjMHywyWnY12ceE3PeVMWBiRuIwTnXOK3JJSMyE9hK2Uq9mGqDmvd6OClphFeDCZLxeVB5R8NjlShjDPovuj9Pb2yxMMK31NaeloJLgJkYjQ98v0Crp0hF3nyQ/V8Hl1EN65h18= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=IS1tUD3s5Y/Q93iQRYRyyYEG5DQVH2w0OsX0sdAzD1J9MfBDs3b82bTRyiWwoxpP17r/q6UcfL4ngBb65FbbB937pLi0O/8WO95XaJ5pth60qK4K3lrFaHKMQi2Jjd+yaGKiggMF22NRaH6Y1Hf0oIUl0NcBGIGhlwT6HGxWHBY=; X-YMail-OSG: D.3jtOoVM1kUUY7TGvPK4QPd9wOWJy7IA2QFJKAcuCHT996 haKnhyxQDYpSyxmK_mupFBAkwqTRBlTgj3RZI7lkv_xtAo_HVLZIukvPxkBj GVkDbBZZeWudf4ZjA5KHA4wYI4AH3sHtsxFo8Kk6HsMKaG6S_zZeHOhaEqWm 657TBVzn_uhQhlfcp7tFmz_FjfLlpeKWYEXcrsNveV_tsf_a7IxTBo5Jo84j EP2RsbAR7Nsp_Uef5h7F47TsRFdbPPcQXl2JuX8I19jZ.UTxhGflGZp1tc7s LIJf.nPn0cuWvymychabr5.9gOk86sGAfjfByan.pyVP_rlnhtSS0guCz7ou c90Bs3CRENd5h4spww2n.5st7Jj7OTMGOhobApkI5KOaaKQzgNyrF_dvpoJ3 iqSUIQsnUf8oXpQFr8A36wjFGVFXvO8KaKzULqYSUmZcLound_VbFnNtQ.6i Yn7tuiwPzeoIFATxI.SRP9GF82psKErqi50ZuDvCKiDFEUoJegZZPwB1seLI EsvdWJmdkJTY2WsZ.qppPHBd4G3EiL49XA9OCaR_XgRW8zW9nnBqWN3will2 toMXZMTUR Received: from [151.124.247.200] by web120704.mail.ne1.yahoo.com via HTTP; Thu, 20 Mar 2014 13:59:58 PDT X-Rocket-MIMEInfo: 002.001,SGkgU3plaG9uLAoKSXQgaXMgbm90IHNob3dpbmcgb24gdGhlIGh0dHA6Ly94eXpzZXJ2ZXI6NTAwMzAvam9idHJhY2tlci5qc3AuCgoKSSBjaGVja2VkIHRoaXMgbG9nLiBhbmQgdGhpcyBzaG93cyBhcyAtCgoKL3RtcC9yb290L2hpdmUubG9nCsKgCsKgCsKgZXhlYy5FeGVjRHJpdmVyIChFeGVjRHJpdmVyLmphdmE6YWRkSW5wdXRQYXRocyg4NTMpKSAtIFByb2Nlc3NpbmcKYWxpYXMgdGFibGVfZW1wCmV4ZWMuRXhlY0RyaXZlciAoRXhlY0RyaXZlci5qYXZhOmFkZElucHV0UGF0aHMoODcxKSkgLSBBZGRpbmcBMAEBAQE- X-Mailer: YahooMailWebService/0.8.181.645 References: <1395342573.13252.YahooMailNeo@web120702.mail.ne1.yahoo.com> <1395343780.35573.YahooMailNeo@web120705.mail.ne1.yahoo.com> Message-ID: <1395349198.17872.YahooMailNeo@web120704.mail.ne1.yahoo.com> Date: Thu, 20 Mar 2014 13:59:58 -0700 (PDT) From: Raj Hadoop Reply-To: Raj Hadoop Subject: Re: HiveThrift Service Issue To: "user@hive.apache.org" Cc: "user@hadoop.apache.org" In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="1167350687-111056471-1395349198=:17872" X-Virus-Checked: Checked by ClamAV on apache.org --1167350687-111056471-1395349198=:17872 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi Szehon,=0A=0AIt is not showing on the http://xyzserver:50030/jobtracker.= jsp.=0A=0A=0AI checked this log. and this shows as -=0A=0A=0A/tmp/root/hive= .log=0A=A0=0A=A0=0A=A0exec.ExecDriver (ExecDriver.java:addInputPaths(853)) = - Processing=0Aalias table_emp=0Aexec.ExecDriver (ExecDriver.java:addInputP= aths(871)) - Adding input=0Afile hdfs://xyzserver:8020/user/hive/warehouse/= table_emp =0A2014-03-20 11:57:26,352=0AINFO=A0 exec.ExecDriver (ExecDriver.= java:createTmpDirs(221)) - Making Temp=0ADirectory: =0A=0Ahdfs://xyzserver:= 8020:8020/tmp/hive-root/hi=0Ave_2014-03-20_11-57-25_822_1668300320164798948= -3/-ext-10001=0A2014-03-20 11:57:26,377 ERROR=0Asecurity.UserGroupInformati= on (UserGroupInformation.java:doAs(1411)) -=0APriviledgedActionException as= :root (auth:SIMPLE) =0A=0Acause:org.apache.hadoop.sec=0A=0A=0A=0A=0A=0AOn T= hursday, March 20, 2014 3:53 PM, Szehon Ho wrote:=0A = =0AHi Raj,=0A=0AThere are map-reduce job logs generated if the MapRedTask f= ails, those might give some clue.=0A=0AThanks,=0ASzehon=0A=0A=0A=0A=0AOn Th= u, Mar 20, 2014 at 12:29 PM, Raj Hadoop wrote:=0A=0AI= am struggling on this one. Can any one throw some pointers on how to troub= elshoot this issue please?=0A>=0A>=0A>=0A>=0A>On Thursday, March 20, 2014 3= :09 PM, Raj Hadoop wrote:=0A> =0A>Hello everyone,=0A>= =0A>=0A>The=A0 HiveThrift Service was started succesfully.=0A>=0A>=0A>=0A>n= etstat -nl | grep 10000=0A>=0A>=0A>=0A>=0A>tcp=A0=A0=A0=A0=A0=A0=A0 0=A0=A0= =A0=A0=A0 0 0.0.0.0:10000=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 0.0.0.0= :*=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 LISTEN =0A>=0A>=0A= >=0A>=0A>=0A>I am able to read tables from Hive through Tableau. When execu= ting queries through Tableau I am getting the following error -=0A>=0A>=0A>= Query returned non-zero code: 1, cause: FAILED: Execution Error, return cod= e 1 from org.apache.hadoop.hive.ql.exec.MapRedTask=0A>=0A>=0A>Can any one s= uggest what the problem is ?=0A>=0A>=0A>Regards,=0A>Raj=0A>=0A>=0A> --1167350687-111056471-1395349198=:17872 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Hi Szehon,

It is not showing on the http://xyzserver:5= 0030/jobtracker.jsp.

=0A=0A
I checked this log. and this shows as = -

/tmp/root/hive.log<= /span>
=0A=0A
 
=0A=0A
 
=0A=0A
 exec.ExecDriver (ExecDriver.java:addInputPaths(853= )) - Processing=0Aalias table_emp
=0A=0A
exec.ExecDriver (ExecDriver.java:addInputPa= ths(871)) - Adding input=0Afile hdfs://xyzserver:8020/user/hive/warehouse/t= able_emp=0A=0A
2014-03-20 11:57:26,352=0AINFO=   exec.ExecDriver (ExecDriver.java:createTmpDirs(221)) - Making Temp= =0ADirectory:
hdfs://xyzserver:8020:8= 020/tmp/hive-root/hi
=0A=0A
ve_2014-03-20_11-57-25_822_1668300320164798948-3/-ext-10= 001
=0A=0A
2014-03-20 11:57:26,377 ERROR=0Asecurity.UserGroupInformation (UserGroupI= nformation.java:doAs(1411)) -=0APriviledgedActionException as:root (auth:SI= MPLE)
cause:org.apache.hadoop.sec

<= div style=3D"display: block;" class=3D"yahoo_quoted">

On Thursday, Ma= rch 20, 2014 3:53 PM, Szehon Ho <szehon@cloudera.com> wrote:
<= div dir=3D"ltr">
Hi Raj,

The= re are map-reduce job logs generated if the MapRedTask fails, those might g= ive some clue.

Thanks,
Szehon


<= div class=3D"yiv3695460328gmail_quote">=0AOn Thu, Mar 20, 2014 at 12:29 PM,= Raj Hadoop <hadoopraj@yahoo.com> wrote:
=0A=0A=0A
I am struggling on this one. Can any one= throw some pointers on how to troubelshoot this issue please?
=0A=0A=0A


=0A=0A=0A
<= font face=3D"Arial"> On Thursday, March 20, 2014 3:09 PM, Raj Hadoop <hadoopraj@yahoo.com&= gt; wrote:
=0A=0A=0A
Hello=0A everyone,
The  HiveThrift Service was = started succesfully.
=0A=0A=0A
<= br clear=3D"none">
=0A=0A=0Anetstat -nl | grep 100= 00


=0A=0A=0Atcp      = ;  0      0 0.0.0.0:10000 =             &nb= sp; 0.0.0.0:*          &n= bsp;        LISTEN
=0A=0A=0A

=0A=0A=0AI am able to read = tables from Hive through Tableau. When executing queries through Tableau I = am getting the following error -
=0A=0A=0A
Query returned non-zero code: 1, cause= : FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exe= c.MapRedTask
=0A=0A=0A

=0A=0A=0ACan any one suggest what the problem is ?

=0A=0A=0AReg= ards,
Raj


=0A=0A=0A



--1167350687-111056471-1395349198=:17872--