You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by wd <wd...@wdicc.com> on 2012/01/02 14:53:27 UTC
Re: Hive command line- select
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 <ad...@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....
Re: Hive command line- select
Posted by vikas Srivastava <ha...@gmail.com>.
@ check you jobtracker or tasktracker is running or not ...
On Mon, Jan 2, 2012 at 7:23 PM, wd <wd...@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 <ad...@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....
>