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.

where in livy is the hive configuration the equivalent of %jdbc - hive.url parameter

Solved Go to solution
Highlighted

where in livy is the hive configuration the equivalent of %jdbc - hive.url parameter

where in livy is the hive configuration the equivalent of %jdbc - hive.url parameter. When I am running %livy.sql show tables, I get an empty result. I looked under livy interpreters section in zeppelin and also in ambari livy configs section but did not see an explicit hive url metastore location defined.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: where in livy is the hive configuration the equivalent of %jdbc - hive.url parameter

New Contributor

Hi @azeltov please use the following snippet, which worked for me.

%livy
sc.version
val sqlContext = new org.apache.spark.sql.hive.HiveContext(sc)
%livy.sql
show tables

View solution in original post

2 REPLIES 2
Highlighted

Re: where in livy is the hive configuration the equivalent of %jdbc - hive.url parameter

New Contributor

Hi @azeltov please use the following snippet, which worked for me.

%livy
sc.version
val sqlContext = new org.apache.spark.sql.hive.HiveContext(sc)
%livy.sql
show tables

View solution in original post

Highlighted

Re: where in livy is the hive configuration the equivalent of %jdbc - hive.url parameter

Expert Contributor

livy will use hive-site.xml under /etc/spark/conf. Make sure you have correct configuration in that file.

Don't have an account?
Coming from Hortonworks? Activate your account here