Unable to connect Hive

One Star

Unable to connect Hive

Hi Team,
I'm unable to connect to Hive using "tHiveConnection" due to the following error :
Exception in component tHiveConnection_1
org.apache.hive.service.ServiceException: Unable to connect to MetaStore!
    at org.apache.hive.service.cli.CLIService.start(CLIService.java:85)
    at org.apache.hive.service.cli.thrift.EmbeddedThriftBinaryCLIService.<init>(EmbeddedThriftBinaryCLIService.java:35)
    at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:113)
    at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105)
    at java.sql.DriverManager.getConnection(DriverManager.java:571)
    at java.sql.DriverManager.getConnection(DriverManager.java:215)
    at talend_job_test.hive_test_0_1.Hive_test.tHiveConnection_1Process(Hive_test.java:366)
    at talend_job_test.hive_test_0_1.Hive_test.runJobInTOS(Hive_test.java:1052)
    at talend_job_test.hive_test_0_1.Hive_test.main(Hive_test.java:911)
Caused by: MetaException(message:Got exception: org.apache.thrift.transport.TTransportException java.net.SocketTimeoutException: Read timed out)
    at org.apache.hadoop.hive.metastore.MetaStoreUtils.logAndThrowMetaException(MetaStoreUtils.java:962)
    at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getDatabases(HiveMetaStoreClient.java:724)
    at org.apache.hive.service.cli.CLIService.start(CLIService.java:83)
    ... 8 more
For connection following are my configs :
Distribution : Pivotal ; Hive version : Pivotal HD 2.0
Connection mode : Embedded ; Hive server : Hive 2
I have added correct "Host", "Port", "Username", "Password", "Resource Manager URI" and "NN URI"
Please let me know what could be the reason behind this issue?
Thanks,
Akash
Moderator

Re: Unable to connect Hive

Hi,
On which official version did you get that ?

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Unable to connect Hive

Hi Sabrina,
I was able to resolve the issue. It actually was the issue with the port I'm connecting with.
Thanks,
Akash