You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Kopal Niranjan (JIRA)" <ji...@apache.org> on 2015/10/26 08:51:27 UTC
[jira] [Updated] (SQOOP-2620) Sqoop Export does not offer upserts
from HDFS to Teradata DB
[ https://issues.apache.org/jira/browse/SQOOP-2620?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kopal Niranjan updated SQOOP-2620:
----------------------------------
Attachment: SQOOP-2620_0.patch
> Sqoop Export does not offer upserts from HDFS to Teradata DB
> -------------------------------------------------------------
>
> Key: SQOOP-2620
> URL: https://issues.apache.org/jira/browse/SQOOP-2620
> Project: Sqoop
> Issue Type: Bug
> Affects Versions: 1.4.6
> Reporter: Kopal Niranjan
> Assignee: Kopal Niranjan
> Priority: Minor
> Fix For: 1.4.7
>
> Attachments: SQOOP-2620_0.patch
>
>
> Sqoop export fails when we perform upserts from HDFS to Teradta
> sqoop export --driver com.teradata.jdbc.TeraDriver --connect jdbc:teradata://10.127.54.34/DATABASE=user_db,TMODE=ANSI,LOGMECH=LDAP --username abc -P --table upsert_tbl --export-dir /user/root/exportRec/ --update-key id --update-mode allowinsert
> Above command fails with the following error:
> 15/10/16 02:51:19 ERROR tool.ExportTool: Error during export: Mixed update/insert is not supported against the target database yet
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)