Support Questions
Find answers, ask questions, and share your expertise

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

Solved Go to solution

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

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

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

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.