--spark sql
dataFrame
val cuDF=sqlContext.read.table("device")
cuDF.limit(100).show()
cuDF.select("name","type")
--保存到临时表
cuDF.registerTempTable("cu2")
sqlContext.sql(" select top 10 * from cu2 ").collect().foreach(println)
dataFrame
val cuDF=sqlContext.read.table("device")
cuDF.limit(100).show()
cuDF.select("name","type")
--保存到临时表
cuDF.registerTempTable("cu2")
sqlContext.sql(" select top 10 * from cu2 ").collect().foreach(println)