If you are using a Hive connector on a Cloudera Distribution for Hadoop (CDH) implementation, there is a reported bug on CDH 5.7.
If you are using any CDH implementation with Sentry enabled, you must also perform this task because Sentry does not allow use of ADD JAR commands.
-
To resolve the bug, add the following to the class path for the Hive connector:
/opt/teradata/tdqg/connector/tdqg-hive-connector/version/lib/hive-loaderfactory-version.jar /opt/teradata/tdqg/connector/tdqg-hive-connector/version/lib/log4j--api-2.7.jar /opt/teradata/tdqg/connector/tdqg-hive-connector/version/lib/log4j-core-2.7.jar
You can add the syntax in many ways. One way is to modify the HIVE_AUX_JARS_PATH. - If required, restart Hive.