[jira] [Created] (SQOOP-2195) database= option must be used in sqoop command when importing dbcs data from teradata

["Lucy Gu (JIRA)" <ji...@apache.org>]

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)