Integrating Hive and a BI tool
After you download a Cloudera ODBC or JDBC driver to a HiveServer instance in your cluster, you need to provide the information that the BI tool requires to connect to Hive in CDP.
Depending on the type of driver you obtain, proceed as follows:
- ODBC driver: follow instructions on the ODBC driver download site, and skip the rest of the steps in this procedure.
- JDBC driver: add the driver to the classpath of your JDBC client, such as Tableau. For example, check the client documentation about where to put the driver.
- In Cloudera Manager (CM), click click Actions, and select Download Client Configuration.
hive_on_tez-clientconfig.zip, open beeline-site.xml, and copy the value of
beeline.hs2.jdbc.url.hive_on_tez. This value is the JDBC URL.For example
jdbc:hive2://my_hiveserver.com:2181/;serviceDiscoveryMode=zooKeeper; \ zooKeeperNamespace=hiveserver2
In the BI tool, such as Tableau, configure the JDBC connection using the JDBC URL
and driver class name,