[ 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