question Re: where in livy is the hive configuration the equivalent of %jdbc - hive.url parameter in Archives of Support Questions (Read Only) https://community.cloudera.com/t5/Archives-of-Support-Questions/where-in-livy-is-the-hive-configuration-the-equivalent-of/m-p/173446#M45988 <P>livy will use hive-site.xml under /etc/spark/conf. Make sure you have correct configuration in that file.</P> Sat, 26 Nov 2016 11:07:21 GMT jzhang 2016-11-26T11:07:21Z where in livy is the hive configuration the equivalent of %jdbc - hive.url parameter https://community.cloudera.com/t5/Archives-of-Support-Questions/where-in-livy-is-the-hive-configuration-the-equivalent-of/m-p/173444#M45986 <P>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.</P> Sat, 12 Nov 2016 08:49:04 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/where-in-livy-is-the-hive-configuration-the-equivalent-of/m-p/173444#M45986 azeltov 2016-11-12T08:49:04Z Re: where in livy is the hive configuration the equivalent of %jdbc - hive.url parameter https://community.cloudera.com/t5/Archives-of-Support-Questions/where-in-livy-is-the-hive-configuration-the-equivalent-of/m-p/173445#M45987 <P> Hi <A rel="user" href="https://community.cloudera.com/users/325/azeltov.html" nodeid="325">@azeltov</A> please use the following snippet, which worked for me. </P><PRE>%livy sc.version val sqlContext = new org.apache.spark.sql.hive.HiveContext(sc) </PRE><PRE>%livy.sql show tables </PRE> Mon, 14 Nov 2016 19:24:16 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/where-in-livy-is-the-hive-configuration-the-equivalent-of/m-p/173445#M45987 rchoudhary 2016-11-14T19:24:16Z Re: where in livy is the hive configuration the equivalent of %jdbc - hive.url parameter https://community.cloudera.com/t5/Archives-of-Support-Questions/where-in-livy-is-the-hive-configuration-the-equivalent-of/m-p/173446#M45988 <P>livy will use hive-site.xml under /etc/spark/conf. Make sure you have correct configuration in that file.</P> Sat, 26 Nov 2016 11:07:21 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/where-in-livy-is-the-hive-configuration-the-equivalent-of/m-p/173446#M45988 jzhang 2016-11-26T11:07:21Z