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
