Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> can hive use where clause in jdbc?


Copy link to this message
-
can hive use where clause in jdbc?
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)
+
Thejas Nair 2013-07-17, 22:29
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB