question error in livy - org.apache.hadoop.hive.ql.metadata.HiveException in Support Questions https://community.cloudera.com/t5/Support-Questions/error-in-livy-org-apache-hadoop-hive-ql-metadata/m-p/353680#M236770 <P>hello cloudera community,</P> <P>&nbsp;</P> <P>we are having problems using livy with job spark to read hive by jupyter notebook</P> <P>&nbsp;</P> <P>when we run a simple query, for example:</P> <P>&nbsp;</P> <P>"<STRONG>spark.sql("show show databases").show()</STRONG>"</P> <P>&nbsp;</P> <P>returns the error below<BR /><BR />"<STRONG>org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient</STRONG>"</P> <P>&nbsp;</P> <P>Could you help us with this setup?</P> <P>&nbsp;</P> <P>ps: we are using cdh 5.16.x</P> Fri, 30 Sep 2022 01:06:09 GMT yagoaparecidoti 2022-09-30T01:06:09Z error in livy - org.apache.hadoop.hive.ql.metadata.HiveException https://community.cloudera.com/t5/Support-Questions/error-in-livy-org-apache-hadoop-hive-ql-metadata/m-p/353680#M236770 <P>hello cloudera community,</P> <P>&nbsp;</P> <P>we are having problems using livy with job spark to read hive by jupyter notebook</P> <P>&nbsp;</P> <P>when we run a simple query, for example:</P> <P>&nbsp;</P> <P>"<STRONG>spark.sql("show show databases").show()</STRONG>"</P> <P>&nbsp;</P> <P>returns the error below<BR /><BR />"<STRONG>org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient</STRONG>"</P> <P>&nbsp;</P> <P>Could you help us with this setup?</P> <P>&nbsp;</P> <P>ps: we are using cdh 5.16.x</P> Fri, 30 Sep 2022 01:06:09 GMT https://community.cloudera.com/t5/Support-Questions/error-in-livy-org-apache-hadoop-hive-ql-metadata/m-p/353680#M236770 yagoaparecidoti 2022-09-30T01:06:09Z Re: error in livy - org.apache.hadoop.hive.ql.metadata.HiveException https://community.cloudera.com/t5/Support-Questions/error-in-livy-org-apache-hadoop-hive-ql-metadata/m-p/353762#M236782 <P><SPAN>hello cloudera community,</SPAN></P><P>&nbsp;</P><P>solved the problem by pointing hive-site.xml file in spark and spark2</P><P>&nbsp;</P><P>so spark jobs in livy in jupyter notebook ran successfully</P> Fri, 30 Sep 2022 13:32:17 GMT https://community.cloudera.com/t5/Support-Questions/error-in-livy-org-apache-hadoop-hive-ql-metadata/m-p/353762#M236782 yagoaparecidoti 2022-09-30T13:32:17Z