About cghersi

cghersi · ‎10-20-2015

Hi Sean. Finally the connection has been successful with the hive2 driver. Thank you so much! cghersi

cghersi · ‎10-19-2015

Hi Sean, thank you for your reply. I tried to connect to the manager, unfortunately in this case the program get stuck in the DriverManager.getConnection() method. I triple-checked the ACL rules and the TCP port 10000 is allowed, as well as 21050 of Impala. for Impala everything works, for Hive it doesn't. Any other idea? If you want you can contact me at cristiano.ghersi _at_ plat.one Thank you very much cghersi

cghersi · ‎10-19-2015

I've followed the Getting Started Guide, everything OK, and now I need to connect to Hive cluster via JDBC. I have the following configuration: Manager Node (cloudera1) 52.6.221.164 Worker Node 1 (cloudera2) 52.22.58.113 Worker Node 2 (cloudera3) 54.175.19.19 Worker Node 3 (cloudera4) 54.175.18.49 I have the following connection string: jdbc:hive://52.22.58.113:10000/default;user=my_user;password=my_psw When trying to establish a connection, the following exception is thrown by the driver: [Cloudera][HiveJDBCDriver](500164) Error initialized or created transport for authentication: java.net.ConnectException: Connection refused: connect. What's the right pair IP address - TCP port that I should use to connect? Thank you cghersi

cghersi · ‎10-15-2015

Hi Sean, I'm still facing the same problem with Hive connection on port 10000. Any other clue or advice? Thank you very much! cghersi

cghersi · ‎10-13-2015

Hi Sean, with respect to the ports used to connect to Hive/Impala etc., I found this document very useful: http://www.cloudera.com/content/cloudera/en/documentation/archives/cloudera-manager-4/v4-5-4/Configuring-Ports-for-Cloudera-Manager-Enterprise-Edition/cmeecp_topic_3.html I still have problems anyway with the connection to Hive. Could you help me please? Thank you cghersi

cghersi · ‎10-13-2015

Hi Sean, than kyou for your reply: it worked with Impala, but with Hive I'm still encountering the same issue, on port 10000. Moreover, just as user feedback, it is extremely difficult to find which are the right ports to connect to from an external client: could you please provide some reference where I can find such information on Cloudera Manager or similar UI? Thank you! cghersi

cghersi · ‎10-13-2015

Update, I have tried also with Hive, setting this connection string: jdbc:hive://54.175.22.26:10000/default;user=my_user;password=my_psw Again, no luck. Thank you cghersi

cghersi · ‎10-12-2015

I've followed the Getting Started Guide, everything OK, and now I need to connect to Impala cluster via JDBC. I have the following configuration: Manager Node (cloudera1) 54.175.35.127 Worker Node 1 (cloudera2) 54.175.22.26 Worker Node 2 (cloudera3) 54.175.19.19 Worker Node 3 (cloudera4) 54.175.18.49 I have the following connection string: jdbc:impala://54.175.22.26:21050/default;user=my_user;password=my_psw What's the right pair IP address -TCP port that I should use to connect? Thank you cghersi

Online	Offline
Last Visited	‎05-10-2016 08:54 PM

Member Since	‎10-12-2015 06:40 PM
Last Visited	‎05-10-2016 08:54 PM
Posts	8

Cloudera Community

Re: Cannot connect to Hive thru JDBC: Connection r...

Re: Cannot connect to Hive thru JDBC: Connection r...

Cannot connect to Hive thru JDBC: Connection refus...

Re: Cannot connect to Impala via JDBC: Connection ...

Re: Cannot connect to Impala via JDBC: Connection ...

Re: Cannot connect to Impala via JDBC: Connection ...

Re: Cannot connect to Impala via JDBC: Connection ...

Cannot connect to Impala via JDBC: Connection time...