val value_path="file:///Users/kelisiduofu/Desktop/UIS/value1"
val conf=new SparkConf().setAppName("UIS_TMP").setMaster("local[*]")
val spark=SparkSession.builder().config(conf).getOrCreate()
val frame1=spark.read.json(value_path)
frame1.createTempView("t1")
spark.sql("select * from t1").show()
检查json串,发现有两个value
设置大小写敏感即可
val value_path="file:///Users/kelisiduofu/Desktop/UIS/value1"
val conf=new SparkConf().setAppName("UIS_TMP").setMaster("local[*]")
val spark=SparkSession.builder().config(conf).getOrCreate()
spark.sql("set spark.sql.caseSensitive=true")---这里
val frame1=spark.read.json(value_path)
frame1.createTempView("t1")
spark.sql("select * from t1").show()