Sqoop
  1. Sqoop
  2. SQOOP-332

Cannot use --as-avrodatafile with --query

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 1.3.0
    • Fix Version/s: 1.4.0-incubating
    • Component/s: codegen
    • Labels:
      None

      Description

      Using sqoop with --as-avrodatafile and --query to specify a freeform query causes an exception:

      11/08/30 19:55:28 ERROR sqoop.Sqoop: Got exception running Sqoop: org.apache.avro.AvroRuntimeException: Can't set a property to null: tableName
      org.apache.avro.AvroRuntimeException: Can't set a property to null: tableName
      	at org.apache.avro.Schema$Props.add(Schema.java:124)
      	at org.apache.avro.Schema.addProp(Schema.java:166)
      	at com.cloudera.sqoop.orm.AvroSchemaGenerator.generate(AvroSchemaGenerator.java:69)
      	at com.cloudera.sqoop.mapreduce.DataDrivenImportJob.configureMapper(DataDrivenImportJob.java:78)
      	at com.cloudera.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:175)
      	at com.cloudera.sqoop.manager.SqlManager.importQuery(SqlManager.java:442)
      	at com.cloudera.sqoop.tool.ImportTool.importTable(ImportTool.java:352)
      	at com.cloudera.sqoop.tool.ImportTool.run(ImportTool.java:423)
      	at com.cloudera.sqoop.Sqoop.run(Sqoop.java:144)
      	at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
      	at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180)
      	at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:219)
      	at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:228)
      	at com.cloudera.sqoop.Sqoop.main(Sqoop.java:237)
      1. SQOOP-332.patch
        5 kB
        Joseph Boyd
      2. SQOOP-332.patch
        0.9 kB
        Joseph Boyd

        Activity

        Arvind Prabhakar made changes -
        Affects Version/s 1.4.0 [ 12317345 ]
        Arvind Prabhakar made changes -
        Status Patch Available [ 10002 ] Resolved [ 5 ]
        Fix Version/s 1.4.0 [ 12317345 ]
        Resolution Fixed [ 1 ]
        Joseph Boyd made changes -
        Status Open [ 1 ] Patch Available [ 10002 ]
        Joseph Boyd made changes -
        Attachment SQOOP-332.patch [ 12494348 ]
        Joseph Boyd made changes -
        Status Patch Available [ 10002 ] Open [ 1 ]
        Arvind Prabhakar made changes -
        Assignee Joseph Boyd [ jboyd963 ]
        Joseph Boyd made changes -
        Status Open [ 1 ] Patch Available [ 10002 ]
        Affects Version/s 1.4.0 [ 12317345 ]
        Joseph Boyd made changes -
        Field Original Value New Value
        Attachment SQOOP-332.patch [ 12493874 ]
        Aaron Kimball created issue -

          People

          • Assignee:
            Joseph Boyd
            Reporter:
            Aaron Kimball
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development