Hi Jeff, Thanks a lot for responding. I have placed the hive-site.xml file in the spark/conf folder now but now encountering a new error.
org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient I have placed hive-site.xml from the below git repository. Not sure if its correct or not. https://github.com/FRosner/docker-zeppelin/blob/master/conf.templates/hive-site.xml.template Please let me know if I need to make any other changes. On Tue, Apr 11, 2023 at 11:10 AM Jeff Zhang <zjf...@gmail.com> wrote: > Have you put hive-site.xml under SPARK_CONF_DIR? > > > On Tue, Apr 11, 2023 at 1:01 PM VIVEK NARAYANASETTY <vive....@gmail.com> > wrote: > >> Hi Users, >> >> Appreciate if any leads on the below issue. >> >> On Sat, Apr 8, 2023 at 1:33 PM VIVEK NARAYANASETTY <vive....@gmail.com> >> wrote: >> >>> Hello Everyone, >>> >>> I am trying to create some tables using Spark SQL and encountering the >>> below error in zeppelin. When debugged, I could see that the >>> "zeppelin.spark.useHiveContext" is set to true which means hive context >>> needs to be used in place of SQLContext but doesn't look its able to >>> use/initiate HiveContext. Attaching my analysis screenshot on the zeppelin >>> notebook. Please advise on how to resolve this. >>> >>> Hive support is required to CREATE Hive TABLE (AS SELECT); 'CreateTable >>> `test_schema_default_location`.`managed_table`, >>> org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, ErrorIfExists >>> >>> >>> [image: image.png] >>> >>> -- >>> Thanks & Regards >>> *Vivek Narayanasetty* >>> >>> >>> >>> >>> *Go Green: Think before you print this e-mail or its attachment. You can >>> save paper if you do not really need to print.* >>> >> >> >> -- >> Thanks & Regards >> *Vivek Narayanasetty* >> >> >> >> >> *Go Green: Think before you print this e-mail or its attachment. You can >> save paper if you do not really need to print.* >> > > > -- > Best Regards > > Jeff Zhang > -- Thanks & Regards *Vivek Narayanasetty* *Go Green: Think before you print this e-mail or its attachment. You can save paper if you do not really need to print.*