[ https://issues.apache.org/jira/browse/SQOOP-2561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15175627#comment-15175627 ]
VISHNU S NAIR commented on SQOOP-2561: -------------------------------------- Special Character removal from Column name as avro data results in duplicate column and fails the import Solution : Instead of removing the special character, replace it with underscore Corresponding test case is also included in the patch. Thanks & regards Vishnu S Nair. > Special Character removal from Column name as avro data results in duplicate > column and fails the import > -------------------------------------------------------------------------------------------------------- > > Key: SQOOP-2561 > URL: https://issues.apache.org/jira/browse/SQOOP-2561 > Project: Sqoop > Issue Type: Bug > Environment: cdh5.3.2 > Reporter: Suresh > Assignee: VISHNU S NAIR > Labels: AVRO, SQOOP > > When a Special character like '$' or '#' are present in column name, > sqoop/avro removes those special character. In some cases it leads to > duplicate column. > e.g. If we have COL$1 and COL1$ in the schema, it removes both of them and > creates the duplicate column as COL1 and it results in failure of the SQOOP > import job as a avro data. The same table can be loaded without > --as-avarodata flag. > The similar issue is raised in, > https://issues.apache.org/jira/browse/SQOOP-1361 - which i suppose is fixed > and the fix is creating this new issue. -- This message was sent by Atlassian JIRA (v6.3.4#6332)