Workaround for Spark SQL to find MySQL when accessing hive data

I tried to add N to the MySQL drive in the classpath still not

Workaround: Add the MySQL driver to the parameter--driver-class when you start

[Email protected] spark-1.0.1-bin-hadoop2]$ Bin/spark-shell--driver-class-path lib/ Mysql-connector-java-5.1.30-bin.jar

Summarize:
The 1.spark version must be compiled with the hive 1.0.0 pre-compiled version not added to Hive 1.0.1 is a hive-containing
2. The Hive-site.xml configuration file needs to be placed under spark conf
3. Need to load MySQL driver into classpath

Workaround for Spark SQL to find MySQL when accessing hive data