[HIVE-2086] Add test coverage for external table data loss issue

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.7.0
• Fix Version/s: 0.8.0
• Component/s: Metastore

Environment

Amazon elastics mapreduce cluster

• Hadoop Flags: Reviewed
• Tags: data loss external table create like
• Assignee: Jonathan Natkins
• Reporter: Q Long
• Created: 31/Mar/11 18:05
• Updated: 16/Dec/11 23:57
• Resolved: 21/Jul/11 19:32

Description

Data loss when using "create external table like" statement.

1) Set up an external table S, point to location L. Populate data in S.
2) Create another external table T, using statement like this:
create external table T like S location L
Make sure table T point to the same location as the original table S.
3) Query table T, see the same set of data in S.
4) drop table T.
5) Query table S will return nothing, and location L is deleted.

Issue Links

• is related to: HIVE-1218 CREATE TABLE t LIKE some_view should create a new empty base table, but instead creates a copy of view