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

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

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 1.4.0-incubating
    • None
    • 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

        1. SQOOP-314.diff
          14 kB
          Bilung Lee

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment