[
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)
