case class AA(a1: Float, a2: Float, a3: Float, a4: Float, a5: Long, a6: Long, a7: Long, a8: Long, a9: Long, a10: Long)
// 数据:"39.7219951040737","116.345595326719","39.721947425764","116.345545366995","207","2535","19","0","9","1546272000"
val dataRDD = sc.textFile("C:\\Users\\sss\\Desktop\\bj_unmatch_point20190228.csv")
val insertData = dataRDD.map {
log =>
val line = log.replaceAll("\"","").split(",", -1)
val lat = line(0).toFloat
val lon = line(1).toFloat
val lats = line(2).toFloat
val lons = line(3).toFloat
val a5 = line(4).toLong
val a6 = line(5).toLong
val a7 = line(6).toLong
val a8 = line(7).toLong
val a9 = line(8).toLong
val a10 = line(9).toLong
AA(lat, lon, lats, lons, a5, a6, a7, a8, a9, a10)
}