title: Can Spark-sql work without a hive installation?
body: <p>I have installed spark 2.4.0 on a clean ubuntu instance. Spark dataframes work fine but when I try to use spark.sql against a dataframe such as in the example below,i am getting an error "Failed to access metastore. This class should not accessed in runtime."</p>
  
  <p><pre><code>spark.read.json("/data/flight-data/json/2015-summary.json")
  .createOrReplaceTempView("some_sql_view") </p>
  
  <p>spark.sql("""SELECT DEST_COUNTRY_NAME, sum(count)
  FROM some_sql_view GROUP BY DEST_COUNTRY_NAME
  """).where("DEST_COUNTRY_NAME like 'S%'").where("sum(count) > 10").count()
  </code></pre></p>
  
  <p>Most of the fixes that I have see in relation to this error refer to environments where hive is installed. Is hive required if I want to use sql statements against dataframes in spark or am i missing something else? </p>
  
  <p>To follow up with my fix. The problem in my case was that Java 11 was the default on my system. As soon as I set Java 8 as the default metastore_db started working.</p>