hadoop - Hive-Hbase 集成问题 -org/apache/hadoop/hive/hbase/HiveHBaseTableInputFormat

Question

我正在尝试将 Hive 与 Hbase 集成。我正在使用关键 VM

add jar /usr/lib/gphd/hive/lib/hive-hbase-handler-0.12.0-gphd-3.0.0.0.jar
add jar /usr/lib/gphd/hive/lib/guava-11.0.2.jar;
add jar /usr/lib/gphd/hbase/lib/hbase-common.jar;
add jar /usr/lib/gphd/zookeeper/zookeeper.jar;
add jar /usr/lib/gphd/hbase/lib/protobuf-java-2.5.0.jar;

我的配置单元查询如下:

create TABLE hbase_table
(age int, name string,id string,sal string) 
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' 
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,personal data:age,personal data:name,professional data:id,,professional data:sal") 
TBLPROPERTIES ("hbase.table.name" = "employee");  

但它给出了错误:

 Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org/apache/hadoop/hive/hbase/HiveHBaseTableInputFormat

Answer 1

在/etc/hive/conf/hive-env.sh<中将HIVE_AUX_JARS_PATH环境变量更改为/usr/lib/gphd/hbase/lib//

这应该可以解决问题。