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.ser...@example.com Pierre 2018-03-26 18:13 GMT+02:00 Juan Pablo Gardella <gardellajuanpa...@gmail.com> : > Sorry, the issue happens when a HA configuration is used. > > On Mon, 26 Mar 2018 at 13:03 Juan Pablo Gardella < > gardellajuanpa...@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.j...@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 >>> >>
