Ask your hadoop cluster admin for the hive-site.xml you should use. On Tue, Apr 11, 2023 at 2:19 PM VIVEK NARAYANASETTY <vive....@gmail.com> wrote:
> 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.* > -- Best Regards Jeff Zhang