[ 
https://issues.apache.org/jira/browse/HIVE-2055?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13567801#comment-13567801
 ] 

Guido Serra aka Zeph commented on HIVE-2055:
--------------------------------------------

I have the same issue... I setted up an environment with Cloudera Manager, the 
latest with CDH4

the libraries are available under /usr/lib/hive/lib , and they are correctly in 
the CLASSPATH that gets computed by the hive-env.sh script (I did a print out 
of that), but in any case... they do not seem to get picked up, instead if I 
force them from command line, they work

{code}
[zeph@yallayalla ~]$ hive
Logging initialized using configuration in 
jar:file:/usr/lib/hive/lib/hive-common-0.9.0-cdh4.1.2.jar!/hive-log4j.properties
Hive history file=/tmp/zeph/hive_job_log_zeph_201301311652_675003173.txt
hive> add jar /usr/lib/hive/lib/hive-hbase-handler-0.9.0-cdh4.1.2.jar;
Added /usr/lib/hive/lib/hive-hbase-handler-0.9.0-cdh4.1.2.jar to class path
Added resource: /usr/lib/hive/lib/hive-hbase-handler-0.9.0-cdh4.1.2.jar
hive> add jar /usr/lib/hive/lib/hbase.jar;
Added /usr/lib/hive/lib/hbase.jar to class path
Added resource: /usr/lib/hive/lib/hbase.jar
hive> select count(*) from yallayalla_vendors;                             
Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks determined at compile time: 1
In order to change the average load for a reducer (in bytes):
  set hive.exec.reducers.bytes.per.reducer=<number>
In order to limit the maximum number of reducers:
  set hive.exec.reducers.max=<number>
In order to set a constant number of reducers:
  set mapred.reduce.tasks=<number>
Starting Job = job_201301311629_0008, Tracking URL = 
http://yallayalla:50030/jobdetails.jsp?jobid=job_201301311629_0008
Kill Command = /usr/lib/hadoop/bin/hadoop job  
-Dmapred.job.tracker=yallayalla:8021 -kill job_201301311629_0008
Hadoop job information for Stage-1: number of mappers: 1; number of reducers: 1
2013-01-31 16:52:50,532 Stage-1 map = 0%,  reduce = 0%
2013-01-31 16:52:56,591 Stage-1 map = 100%,  reduce = 0%, Cumulative CPU 2.32 
sec
2013-01-31 16:52:57,601 Stage-1 map = 100%,  reduce = 0%, Cumulative CPU 2.32 
sec
2013-01-31 16:52:58,608 Stage-1 map = 100%,  reduce = 0%, Cumulative CPU 2.32 
sec
2013-01-31 16:52:59,615 Stage-1 map = 100%,  reduce = 0%, Cumulative CPU 2.32 
sec
2013-01-31 16:53:00,629 Stage-1 map = 100%,  reduce = 100%, Cumulative CPU 4.14 
sec
2013-01-31 16:53:01,641 Stage-1 map = 100%,  reduce = 100%, Cumulative CPU 4.14 
sec
MapReduce Total cumulative CPU time: 4 seconds 140 msec
Ended Job = job_201301311629_0008
MapReduce Jobs Launched: 
Job 0: Map: 1  Reduce: 1   Cumulative CPU: 4.14 sec   HDFS Read: 0 HDFS Write: 
0 SUCCESS
Total MapReduce CPU Time Spent: 4 seconds 140 msec
OK
749
Time taken: 20.024 seconds
hive> 
{code}
                
> Hive HBase Integration issue
> ----------------------------
>
>                 Key: HIVE-2055
>                 URL: https://issues.apache.org/jira/browse/HIVE-2055
>             Project: Hive
>          Issue Type: Bug
>          Components: HBase Handler
>            Reporter: sajith v
>
> Created an external table in hive , which points to the HBase table. When 
> tried to query a column using the column name in select clause got the 
> following exception : ( java.lang.ClassNotFoundException: 
> org.apache.hadoop.hive.hbase.HiveHBaseTableInputFormat), errorCode:12, 
> SQLState:42000)

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to