Re: pyspark.sql.DataFrame write error to Postgres DB

Ooops, sorry. I meant Maria DB. 2017-04-21 12:51 GMT+09:00 Takeshi Yamamuro : > Why you use a mysql jdbc driver? > > // maropu > > On Fri, Apr 21, 2017 at 11:54 AM, Cinyoung Hur > wrote: > >> Hi, >> >> I tried to insert Dataframe into Postgres

Re: pyspark.sql.DataFrame write error to Postgres DB

Why you use a mysql jdbc driver? // maropu On Fri, Apr 21, 2017 at 11:54 AM, Cinyoung Hur wrote: > Hi, > > I tried to insert Dataframe into Postgres DB. > > But, I don't know what causes this error. > > > properties = { > "user": "user", > "password": "pass", >

pyspark.sql.DataFrame write error to Postgres DB

Hi, I tried to insert Dataframe into Postgres DB. But, I don't know what causes this error. properties = { "user": "user", "password": "pass", "driver": "com.mysql.jdbc.Driver", } url = "jdbc:mysql://ip address/MYDB?useServerPrepStmts=false=true" df.write.jdbc(url=url,