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

[Anonymous]

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)

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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