@Annkaa My bad lost in the thread , couldnt respond to you quickly .
Looks like there is no metastore URI being provided in the ini file or the URI is wrong .
Based on the exception .
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 at org.apache.thrift.transport.TSocket.open(TSocket.java:226) at org.apache.hadoop.hive.metastore.HiveMe
Let me know if that helps
yes @csguna I thinks thats the Issue. @Annkaa you can verify that part by running a small query in your Hive shell and Beeline shell separately. In your case the query should work in Hive and Beeline should promt "No current connection". As a matter of fact every external connectivity to hive metastore goes through beeline. That must be the issue as you are unable to accomplish it through Hue.