[SQOOP-314] Basic export hangs when target database does not support INSERT syntax with multiple rows of values

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.4.0-incubating
• Assignee: Bilung Lee
• Reporter: Bilung Lee
• Created: 11/Aug/11 23:44
• Updated: 19/Aug/11 21:14
• Resolved: 19/Aug/11 20:27

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.