Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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

  • Unsecured: jdbc:hive2://hive-server2-host.company.com:10000/dbName
  • LDAP Auth: jdbc:hive2://hive-server2-host.company.com:10000/dbName;user=username;password=*
  • Kerberos: jdbc:hive2://hive-server2-host.company.com:10000/dbName;principal=hive/hive-server2-host.company.com@COMPANY.COM
  • SSL + Kerberos: jdbc:hive2://hive-server2-host.company.com:10000/dbName;principal=hive/hive-server2-host.company.com@COMPANY.COM;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://hive-server2-host.company.com:10000/dbName
  • LDAP Auth: jdbc:hive2://hive-server2-host.company.com:10000/dbName;AuthMech=3;UID=username;PWD=*
  • Kerberos: jdbc:hive2://hive-server2-host.company.com:10000/dbName;AuthMech=1;KrbRealm=COMPANY.COM;KrbHostFQDN=hive-server2-host.company.com;KrbServiceName=hive
  • SSL + Kerberos: jdbc:hive2://hive-server2-host.company.com:10000/dbName;AuthMech=1;KrbRealm=COMPANY.COM;KrbHostFQDN=hive-server2-host.company.com;KrbServiceName=hive;SSL=1;SSLKeyStore=/path/to/truststore.jks

Cloudera also has an Impala driver. Install it via Maven (more info here). Using the Cloudera Impala driver:

  • Unsecured: jdbc:impala://impala-daemon-host.company.com:21050/dbName
  • LDAP Auth: jdbc:impala://impala-daemon-host.company.com:21050/dbName;AuthMech=3;UID=username;PWD=*
  • Kerberos: jdbc:impala://impala-daemon-host.company.com:21050/dbName;AuthMech=1;KrbRealm=COMPANY.COM;KrbHostFQDN=impala-daemon-host.company.com;KrbServiceName=impala
  • SSL + Kerberos: jdbc:impala://impala-daemon-host.company.com:21050/dbName;AuthMech=1;KrbRealm=COMPANY.COM;KrbHostFQDN=impala-daemon-host.company.com;KrbServiceName=impala;SSL=1;SSLKeyStore=/path/to/truststore.jks

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

  • Unsecured: jdbc:hive2://hive-server2-host.company.com:10000/dbName
  • LDAP Auth: jdbc:hive2://hive-server2-host.company.com:10000/dbName;user=username;password=*
  • Kerberos: jdbc:hive2://hive-server2-host.company.com:10000/dbName;principal=hive/hive-server2-host.company.com@COMPANY.COM
  • SSL + Kerberos: jdbc:hive2://hive-server2-host.company.com:10000/dbName;principal=hive/hive-server2-host.company.com@COMPANY.COM;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://hive-server2-host.company.com:10000/dbName
  • LDAP Auth: jdbc:hive2://hive-server2-host.company.com:10000/dbName;AuthMech=3;UID=username;PWD=*
  • Kerberos: jdbc:hive2://hive-server2-host.company.com:10000/dbName;AuthMech=1;KrbRealm=COMPANY.COM;KrbHostFQDN=hive-server2-host.company.com;KrbServiceName=hive
  • SSL + Kerberos: jdbc:hive2://hive-server2-host.company.com:10000/dbName;AuthMech=1;KrbRealm=COMPANY.COM;KrbHostFQDN=hive-server2-host.company.com;KrbServiceName=hive;SSL=1;SSLKeyStore=/path/to/truststore.jks

Cloudera also has an Impala driver. Install Download it via Maven (more info from Cloudera here). . Using the Cloudera Impala driver:

  • Unsecured: jdbc:impala://impala-daemon-host.company.com:21050/dbName
  • LDAP Auth: jdbc:impala://impala-daemon-host.company.com:21050/dbName;AuthMech=3;UID=username;PWD=*
  • Kerberos: jdbc:impala://impala-daemon-host.company.com:21050/dbName;AuthMech=1;KrbRealm=COMPANY.COM;KrbHostFQDN=impala-daemon-host.company.com;KrbServiceName=impala
  • SSL + Kerberos: jdbc:impala://impala-daemon-host.company.com:21050/dbName;AuthMech=1;KrbRealm=COMPANY.COM;KrbHostFQDN=impala-daemon-host.company.com;KrbServiceName=impala;SSL=1;SSLKeyStore=/path/to/truststore.jks

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

  • Unsecured: jdbc:hive2://hive-server2-host.company.com:10000/dbName
  • LDAP Auth: jdbc:hive2://hive-server2-host.company.com:10000/dbName;user=username;password=*
  • Kerberos: jdbc:hive2://hive-server2-host.company.com:10000/dbName;principal=hive/hive-server2-host.company.com@COMPANY.COM
  • SSL + Kerberos: jdbc:hive2://hive-server2-host.company.com:10000/dbName;principal=hive/hive-server2-host.company.com@COMPANY.COM;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://hive-server2-host.company.com:10000/dbName
  • LDAP Auth: jdbc:hive2://hive-server2-host.company.com:10000/dbName;AuthMech=3;UID=username;PWD=*
  • Kerberos: jdbc:hive2://hive-server2-host.company.com:10000/dbName;AuthMech=1;KrbRealm=COMPANY.COM;KrbHostFQDN=hive-server2-host.company.com;KrbServiceName=hive
  • SSL + Kerberos: jdbc:hive2://hive-server2-host.company.com:10000/dbName;AuthMech=1;KrbRealm=COMPANY.COM;KrbHostFQDN=hive-server2-host.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://impala-daemon-host.company.com:21050/dbName
  • LDAP Auth: jdbc:impala://impala-daemon-host.company.com:21050/dbName;AuthMech=3;UID=username;PWD=*
  • Kerberos: jdbc:impala://impala-daemon-host.company.com:21050/dbName;AuthMech=1;KrbRealm=COMPANY.COM;KrbHostFQDN=impala-daemon-host.company.com;KrbServiceName=impala
  • SSL + Kerberos: jdbc:impala://impala-daemon-host.company.com:21050/dbName;AuthMech=1;KrbRealm=COMPANY.COM;KrbHostFQDN=impala-daemon-host.company.com;KrbServiceName=impala;SSL=1;SSLKeyStore=/path/to/truststore.jks