样例类使用中的小问题:
mport org.apache.spark.SparkConf
import org.apache.spark.rdd.RDD
import org.apache.spark.sql.{Dataset, SaveMode, SparkSession}
object SparkSQL11_MySQL_Write {
def main(args: Array[String]): Unit = {
val conf = new SparkConf().setAppName("SparkSQLTest").setMaster("local[*]")
val spark = SparkSession.builder().config(conf).getOrCreate()
import spark.implicits._
//.准备数据
val rdd: RDD[User] = spark.sparkContext.makeRDD(List(User(3008,"zhangsan"),User(3009,"lisi")))
val ds: Dataset[User] = rdd.toDS()
ds.write
.format("jdbc")
.option("url","jdbc:mysql://hadoop105:3306/gmall")
.option("user","root")
.option("password","123456")
.option("dbtable","user_info")
.mode(SaveMode.Append)
.save()
spark.stop()
}
}
case class User(id:Int,name:String)
报错:
Exception in thread “main” java.lang.NoSuchMethodError: com.atguigu.sparksql.User.(ILjava/lang/String;)V
Exception in thread "main" java.lang.NoSuchMethodError: com.atguigu.sparksql.User.<init>(ILjava/lang/String;)V
at com.atguigu.sparksql.SparkSQL11_MySQL_Write$.main(SparkSQL11_MySQL_Write.scala:16)
at com.atguigu.sparksql.SparkSQL11_MySQL_Write.main(SparkSQL11_MySQL_Write.scala)
原因:
我在创建样例类时,同一个包下有同名的其他样例类(样例类体不同),当我们要用此样例类时,系统分不清你要用的是哪个,但是如果将样例类放入到类中,优先级会高于同包下的其他同名样例类,这样就可以用到自己的样例类。或者改个样例类的名字就可以了。