Uploaded image for project: 'Sqoop (READ-ONLY)'
  1. Sqoop (READ-ONLY)
  2. SQOOP-67

NPE when column name list contains spaces. E.g. sqoop -import --columns "col1, col2"

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.1.0
    • Fix Version/s: 1.3.0
    • Component/s: import
    • Labels:
      None
    • Environment:
      sqoop import for an Oracle database.

      Description

      sqoop import ... --table JUNK --columns "OWNER, OBJECT_NAME"

      The 'space' character between "OWNER," and "OBJECT_NAME" results in a NPE.

      ClassWriter.generate() needs to be updated. This method copes with the user supplying column names with the incorrect case - but should also trim each column name supplied by the user.

      10/08/11 09:09:37 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.NullPointerException
      java.lang.NullPointerException
      at com.cloudera.sqoop.orm.ClassWriter.generateFields(ClassWriter.java:430)
      at com.cloudera.sqoop.orm.ClassWriter.generateClassForColumns(ClassWriter.java:1099)
      at com.cloudera.sqoop.orm.ClassWriter.generate(ClassWriter.java:972)
      at com.cloudera.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
      at com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:329)
      at com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:415)
      at com.cloudera.sqoop.Sqoop.run(Sqoop.java:134)
      at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
      at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:79)
      at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:170)
      at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:196)
      at com.cloudera.sqoop.Sqoop.main(Sqoop.java:205)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                jon Jonathan Hsieh
                Reporter:
                guylemar Guy le Mar
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: