Prasanth, I haven't looked at this section of the code in a while, but I know Sqoop2 doesn't have different connectors for the different relational databases at the moment. Upsert support varies depending on the database, so I would imagine it's not supported.
-Abe On Tue, Jul 21, 2015 at 10:54 AM, Chagarlamudi, Prasanth < [email protected]> wrote: > Hello All, > > I am able to run an EXPORT job successfully. Inserts are going fine, but I > am getting an exception when I try to do an update. > > > > Error: org.apache.sqoop.common.SqoopException: MAPRED_EXEC_0018:Error > occurs during loader run at > org.apache.sqoop.job.mr.SqoopOutputFormatLoadExecutor$ConsumerThread.run(SqoopOutputFormatLoadExecutor.java:255) > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) > at java.util.concurrent.FutureTask.run(FutureTask.java:262) at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:745) Caused by: > org.apache.sqoop.common.SqoopException: GENERIC_JDBC_CONNECTOR_0002:Unable > to execute the SQL statement at > org.apache.sqoop.connector.jdbc.GenericJdbcExecutor.executeBatch(GenericJdbcExecutor.java:189) > at > org.apache.sqoop.connector.jdbc.GenericJdbcLoader.load(GenericJdbcLoader.java:66) > at > org.apache.sqoop.connector.jdbc.GenericJdbcLoader.load(GenericJdbcLoader.java:25) > at > org.apache.sqoop.job.mr.SqoopOutputFormatLoadExecutor$ConsumerThread.run(SqoopOutputFormatLoadExecutor.java:247) > ... 5 more Caused by: java.sql.BatchUpdateException: *ORA-00001: unique > constraint (SCHEMA.TABLENAME_PK)* violated at > oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:11190) > at > oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:244) > at > org.apache.sqoop.connector.jdbc.GenericJdbcExecutor.executeBatch(GenericJdbcExecutor.java:183) > ... 8 more > > > > Sqoop2 only supports inserts? If not, is there a way to turn the *update* > mode on for Sqoop2? > > > > Thanks > > Prasanth Chagarlamudi > > ------------------------------ > > This e-mail and files transmitted with it are confidential, and are > intended solely for the use of the individual or entity to whom this e-mail > is addressed. If you are not the intended recipient, or the employee or > agent responsible to deliver it to the intended recipient, you are hereby > notified that any dissemination, distribution or copying of this > communication is strictly prohibited. If you are not one of the named > recipient(s) or otherwise have reason to believe that you received this > message in error, please immediately notify sender by e-mail, and destroy > the original message. Thank You. >
