Uploaded image for project: 'Sqoop (Retired)'
  1. Sqoop (Retired)
  2. SQOOP-2596

Precision of varchar/char column cannot be retrieved from teradata database during sqoop import

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Patch Available
    • Minor
    • Resolution: Unresolved
    • 1.4.6
    • 1.5.0
    • None
    • None

    Description

      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)

      Attachments

        1. SQOOP-2596_3.patch
          28 kB
          Kopal Niranjan
        2. SQOOP-2596_2.patch
          28 kB
          Kopal Niranjan
        3. SQOOP-2596_1.patch
          14 kB
          Kopal Niranjan
        4. SQOOP-2596_0.patch
          3 kB
          Kopal Niranjan

        Issue Links

          Activity

            People

              kniranjan Kopal Niranjan
              kniranjan Kopal Niranjan
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: