question Re: Cannot Create Hive Connection Pool. in Archives of Support Questions (Read Only)

Cannot Create Hive Connection Pool.

saikrishna_tara — Sun, 18 Aug 2019 11:51:42 GMT

Hi,

I am getting errors while trying to connect to Hive in out Kerberized HADOOP cluster. Here is what i am doing..

Nifi config properties:

# kerberos #

nifi.kerberos.krb5.file=/etc/krb5.conf

# kerberos service principle #

nifi.kerberos.service.principal=nifi/ourserver@ourdomain nifi.kerberos.service.keytab.location=/etc/security/keytabs/nifi.keytab

Configure Controller Service

as soon as i enable it i see some warnings..

and getting these errors when i tried to use the connection in SelectHiveQL process

16:33:08 UTC ERROR 7c2b4a17-f772-1ea7-54c9-99cc4d8dea09

HiveConnectionPool[id=7c2b4a17-f772-1ea7-54c9-99cc4d8dea09] Error getting Hive connection

16:33:08 UTC ERROR d3b62ee6-0157-1000-b66f-364970fcfa98

SelectHiveQL[id=d3b62ee6-0157-1000-b66f-364970fcfa98] Unable to execute HiveQL select query show tables due to org.apache.nifi.processor.exception.ProcessException: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not open client transport with JDBC Uri: jdbc:hive2://myserver:10000/hdf_moat;principal=hive/myserver@mydomain: GSS initiate failed). No FlowFile to route to failure: org.apache.nifi.processor.exception.ProcessException: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Could not open client transport with JDBC Uri: jdbc:hive2://myserver:10000/hdf_moat;principal=hive/mydomain: GSS initiate failed)

Regards,

Re: Cannot Create Hive Connection Pool.

mburgess — Wed, 02 Nov 2016 23:45:18 GMT

The Hive processors share some code with the Hadoop processors (in terms of Kerberos, etc.), they expect "hadoop.security.authentication" to be set to "kerberos" in your config file(s) (core-site, hive-site, e.g.)

Re: Cannot Create Hive Connection Pool.

saikrishna_tara — Sun, 18 Aug 2019 11:51:23 GMT

@Matt Burgess

in those both files it's set as Kerberos , here are some properties from hive-site.xml. is there any other files that i need to be checking.

Re: Cannot Create Hive Connection Pool.

mburgess — Thu, 03 Nov 2016 00:34:26 GMT

In your snippet above, the property set to "KERBEROS" is "hive.server2.authentication", not "hadoop.security.authentication". If "hadoop.security.authentication" is set to "kerberos" in your core-site.xml, ensure the path to your core-site.xml is in the Hive Configuration Resources property. That property accepts a comma-separated list of files, so you can include your hive-site.xml (as you've done in your above screenshot) as well as the core-site.xml file (which has the aforementioned property set).

Re: Cannot Create Hive Connection Pool.

saikrishna_tara — Sun, 18 Aug 2019 11:51:15 GMT

@Matt Burgess

adding core-site.xml eliminated the warning. But i had to change the kerberos principal to fully qualified name , then it started working..thanks for the help..

Re: Cannot Create Hive Connection Pool.

Swad — Tue, 18 Feb 2020 16:34:07 GMT

Hi All,

I am facing issue still after adding below both hive-site.xml and core-site.xml.

<property>
<name>hadoop.security.authentication</name>
<value>kerberos</value>
</property>

I am facing below error

org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class 'org.apache.hive.jdbc.HiveDriver' for connect URL
jdbc:hive2://ux329tas101.ux.hostname.net:10000/default;principal=<principal name>;ssl=true

Could you please help me regarding this.

Regards,

Swadesh Mondal