/**
* @Auther: sss
* @Date: 2019/2/26 14:24
* @Description:
* ps:資料是json 如下（資料是a#b#格式） 需求：lat,lng;timestamp#lat,lng;timestamp#lat,lng;timestamp （最後要是a#b格式）
*/
object xiaoM {
/* def main(args: Array[String]): Unit = {
//這種不對
val session = SparkSession.builder().appName(this.getClass.getSimpleName).master("local[*]").getOrCreate()
val files = session.read.json("C:\\Users\\sss\\Desktop\\jsons.json")
import session.implicits._
val rdd = files.rdd.flatMap {
row =>
row.getAs[Seq[Row]]("ridingTrackPoints").map {
row02 =>
val lat = row02.getDouble(1)
val lng = row02.getDouble(2)
val timestamp = row02.getLong(3)
val tag = String.format(s"lat:$lat,lng:$lng;timestamp:$timestamp#")
(tag)
}
}
rdd.toDF().write.saveAsTable("tmp_table")
session.sql("select * from tmp_table").foreach(f=>println(f))
}*/
def main(args: Array[String]): Unit = {
var ridelatlng: String = null
var lat: String = null
var lng: String = null
var timestamp: String = null
var str = "{aaa:[{'effective':true,'lat':36.670483,'lng':117.009472,'timestamp':1551151891728}," +
"{'effective':true,'lat':36.670597,'lng':117.009371,'timestamp':1551151893015}]}"
val rddJson = JSON.parseObject(str)
if (rddJson != null) {
if (rddJson.containsKey("aaa")) {
val ridingTrackPoints: JSONArray = rddJson.getJSONArray("aaa")
var ridelatlngstr = new StringBuilder()
for (i <- 0 until ridingTrackPoints.size()) {
val ridingTrackPointsJson = ridingTrackPoints.getJSONObject(i)
if (ridingTrackPointsJson.containsKey("lat")) {
lat = ridingTrackPointsJson.getString("lat")
}
if (ridingTrackPointsJson.containsKey("lng")) {
lng = ridingTrackPointsJson.getString("lng")
}
if (ridingTrackPointsJson.containsKey("timestamp")) {
timestamp = ridingTrackPointsJson.getString("timestamp")
}
ridelatlngstr.append(lat + "," + lng + ";" + timestamp + "#")
}
ridelatlng = ridelatlngstr.substring(0, ridelatlngstr.length - 1) //改變格式
}
}
println(ridelatlng)
}
}