pyspark 读mysql数据_pyspark读取Mysql数据

pyspark读取Mysql数据：

样例code 1：

from pyspark.sqlimportSQLContext

sqlContext = SQLContext(sc)

dataframe_mysql = sqlContext.read.format("jdbc").options(url="jdbc:mysql://127.0.0.1:3306/spark_db", driver="com.mysql.jdbc.Driver", dbtable="spark_table", user="root", password="root").load()

dataframe_mysql.show()

样例code 2：

from pyspark import SparkContext,SQLContext

from pyspark.sql import SQLContext

sc = SparkContext("spark://train01:7077","LDASample")

sqlContext=SQLContext(sc)

jdbcDf=sqlContext.read.format("jdbc").options(url="jdbc:mysql://10.10.10.10:3306/adl",driver="com.mysql.jdbc.Driver",dbtable="(SELECT code,title,description FROM project) tmp",user="mouren",password="mou