What Should I Do If Error "Identifier name is too long" Is Reported During Entire DB Migration to Hive?

Symptom

An error message is displayed, indicating that the table name is too long, which is not true.

Possible Cause

A staging table whose name consists of the actual table name and a staging table suffix is created before data is imported. As a result, the job is abnormal.

Solution

• In the advanced attributes of job configuration, set Import to Staging Table to No so that data will not be imported to the staging table first.
• Shorten the actual table name.