sparksql读取json数据并查询

package cn.hhb.spark.sqlimport org.apache.spark.sql.{DataFrame, SQLContext}
import org.apache.spark.{SparkConf, SparkContext}/*** Created by Administrator on 2017/9/21 0021.*/
object TestSQLScala {def main(args: Array[String]) {val conf &＃61; new SparkConf().setAppName("TestSQLScala").setMaster("local").set("spark.testing.memory", "2147480000");val sc &＃61; new SparkContext(conf)val sqlContext &＃61; new SQLContext(sc)val students_df &＃61; sqlContext.read.json("c://students.json")// 打印所有数据students_df.showstudents_df.select("name", "age").showstudents_df.registerTempTable("students")sqlContext.sql("select * from students where age >&＃61; 18").show()sc.stop()}
}