Hive-Hbase Integration issue -org/apache/hadoop/hive/hbase/HiveHBaseTableInputFormat -
i trying intgrate hive hbase. using pivotal 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;
my hive query below:
create table hbase_table (age int, name string,id string,sal string) stored 'org.apache.hadoop.hive.hbase.hbasestoragehandler' serdeproperties ("hbase.columns.mapping" = ":key,personal data:age,personal data:name,professional data:id,,professional data:sal") tblproperties ("hbase.table.name" = "employee");
but gives error:
execution error, return code 1 org.apache.hadoop.hive.ql.exec.ddltask. org/apache/hadoop/hive/hbase/hivehbasetableinputformat
change hive_aux_jars_path environment variable /usr/lib/gphd/hbase/lib/
in /etc/hive/conf/hive-env.sh
this should resolve issue.
Comments
Post a Comment