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

[#1]

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.

[#2 · Accepted solution]

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

[#3]

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