Ask Your Question

How do you configure a Hive / Impala JDBC driver for Data Collector?

asked 2017-05-08 16:48:26 -0500

jeff gravatar image

updated 2017-08-23 10:31:36 -0500

metadaddy gravatar image

What driver Jar/class is supported, and how is the JDBC URI configured?

edit retag flag offensive close merge delete

2 Answers

Sort by ยป oldest newest most voted

answered 2017-05-08 16:53:04 -0500

jeff gravatar image

updated 2017-05-26 14:28:24 -0500

metadaddy gravatar image

StreamSets comes bundled with the open-source Hive JDBC driver. Using the default driver, URLs will look like the following:

  • Unsecured: jdbc:hive2://
  • LDAP Auth: jdbc:hive2://;user=username;password=*
  • Kerberos: jdbc:hive2://;principal=hive/
  • SSL + Kerberos: jdbc:hive2://;principal=hive/;ssl=true;sslTrustStore=/path/to/truststore.jks

Cloudera also provides a Hive driver. To install it, simply install one of the CDH stage libraries. Using the Cloudera Hive driver:

  • Unsecured: jdbc:hive2://
  • LDAP Auth: jdbc:hive2://;AuthMech=3;UID=username;PWD=*
  • Kerberos: jdbc:hive2://;AuthMech=1;KrbRealm=COMPANY.COM;;KrbServiceName=hive
  • SSL + Kerberos: jdbc:hive2://;AuthMech=1;KrbRealm=COMPANY.COM;;KrbServiceName=hive;SSL=1;SSLKeyStore=/path/to/truststore.jks

Cloudera also has an Impala driver. Download it from Cloudera here and install it into SDC. Using the Cloudera Impala driver:

  • Unsecured: jdbc:impala://
  • LDAP Auth: jdbc:impala://;AuthMech=3;UID=username;PWD=*
  • Kerberos: jdbc:impala://;AuthMech=1;KrbRealm=COMPANY.COM;;KrbServiceName=impala
  • SSL + Kerberos: jdbc:impala://;AuthMech=1;KrbRealm=COMPANY.COM;;KrbServiceName=impala;SSL=1;SSLKeyStore=/path/to/truststore.jks
edit flag offensive delete link more


I was wondering about Impala, but haven't had a reason yet to care enough to figure it out. +1!

jwood gravatar imagejwood ( 2017-05-13 18:21:42 -0500 )edit

answered 2017-05-09 14:54:32 -0500

rupal gravatar image

updated 2017-09-05 14:48:56 -0500

metadaddy gravatar image

All Hadoop distributions include hive-jdbc drivers pre-packaged. The examples shown in Jeff's answer will not only work for Cloudera but for all distributions where you want to use the pre-packaged Hive jdbc driver.

You can also use the hive-jdbc driver to connect directly to Impala:

  • Unsecured: jdbc:hive2://;auth=noSasl

  • Kerberos: jdbc:hive2://;principal=impala/

  • LDAP Auth: jdbc:hive2://;user=fred;password=xyz123

If you proceed to use the Impala driver, ensure you install and configure this in the External Directory for Data Collector.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools



Asked: 2017-05-08 16:48:26 -0500

Seen: 8,357 times

Last updated: Sep 05 '17