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

Import-all-tables fails on tables with names containing hyphens ( - )

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.4.6
    • None
    • codegen
    • None

    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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            prasanna.sk Prasanna Saraswathi Krishnan
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: