# DataFrame的写法
swimmersJSON.select("id", "age").filter("age = 22").show()# SQL的写法
spark.sql("select id, age from swimmersJSON where age = 22").show()# DataFrame的写法
swimmersJSON.select("name", "eyeColor").filter("eyeColor like 'b%'").show()# SQL的写法
spark.sql("select name, eyeColor from swimmersJSON where eyeColor like 'b%'").