Uploaded image for project: 'Sqoop'
  1. Sqoop
  2. SQOOP-314

Basic export hangs when target database does not support INSERT syntax with multiple rows of values

    Details

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

      Description

      Basic export job will hang when the target database does not support INSERT syntax with multiple rows of values, such as INSERT INTO tbl (col1, col2) VALUES(11, 12),(21, 22),(23, 24)

      This is because, in close(), AsyncSqlRecordWriter will still wait for AsyncSqlExecThread to finish even when an SQLException is thrown underneath.

      The configuration variable "sqoop.export.records.per.statement" can be set to 1 as a workaround for this problem.

        Attachments

          Activity

            People

            • Assignee:
              bleeapache Bilung Lee
              Reporter:
              usblee Bilung Lee
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: