[SQOOP-3426] Import-all-tables fails on tables with names containing hyphens ( - )

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.4.6
• Component/s: codegen
• Assignee: Unassigned
• Reporter: Prasanna Saraswathi Krishnan
• Created: 12/Feb/19 17:37
• Updated: 12/Feb/19 17:37

Description

Patch - SQOOP-521 addresses the special characters in the table name only when importing the tables individually.

When importing a whole database (import-all-tables) with hive-import, the special characters like '-' in SQL Server table name doesn't get converted to a '_' in hive. 

 

This raises the below error -

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.apache.hadoop.hive.ql.metadata.HiveException: [table_name_with-hyphens]: is not a valid table name.