Cloudera Community
timestationapp
user rank
New Contributor

ExecuteSQL - Hive Error

by New Contributor in Support Questions
‎04-05-2016 10:35 AM
1 Kudo
‎04-05-2016 10:35 AM
1 Kudo
Hi, I have a simple NIFI Flow to read results from HIVE tables,please find the image below. ExecuteSQL throws exception when tried to issue simple HIVEQL like 'show tables' or 'select * from <tablename>. Database Connection Pooling Service is set with HIVE credentials and its status is "Enabled". 'hive-jdbc-x.x.x-standalone.jar' is used for Database DriverJar Url in configuration of DCPS. 'hadoop-common-x.x.x.jar' is set as part of system CLASSPATH. Can any point out whats missing to make this simple flow workable. NIFI 0.6.0 is used. Thanks in adv, Regards, Time hivejdbc.png ... View more
Labels:

Re: Hortonworks HDF( Nifi ) : Site to Site ( https...

by New Contributor in Support Questions
‎03-22-2016 08:42 AM
1 Kudo
‎03-22-2016 08:42 AM
1 Kudo
Hello, Below was tried [http->https] 1.http://<ip_address>:<port>/nifi When tried to connect with "nifi.remote.input.secure" as "false" , there is "Unexpected end of file from server" Error Message on the http instance. 2.https://<ip_address>:<port>/nifi When tried to connect with "nifi.remote.input.secure" as "false" , there is "No subject alternative names present" Error Message on the http instance. 3.[https<->https] When tried to connect with "nifi.remote.input.secure" as "true" , there is "PKIX path validation failed: java.security.cert.CertPathValidatorException: signature check failed" Error Message on the both instance when tried either way. Can any help me on this. Thanks in adv, Time ... View more

Hortonworks HDF( Nifi ) : Site to Site ( https < —...

by New Contributor in Support Questions
‎03-18-2016 09:45 AM
4 Kudos
‎03-18-2016 09:45 AM
4 Kudos
Hi All, Iam trying to connect 2 NIFI Instances where one NIFI instance is secure (https ) and other is not ( http ). I'am able to connect from https -> http and pull data but i would like to try the reverse pattern from http --> https. My questions are: 1. How do or should i specify user certificate credentials in Remote Process group to connect to https NIFI instance. 2.By setting "nifi.remote.input.secure" to " false" on the secured NIFI instance,will i be able to connect. Please guide or advice Thanks in adv, Time ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎06-22-2016 06:50 PM
Community Statistics
Member Since ‎03-18-2016 09:42 AM
Last Visited ‎06-22-2016 06:50 PM
Posts 3
Kudos received 6