Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hue user cannot load data into Hive via Sqoop 1

Re: Hue user cannot load data into Hive via Sqoop 1

Champion
Hey is your Hue ini looks good with Hive configuration ?
Highlighted

Re: Hue user cannot load data into Hive via Sqoop 1

Champion

@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 

Re: Hue user cannot load data into Hive via Sqoop 1

New Contributor

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.