I am not able to use the Hive shell even after making the hive-site.xml modifications mentioned in the hive-setup-on-cloudera.pdf .


3 Answer(s)


Hi Deepti,

You are getting below error:

Caused by: MetaException (message: Could not connect to meta store using any of the URIs provided. Most recent failure: org.apache.thrift.transport.TTransportException: java.net.ConnectException: Connection refused

Please check the URI mention in hive-site.xml, it is not able to connect.

Hope this helps.

Thanks.


Thanks for the reply! I have the following already mentioned in the hive-site.xml.

 

  <property>
    <name>hive.metastore.uris</name>
    <value>thrift://quickstart.cloudera:9083</value>
  </property>
 

I checked the host tab on the cloudera manager to get the hostname and it is quickstart.cloudera.

I am not sure what needs to be mentioned instead of this. I have my session within the next 12 hours, so it would be great if I could get it resolved before that.


Hi Deepti,

With Cloudera QuickStart VM, all the services are already set and running.

If you want to manually configure, please check the link below:

https://www.cloudera.com/documentation/enterprise/5-6-x/topics/cdh_ig_hive_metastore_configure.html

Hope this helps.

Thanks.