How to fix error on pyspark EMR Notebook - AnalysisException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
I had the same problem and I realized that I didn't have Hive on my EMR cluster.
After launching another cluster and making sure that Hive was selected, it worked.
Notebook should run on the EMR cluster with compatible HIVE version