Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (athena.apache.org: domain of justlooks@gmail.com
 designates 209.85.219.43 as permitted sender)
MIME-Version: 1.0
Date: Tue, 16 Jul 2013 16:10:16 +0800
Message-ID: 
 <CACeqxwQTMfELPe4=ZDE+z92b-VLcqCP=kiOTYWUpaOBkj4oLNw@mail.gmail.com>
Subject: can hive use where clause in jdbc?
From: ch huang <justlooks@gmail.com>
To: user@hive.apache.org
Content-Type: multipart/alternative; boundary=089e011774cdde24cf04e19c8183

--089e011774cdde24cf04e19c8183
Content-Type: text/plain; charset=ISO-8859-1

here is my test output,why the beeline report error when i use where
condition??

hive> select foo from demo_hive where bar='value3';
Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_1373509276088_0015, Tracking URL =
http://CH22:8088/proxy/application_1373509276088_0015/<http://ch22:8088/proxy/application_1373509276088_0015/>
Kill Command = /usr/lib/hadoop/bin/hadoop job  -kill job_1373509276088_0015
Hadoop job information for Stage-1: number of mappers: 1; number of
reducers: 0
2013-07-16 16:00:05,538 Stage-1 map = 0%,  reduce = 0%
2013-07-16 16:00:11,958 Stage-1 map = 100%,  reduce = 0%, Cumulative CPU
5.6 sec
MapReduce Total cumulative CPU time: 5 seconds 600 msec
Ended Job = job_1373509276088_0015
MapReduce Jobs Launched:
Job 0: Map: 1   Cumulative CPU: 5.6 sec   HDFS Read: 245 HDFS Write: 2
SUCCESS
Total MapReduce CPU Time Spent: 5 seconds 600 msec
OK
3
Time taken: 15.236 seconds

0: jdbc:hive2://192.168.10.22:10000> select foo from demo_hive where
bar='value3';
Error: Error while processing statement: FAILED: Execution Error, return
code 1 from org.apache.hadoop.hive.ql.exec.MapRedTask (state=08S01,code=1)
Error: Error while processing statement: FAILED: Execution Error, return
code 1 from org.apache.hadoop.hive.ql.exec.MapRedTask (state=08S01,code=1)

--089e011774cdde24cf04e19c8183
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div>here is my test output,why the beeline report error when i use where c=
ondition??</div>
<div>=A0</div>
<div>hive&gt; select foo from demo_hive where bar=3D&#39;value3&#39;;<br>To=
tal MapReduce jobs =3D 1<br>Launching Job 1 out of 1<br>Number of reduce ta=
sks is set to 0 since there&#39;s no reduce operator<br>Starting Job =3D jo=
b_1373509276088_0015, Tracking URL =3D <a href=3D"http://ch22:8088/proxy/ap=
plication_1373509276088_0015/">http://CH22:8088/proxy/application_137350927=
6088_0015/</a><br>
Kill Command =3D /usr/lib/hadoop/bin/hadoop job=A0 -kill job_1373509276088_=
0015<br>Hadoop job information for Stage-1: number of mappers: 1; number of=
 reducers: 0<br>2013-07-16 16:00:05,538 Stage-1 map =3D 0%,=A0 reduce =3D 0=
%<br>2013-07-16 16:00:11,958 Stage-1 map =3D 100%,=A0 reduce =3D 0%, Cumula=
tive CPU 5.6 sec<br>
MapReduce Total cumulative CPU time: 5 seconds 600 msec<br>Ended Job =3D jo=
b_1373509276088_0015<br>MapReduce Jobs Launched:<br>Job 0: Map: 1=A0=A0 Cum=
ulative CPU: 5.6 sec=A0=A0 HDFS Read: 245 HDFS Write: 2 SUCCESS<br>Total Ma=
pReduce CPU Time Spent: 5 seconds 600 msec<br>
OK<br>3<br>Time taken: 15.236 seconds<br></div>
<div>=A0</div>
<div>0: jdbc:hive2://<a href=3D"http://192.168.10.22:10000">192.168.10.22:1=
0000</a>&gt; select foo from demo_hive where bar=3D&#39;value3&#39;;<br>Err=
or: Error while processing statement: FAILED: Execution Error, return code =
1 from org.apache.hadoop.hive.ql.exec.MapRedTask (state=3D08S01,code=3D1)<b=
r>
Error: Error while processing statement: FAILED: Execution Error, return co=
de 1 from org.apache.hadoop.hive.ql.exec.MapRedTask (state=3D08S01,code=3D1=
)<br></div>

--089e011774cdde24cf04e19c8183--