hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aditya Kumar <adityakumar...@yahoo.com>
Subject Re: Hive command line- select
Date Mon, 02 Jan 2012 02:37:21 GMT

Hi,
I am able to install hive, and create a table (external) and map it to my Hbasetable.

I am able to do 
hive>select * from maptable;
it works.

But when I give 
hive>select * from maptable where name='testuser"
I am getting the following error.
om
hive> select * from  maptable  where name ='testuser';
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_201112141942_0002, Tracking URL = http://hostxxx-namenode.com:50030/jobdetails.jsp?jobid=job_201112141942_0002
Kill Command = /usr/lib/hadoop/bin/hadoop job  -Dmapred.job.tracker= hostxxx-namenode.com :8021
-kill job_201112141942_0002
2012-01-01 18:17:12,895 Stage-1 map = 0%,  reduce = 0%
2012-01-01 18:17:30,983 Stage-1 map = 100%,  reduce = 100%
Ended Job = job_201112141942_0002 with errors
FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask

Error in the jobtracker:
2012-01-01 18:34:26,847 INFO org.apache.hadoop.mapred.JobInProgress: Choosing data-local task
task_201112141942_0004_m_000000
2012-01-01 18:34:28,062 INFO org.apache.hadoop.mapred.TaskInProgress: Error from attempt_201112141942_0004_m_000000_0:
java.io.IOException: Cannot create an instance of InputSplit class = org.apache.hadoop.hive.hbase.HBaseSplit:org.apache.hadoop.hive.hbase.HBaseSplit
        at org.apache.hadoop.hive.ql.io.HiveInputFormat$HiveInputSplit.readFields(HiveInputFormat.java:145)
        at org.apache.hadoop.io.serializer.WritableSerialization$WritableDeserializer.deserialize(WritableSerialization.java:67)
        at org.apache.hadoop.io.serializer.WritableSerialization$WritableDeserializer.deserialize(WritableSerialization.java:40)
        at org.apache.hadoop.mapred.MapTask.getSplitDetails(MapTask.java:348)
        at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:364)
        at org.apache.hadoop.mapred.MapTask.run(MapTask.java:324)
        at org.apache.hadoop.mapred.Child$4.run(Child.java:268)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAs(Subject.java:415)
        at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1115)
        at org.apache.hadoop.mapred.Child.main(Child.java:262)

2012-01-01 18:34:31,092 INFO org.apache.hadoop.mapred.JobInProgress: Choosing a failed task
task_201112141942_0004_m_000000

can you please let me know what is the issue and why I am not able to use the select command?
but select *from tablename work....

Mime
View raw message