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 Threaded View
Hive >> mail # user >> Re: Hive command line- select


Copy link to this message
-
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 <[EMAIL PROTECTED]> 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....
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