One Star

Hive Connection Issue [Unable to connect to metastore with URI]

Using Horton Sandbox as distribution. While creating a table getting the below ERROR. But DDL works fine in HiveUI@Sandbox. Where can be the issue?
ERROR hive.metastore: Unable to connect to metastore with URI thrift://<IP of Sand Box>:10001
MetaException(message:Could not connect to the MetaStore server! Caused by: org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: connect timed out
at org.apache.thrift.transport.TSocket.open(TSocket.java:183)
at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.openStore(HiveMetaStoreClient.java:264)
at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaStoreClient.java:197)
4 REPLIES
Employee

Re: Hive Connection Issue [Unable to connect to metastore with URI]

Hi,
I think the port you use is wrong. Could you try with the port 9083?
Which version of Hortonworks do you use?
Rémy.
One Star

Re: Hive Connection Issue [Unable to connect to metastore with URI]

Version in Talend Studio = Hortonworks Data Platform 1.0
Distribution IP = Hortonworks Sandbox
Keeping Username/Password = "sandbox"
That port WORKED. Thanks!
One Star

Re: Hive Connection Issue [Unable to connect to metastore with URI]

hi,
I am new to talend, i am not able to connect to hive which is present in EMR cluster, from tHiveConnection component. Is it possible to connect if yes then kindly help me to solve my issue.
Employee

Re: Hive Connection Issue [Unable to connect to metastore with URI]

Hi,
Which version of EMR do you use?
Apache 1.0.3?
Mapr?
Rémy.