title: SparkSQL Hive Error : "HikariCP" not found in the CLASSPATH
body: <p>I configured Hive with mySQL as my metastore. I can enter hive shell and create tables successfully.</p>
  
  <p><strong>Spark version: 2.4.0</strong></p>
  
  <p><strong>Hive version: 3.1.1</strong></p>
  
  <p>When I try to run a SparkSQL program using spark submit, I'm getting the below error.</p>
  
  <pre><code>2019-03-02 15:43:41 WARN  HiveMetaStore:622 - Retrying creating default database after error: Error creating transactional connection factory
  javax.jdo.JDOFatalInternalException: Error creating transactional connection factory
  ......
  ......
  Exception in thread "main" org.apache.spark.sql.AnalysisException: java.lang.RuntimeException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient;
  ......
  ......
  org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient;
  Caused by: org.datanucleus.exceptions.NucleusException: Attempt to invoke the "HikariCP" plugin to create a ConnectionPool gave an error : The connection pool plugin of type "HikariCP" was not found in the CLASSPATH!
  </code></pre>
  
  <p>Please let me know if anyone can help me in this regard.</p>