NOTE: Hive over JDBC is no longer supported.
Issue:
Pipeline failing with JDBC_00 and JDBC_06
:JDBC_00 - Cannot connect to specified database: com.streamsets.pipeline.api.StageException: JDBC_06 - Failed to initialize connection pool: java.lang.RuntimeException: Unable to get driver instance for jdbcUrl=jdbc:hive2://localhost:10000/default : JDBC Connection String
Solution:
Instead of installing Apache drivers from the CDH stage libs a user should download drivers for Hive 2 (e.g. Cloudera Hive JDBC drivers). The Apache drivers from CDH stage libs seem to be of Hive version 1 and the JDBC stage needs the drivers of Hive version 2.
Note: When using Cloudera HIVE JDBC driver, the JDBC URL String may look different. You can check our knowledgebase article Hive JDBC Connection Strings to see some examples. However, we also recommend checking the driver's documentation for details.
