Hive / HCatalog Forum
Hbase Hive integration
I am trying to create an external Hbase table using hive.
here is my hive script for that
ADD jar /usr/lib/hive/lib/hive-hbase-handler-0.12.0.2.0.6.1-101.jar;
ADD jar /usr/lib/hbase/lib/hbase-client-0.96.1.2.0.6.1-101-hadoop2.jar;
ADD jar /usr/lib/hbase/lib/hbase-common-0.96.1.2.0.6.1-101-hadoop2.jar;
ADD jar /usr/lib/hbase/lib/hbase-protocol-0.96.1.2.0.6.1-101-hadoop2.jar;
ADD jar /usr/lib/hbase/lib/hbase-server-0.96.1.2.0.6.1-101-hadoop2.jar;
ADD jar /usr/lib/hbase/lib/htrace-core-2.01.jar;
ADD jar /usr/lib/hcatalog/share/hcatalog/hcatalog-core.jar;
ADD jar /usr/lib/zookeeper/zookeeper.jar;
ADD jar /usr/lib/hive/lib/guava-12.0.1.jar;
SET hbase.zookeeper.quorum=hadoop-master-01.dev, hadoop-master-02.dev, hadoop-slave-edge-01.dev;
DROP table gw_summary_hbase;
CREATE EXTERNAL TABLE gw_summary_hbase
COMMENT ‘GW Calls – in hbase’
STORED BY ‘org.apache.hadoop.hive.hbase.HBaseStorageHandler’
WITH SERDEPROPERTIES (
“hbase.columns.mapping” = “:key,summary:timestamp,summary:country,summary:bids,summary:calls,summary:mou,summary:seizures”
but is giving the exception, “FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org/apache/hadoop/hbase/HBaseConfiguration”
what may be wrong here ?
The forum ‘Hive / HCatalog’ is closed to new topics and replies.
Support from the Experts
A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.
Become HDP Certified
Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world