Home Forums Hive / HCatalog Hbase Hive integration

This topic contains 0 replies, has 1 voice, and was last updated by  Nitin Gupta 6 months ago.

  • Creator
    Topic
  • #52305

    Nitin Gupta
    Participant

    Hi,
    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;
    SET hive.zookeeper.client.port=2181;

    DROP table gw_summary_hbase;

    CREATE EXTERNAL TABLE gw_summary_hbase
    (
    metric_ts timestamp,
    country string,
    bids BIGINT,
    calls BIGINT,
    mou BIGINT,
    seizures BIGINT
    )
    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 ?

You must be logged in to reply to this topic.