I am trying to export data from HDFS to Mysql using Sqoop 1. My job is working fine and pushs data in mysql table. But when i try to update data by key and insert new rows in mysql table using sqoop commands: --update-key user --update-mode allowinsert i am getting this error :
ERROR tool.ExportTool: Error during export: Mixed update/insert is not supported against the target database yet After some internet searchs, i find that mysql-connector.jar does not support upsert (the connector that i used is mysql-connector-java-5.1.46-bin.jar). Is there another version that supports upsert? Thanks in advance.
... View more