Lucy Gu created SQOOP-2195:
------------------------------
Summary: 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
Fix For: 1.3.0
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)
