@ check you jobtracker or tasktracker is running or not ... On Mon, Jan 2, 2012 at 7:23 PM, wd <w...@wdicc.com> wrote:
> Because 'select *' will not run map reduce job, may be you should > check if your hadoop cluster is work > > On Mon, Jan 2, 2012 at 10:37 AM, Aditya Kumar <adityakumar...@yahoo.com> > wrote: > > > > 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.... >
