無法找到註冊驅動Did not find registered driver with class com.mysql.jdbc.Driver

   百度其他資料，都說是因為$HADOOP-YARN-HOME下沒有驅動包，檢視他們原始碼 其實是程式碼沒有載入驅動

貼正確程式碼

   

package l847164916

import java.util.Properties

import org.apache.calcite.avatica.Meta.ConnectionProperties
import org.apache.spark.sql.{SQLContext, SaveMode}
import org.apache.spark.sql.hive.HiveContext
import org.apache.spark.{SparkConf, SparkContext}

/**
  * Created by Administrator on 2016/8/25.
  */
object Hive2MySql {
  def main(args: Array[String]): Unit = {
    val url = ""
    val prop = new Properties()
    prop.setProperty("user","")
    prop.setProperty("password","")
    prop.setProperty("driver","com.mysql.jdbc.Driver")
    val conf = new SparkConf().setAppName("hive2mysql")
    val sc = new SparkContext(conf)
    val hict = new HiveContext(sc)
    hict.sql("use dwb")
   val df = hict.sql("select ldap_dn,mail_name,mobile,domain_name,email,office_code,cn_name,title from index_emp_info")
 df.printSchema()
    df.write.mode(SaveMode.Append).jdbc(url,"base_info",prop)
  
 
  }
}