Using Hive with HBase

To allow Hive scripts to use HBase, proceed as follows.

  1. Install the hive-hbase package.
  2. Add the following statements to the top of each script. Replace the <Guava_version> string with the current version numbers for Guava. (You can find current version numbers for CDH dependencies such as Guava in CDH's root pom.xml file for the current release, for example cdh-root-5.0.0.pom.)
    ADD JAR /usr/lib/hive/lib/zookeeper.jar;
    ADD JAR /usr/lib/hive/lib/hive-hbase-handler.jar
    ADD JAR /usr/lib/hive/lib/guava-<Guava_version>.jar;
    ADD JAR /usr/lib/hive/lib/hbase-client.jar;
    ADD JAR /usr/lib/hive/lib/hbase-common.jar;
    ADD JAR /usr/lib/hive/lib/hbase-hadoop-compat.jar;
    ADD JAR /usr/lib/hive/lib/hbase-hadoop2-compat.jar;
    ADD JAR /usr/lib/hive/lib/hbase-protocol.jar;
    ADD JAR /usr/lib/hive/lib/hbase-server.jar;
    ADD JAR /usr/lib/hive/lib/htrace-core.jar;