[HIVE-3465] insert into statement overwrites if target table is prefixed with database name

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.8.1
• Fix Version/s: 0.10.0
• Component/s: Query Processor
• Hadoop Flags: Reviewed
• Assignee: Navis Ryu
• Reporter: Kaufman Ng
• Created: 14/Sep/12 15:07
• Updated: 10/Jan/13 19:53
• Resolved: 26/Sep/12 09:19

Description

insert into statement works as expected when the target table is not prefixed with database name. It does append correctly.

However, if I specify a database name prefixing the target table, the statement just overwrites instead of appends:

insert into table my_database.target select * from source;

Issue Links

• breaks: HIVE-3676 INSERT INTO regression caused by HIVE-3465
• is related to: HIVE-3062 Insert into table overwrites existing table if table name contains uppercase character