pyspark：连接数据库（MySQL），写数据

RDD转为DataFrame：

row = rdd.map(lambda c:Row(address=c[0],count=int(c[1])))
df = sqlContext.createDataFrame(row)

写入：

prop = {"user":"root","password":"123456","driver":"com.mysql.jdbc.Driver"}
df.write.jdbc("jdbc:mysql://192.168.219.150:3306/test",'regional','append', prop)