[jira] [Updated] (SQOOP-2596) Precision of varchar/char column cannot be retrieved from teradata database during sqoop import

["Kopal Niranjan (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SQOOP-2596?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kopal Niranjan updated SQOOP-2596:
----------------------------------
    Attachment: SQOOP-2596_2.patch

> Precision of varchar/char column cannot be retrieved from teradata database during sqoop import 
> ------------------------------------------------------------------------------------------------
>
>                 Key: SQOOP-2596
>                 URL: https://issues.apache.org/jira/browse/SQOOP-2596
>             Project: Sqoop
>          Issue Type: Bug
>    Affects Versions: 1.4.6
>            Reporter: Kopal Niranjan
>            Assignee: Kopal Niranjan
>            Priority: Minor
>             Fix For: 1.4.7
>
>         Attachments: SQOOP-2596_0.patch, SQOOP-2596_1.patch, SQOOP-2596_2.patch
>
>
> when doing sqoop import from teradata database using jdbc teradata driver, following exception comes for varchar columns:
> 15/09/24 01:52:30 INFO hcat.SqoopHCatUtilities: FAILED: ParseException line 3:18 mismatched input ',' expecting ( near 'varchar' in primitive type specification
> 15/09/24 01:52:30 ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: HCat exited with status 64
> at org.apache.sqoop.mapreduce.hcat.SqoopHCatUtilities.executeExternalHCatProgram(SqoopHCatUtilities.java:1129)
> at org.apache.sqoop.mapreduce.hcat.SqoopHCatUtilities.launchHCatCli(SqoopHCatUtilities.java:1078)
> at org.apache.sqoop.mapreduce.hcat.SqoopHCatUtilities.createHCatTable(SqoopHCatUtilities.java:625)
> at org.apache.sqoop.mapreduce.hcat.SqoopHCatUtilities.configureHCat(SqoopHCatUtilities.java:340)
> at org.apache.sqoop.mapreduce.hcat.SqoopHCatUtilities.configureImportOutputFormat(SqoopHCatUtilities.java:783)
> at org.apache.sqoop.mapreduce.ImportJobBase.configureOutputFormat(ImportJobBase.java:98)
> at org.apache.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:259)
> at org.apache.sqoop.manager.SqlManager.importTable(SqlManager.java:692)
> at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:497)
> at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:605)
> at org.apache.sqoop.Sqoop.run(Sqoop.java:143)
> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:179)
> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:218)
> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:227)
> at org.apache.sqoop.Sqoop.main(Sqoop.java:236)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)