Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

All hadoop distributions include hive-jdbc drivers pre-packaged. The examples shown above 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://myhost.example.com:21050/;auth=noSasl Kerberos: jdbc:hive2://myhost.example.com:21050/;principal=impala/myhost.example.com@H2.EXAMPLE.COM LDAP Auth: jdbc:hive2://myhost.example.com:21050/test_db;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: https://streamsets.com/documentation/datacollector/latest/help/index.html#Configuration/ExternalLibs.html#concept_pdv_qlw_ft

All hadoop distributions include hive-jdbc drivers pre-packaged. The examples shown above 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://myhost.example.com:21050/;auth=noSasl jdbc:hive2://myhost.example.com:21050/;auth=noSasl

Kerberos: jdbc:hive2://myhost.example.com:21050/;principal=impala/myhost.example.com@H2.EXAMPLE.COM jdbc:hive2://myhost.example.com:21050/;principal=impala/myhost.example.com@H2.EXAMPLE.COM

LDAP Auth: jdbc:hive2://myhost.example.com:21050/test_db;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: https://streamsets.com/documentation/datacollector/latest/help/index.html#Configuration/ExternalLibs.html#concept_pdv_qlw_ft

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

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

  • Unsecured: jdbc:hive2://myhost.example.com:21050/;auth=noSasl

  • Kerberos: jdbc:hive2://myhost.example.com:21050/;principal=impala/myhost.example.com@H2.EXAMPLE.COM

  • LDAP Auth: jdbc:hive2://myhost.example.com:21050/test_db;user=fred;password=xyz123

If you proceed to use the impala Impala driver, ensure you install and configure this in the External Directory for Data Collector: https://streamsets.com/documentation/datacollector/latest/help/index.html#Configuration/ExternalLibs.html#concept_pdv_qlw_ftCollector.

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:Impala:

  • Unsecured: jdbc:hive2://myhost.example.com:21050/;auth=noSasl

  • Kerberos: jdbc:hive2://myhost.example.com:21050/;principal=impala/myhost.example.com@H2.EXAMPLE.COM

  • LDAP Auth: jdbc:hive2://myhost.example.com:21050/test_db;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.