nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Pierre Villard <pierre.villard...@gmail.com>
Subject Re: Unable to create HiveConnectionPool with kerberos.
Date Mon, 26 Mar 2018 18:01:13 GMT
Mohit,

I believe you need to change the JDBC url (even though you have the
configuration files correctly set) to something like:
jdbc:hive2://<host>:<port>/<db>;principal=<Server_Principal_of_HiveServer2>

So it'd be something like:

jdbc:hive2://localhost:10000/default;principal=hive/my.fqdn.hive.server@EXAMPLE.COM


Pierre


2018-03-26 18:13 GMT+02:00 Juan Pablo Gardella <gardellajuanpablo@gmail.com>
:

> Sorry, the issue happens when a HA configuration is used.
>
> On Mon, 26 Mar 2018 at 13:03 Juan Pablo Gardella <
> gardellajuanpablo@gmail.com> wrote:
>
>> See https://issues.apache.org/jira/browse/NIFI-2575, the driver does not
>> suppor that. I've put some workarounds in the ticket.
>>
>> On Mon, 26 Mar 2018 at 13:03 <mohit.jain@open-insights.co.in> wrote:
>>
>>> Hi,
>>>
>>>
>>>
>>> I am getting the following warning when I use HiveConnection pool with
>>> Kerberos :
>>>
>>>
>>>
>>> HiveConnectionPool[id=6e60258b-9e00-3bac-85ba-0dac8e22142f]
>>> Configuration does not have security enabled, Keytab and Principal will be
>>> ignored
>>>
>>>
>>>
>>> It also throws the following bulletin in my PutHiveQl processor:
>>>
>>> PutHiveQL[id=55f4ac1b-ecf9-3db3-b898-7a9d145a5382] org.apache.nifi.processors.hive.PutHiveQL$$Lambda$663/2042832677
<(204)%20283-2677>@40267000 failed to process 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://******:10000/nifi_test1: Peer indicated
failure: Unsupported mechanism type PLAIN); rolling back session: org.apache.commons.dbcp.SQLNestedException:
Cannot create PoolableConnectionFactory (Could not open client transport with JDBC Uri: jdbc:hive2://******:10000/nifi_test1:
Peer indicated failure: Unsupported mechanism type PLAIN)
>>>
>>>
>>>
>>> Hive Configuration Resources:- /etc/hive/conf/hive-site.xml,/
>>> etc/hadoop/conf/core-site.xml
>>>
>>> I have set hive.security.authentication and hadoop.security.authentication
>>> to Kerberos.
>>>
>>>
>>>
>>> Please let me know if I’m doing anything wrong.
>>>
>>>
>>>
>>> Regards,
>>>
>>> Mohit
>>>
>>

Mime
View raw message