Hive 2.3.7-2009 (EEP 7.0.0) Release Notes

• none: disable hive.fetch.task.conversion
• minimal: SELECT *, filter on partition columns, LIMIT only
• more: SELECT, filter, LIMIT only (support TABLESAMPLE and virtual columns)

<property>
    <name>javax.jdo.option.ConnectionURL</name>
    <value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true</value>
</property>
<property>
    <name>javax.jdo.option.ConnectionDriverName</name>
    <value>com.mysql.jdbc.Driver</value>
    <description>Driver class name for a JDBC metastore</description>
</property>

org.apache.hadoop.hbase.client.mapr.BaseTableMappingRules
    at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:581)
    at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:178)
    at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:522)
    ... 39 more

Workaround

This workaround resolves the issue when running HBase 1.4.12 with Hive 2.3 on Tez 0.9 in an environment with Hadoop 2.7.4 and ZooKeeper 3.5.6.0 in ecosystem release 2009.

To resolve the issue, complete the following steps before you run HBase with Hive-on-Tez:

1. Create the /apps/tez/tez-0.9/hbase directory:

   hadoop fs -mkdir /apps/tez/tez-0.9/hbase

2. Add the HBase JAR files to the /apps/tez/tez-0.9/hbase directory:

   hadoop fs -put /opt/mapr/hbase/hbase-1.4.12/lib/* /apps/tez/tez-0.9/hbase/

3. Update /opt/mapr/tez/tez-0.9/conf/tez-site.xml with the following property:

   <property>
       <name>tez.lib.uris</name>    
       <value>${fs.defaultFS}/apps/tez/tez-0.9,${fs.defaultFS}/apps/tez/tez-0.9/lib,${fs.defaultFS}/apps/tez/tez-0.9/hbase/</value>
   </property>