// 日期格式化
val simpleDateFormat = new SimpleDateFormat("yyyyMM")
// 注册一个UDF函数,将timestamp转换成年月
spark.udf.register("changeDate",(x:Int)=>simpleDateFormat.format(new Date(x * 1000)).toInt)
val ratingOfYearMonth = spark.sql("select mid, score, changeDate(timestamp) as yearmonth from ratings")