josn文件内容
{"id":1, "name":"cc", "age":18}
{"id":2, "name":"qiqi", "age":19}
{"id":3, "name":"xiaohei", "age":17}
{"id":1, "name":"cc2", "age":15}
{"id":2, "name":"qiqi2", "age":20}
{"id":3, "name":"xiaohei2", "age":17}
加载代码
import org.apache.spark.sql.SQLContext
val sqlc=new SQLContext(sc)
val s=sqlc.read.json("G:/ccData/person.json")
s.show
1.查询
scala> s.select("id","name").show
+---+--------+
| id| name|
+---+--------+
| 1| cc|
| 2| qiqi|
| 3| xiaohei|
| 1| cc2|
| 2| qiqi2|
| 3|xiaohei2|
+---+--------+
2.条件查询
scala> s.select($"id