[SQOOP-2195] database= option must be used in sqoop command when importing dbcs data from Teradata

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.3.0
• Fix Version/s: 1.3.0
• Component/s: connectors
• Labels: features

Environment

operation system:UNIX

• Assignee: Unassigned
• Reporter: Lucy Gu
• Created: 10/Mar/15 03:06
• Updated: 10/Mar/15 03:22

Description

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