Unable to connect Hive

Anonymous — Sat, 16 Nov 2024 11:12:12 GMT

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

Re: Unable to connect Hive

Anonymous — Thu, 28 May 2015 11:19:31 GMT

Hi,
On which official version did you get that ?

Best regards
Sabrina

Re: Unable to connect Hive

Anonymous — Thu, 28 May 2015 13:04:39 GMT

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

topic Unable to connect Hive in Talend Studio

Unable to connect Hive

Re: Unable to connect Hive

Re: Unable to connect Hive