You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Lucy Gu (JIRA)" <ji...@apache.org> on 2015/03/10 04:23:38 UTC
[jira] [Updated] (SQOOP-2195) database= option must be used in
sqoop command when importing dbcs data from Teradata
[ https://issues.apache.org/jira/browse/SQOOP-2195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Lucy Gu updated SQOOP-2195:
---------------------------
Summary: database= option must be used in sqoop command when importing dbcs data from Teradata (was: database= option must be used in sqoop command when importing dbcs data from teradata)
> database= option must be used in sqoop command when importing dbcs data from Teradata
> -------------------------------------------------------------------------------------
>
> Key: SQOOP-2195
> URL: https://issues.apache.org/jira/browse/SQOOP-2195
> Project: Sqoop
> Issue Type: Bug
> Components: connectors
> Affects Versions: 1.3.0
> Environment: operation system:UNIX
> Reporter: Lucy Gu
> Labels: features
> Fix For: 1.3.0
>
> Original Estimate: 672h
> Remaining Estimate: 672h
>
> We must add "Database=" option in sqoop command when importing Unicode data from Teradata. The version of Teradata is 14.10. The sqoop command is as follows:
> sqoop import --connection-manager com.cloudera.connector.teradata.TeradataManager --connect jdbc:teradata://quasi/Database=xxxx,CHARSET=UTF8 --table nlstd -m 1 --split-by i --target-dir /tmp/test --delete-target-dir --username xxx --password xxxxx
> But this option is not necessary when importing latin characters from Teradata. Below is sqoop command:
> sqoop import --connection-manager com.cloudera.connector.teradata.TeradataManager --connect jdbc:teradata://quasi/xxxxx --table test -m 1 --split-by i --target-dir /tmp/test10_6 --delete-target-dir --username xxxx --password xxx
> However the Teradata documentation does show that ParameterName=Value is the expected syntax:
> jdbc:teradata://DatabaseServerName/ParameterName=Value
> https://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.html#BABJIHBJ
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)