[SQOOP-3021] ClassWriter fails if a column name contains a backslash character

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.4.6
• Fix Version/s: 1.4.7
• Assignee: Vasas Szabolcs
• Reporter: Vasas Szabolcs
• Created: 06/Oct/16 14:44
• Updated: 07/Oct/16 07:31
• Resolved: 07/Oct/16 00:03

Description

The following Sqoop command fails with a javac error:

sqoop import --connect $MYCONN --username $MYUSER --password $MYPSWD --query "select C1_INT,C4_VARCHAR20, REGEXP_REPLACE(TRIM(C4_VARCHAR20),'\:','!') from T1_IMPORT WHERE \$CONDITIONS" --target-dir regex_imp --delete-target-dir -m 1

The reason is that the REGEXP_REPLACE expression contains a backslash character which does not get escaped in ClassWriter and an invalid string gets generated into the Java code.

SQOOP-2864 solved this problem for the double quote character we need to generalize that solution.

Issue Links

• is related to: SQOOP-2864 ClassWriter chokes on column names containing double quotes
• links to: ReviewBoard