Getting the JDBC or ODBC driver in Data Hub

You need to download the Apache Hive JDBC driver or the Simba ODBC driver to a HiveServer instance in your Data Hub cluster. In the BI tool, you need to provide the information that the BI tool requires to connect to Hive in CDP.

When you start the Hive shell, the recommended JDBC JAR version use appears in the output:
. . .
Connected to: Apache Hive (version 3.1.2000.7.0.3.0-117)
Driver: Hive JDBC (version 3.1.2000.7.0.3.0-117)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 3.1.2000.7.0.3.0-117 by Apache Hive
0: jdbc:hive2://172.27.133.67:10000/default> 
Download the JDBC driver from the Hortonworks Repository.