Configure the hive-site.xml File

1.
  1. Open the hive-site.xml file with your favorite editor, or create a hive-site.xml file if it doesn't already exist:
    $ cd $HIVE_HOME
    $ vi conf/hive-site.xml
  2. Copy the following XML code and paste it into the configuration element block of the hive-site.xml file.
    <configuration>
    
    <property>
      <name>hive.aux.jars.path</name>
      <value>file:///opt/mapr/hive/hive-<version>/lib/hive-hbase-handler-<version>-mapr.jar,
    file:///opt/mapr/hbase/hbase-<version>/lib/hbase-client-<version>-mapr.jar, file:///opt/mapr/hbase/hbase-<version>/lib/hbase-server-<version>-mapr.jar,file:///opt/mapr/hbase/hbase-<version>/lib/hbase-protocol-<version>-mapr.jar,file:///opt/mapr/zookeeper/zookeeper-<version>/zookeeper-<version>.jar</value>
      <description>A comma separated list (with no spaces) of the jar files required for Hive-HBase integration</description>
    </property>
    
    <property>
      <name>hbase.zookeeper.quorum</name>
      <value>xx.xx.x.xxx,xx.xx.x.xxx,xx.xx.x.xxx</value>
      <description>A comma separated list (with no spaces) of the IP addresses of all ZooKeeper servers in the cluster.</description>
    </property>
    
    <property>
      <name>hbase.zookeeper.property.clientPort</name>
      <value>5181</value>
      <description>The Zookeeper client port. The MapR default clientPort is 5181.</description>
    </property>
    
    </configuration>
  3. Save and close the hive-site.xml file.