Bhanu Akaveeti created SPARK-20113: -------------------------------------- Summary: overwrite mode appends data on MySQL table that does not have a primary key Key: SPARK-20113 URL: https://issues.apache.org/jira/browse/SPARK-20113 Project: Spark Issue Type: Bug Components: Input/Output Affects Versions: 2.0.1 Reporter: Bhanu Akaveeti
Dataframe.write in overwrite mode appends data on MySQL table that does not have a primary key df_mysql.write \ .mode("overwrite") \ .jdbc("jdbc:mysql://ip-address/database", "MySQL_Table", properties={"user": "MySQL_user", "password": "MySQL_pw"}) When the above script is run twice, data is inserted twice. Also, I tried with option("truncate","true") but still data is appended in MySQL table -- This message was sent by Atlassian JIRA (v6.3.15#6346) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org