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

Truststore/Trusted hostname

2019-01-09 Thread Vos, Walter
Hi, I'm trying to use the invokeHttp processor to POST to an https site through a proxy. The proxy is http. Through some googling I found references that Java is rather finicky with SSL connections and wants the target server certificate in its truststore, but InvokeHttp also offers the

Re: Truststore/Trusted hostname

2019-01-09 Thread Kevin Doran
Hi Walter, I could be mistaken, but my interpretation of the Trusted Hostname configuration option is that it is designed to work with/in-addition-to the truststore, not instead of a truststore as an alternative trust mechanism.  Basically, I think it is to be used in situations when the

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

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

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

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

Re: Truststore/Trusted hostname

2019-01-09 Thread Andrew Grande
Walter, you could point to the default JRE truststore file, maybe. Andrew On Wed, Jan 9, 2019, 7:12 AM Kevin Doran wrote: > Hi Walter, > > I could be mistaken, but my interpretation of the Trusted Hostname > configuration option is that it is designed to work with/in-addition-to the >

Cluster Response Times Intermittently Slow, CPU Spikes

2019-01-09 Thread Peter Wicks (pwicks)
For a few weeks, one of our clusters has been having large spikes in CPU across most or all nodes, at the same time. Beginning at the same time, our metrics collection job has intermittently started to see long response times when calling the following api end-points: