Re: jdbc impala url

2019-01-09 Thread Boris Tyukin
Hi Matt, yes it is very similar. In fact Hive, driver can be used to access Impala https://www.cloudera.com/documentation/enterprise/5-9-x/topics/impala_jdbc.html#jdbc_driver_choice . Since you mentioned Hive, we were struggling with NiFi connecting to Hive and did not want to compile NiFi with C

Re: jdbc impala url

2019-01-09 Thread Boris Tyukin
also check out my post - there were a few pitfalls https://boristyukin.com/how-to-connect-apache-nifi-to-apache-impala/ On Wed, Jan 9, 2019 at 1:58 PM Boris Tyukin wrote: > this is how our connection looks like on a kerberized CDH cluster > > jdbc:impala://_host_:21050/default;AuthMech=1;KrbRe

Re: jdbc impala url

2019-01-09 Thread Matt Burgess
Boris, Is your Impala instance using Kerberos to authenticate JDBC clients (the database users, e.g.)? I don't know Impala well but the URL reminds me of the Hive JDBC URL, where you specify a service principal for HS2 to talk to the Hive metastore for example. If Hive client connections are secur

Re: jdbc impala url

2019-01-09 Thread Boris Tyukin
this is how our connection looks like on a kerberized CDH cluster jdbc:impala://_host_:21050/default;AuthMech=1;KrbRealm=blabla.domain.net ;KrbHostFQDN=blabla.domain.net;KrbServiceName=impalaservicename Boris On Wed, Jan 9, 2019 at 10:49 AM Jeff wrote: > Hello, > > I'm working on some NiFi/Im

Re: jdbc impala url

2019-01-09 Thread Jeff
Hello, I'm working on some NiFi/Impala integration examples currently, and will be taking a look at kerberized Impala in a few days. I'll try to follow up with you on this list after I have things working. If you beat me to it, please let us know! - Jeff On Mon, Jan 7, 2019 at 8:32 PM PasLe Ch

jdbc impala url

2019-01-07 Thread PasLe Choix
I need to create a DBCPConnectionPool to connect to my table on Impala in Cloudera cluster, wondering who can provide a sample URL for the jdbc connection? At the moment my URL is as below and is not working: jdbc:impala://nydc-pcdhwrk01:21050; AuthMech=1;KrbRealm=BD.NOVANTAS.PRI;KrbHostFQDN=nydc-