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.
. . . 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.