[HIVE-1218] CREATE TABLE t LIKE some_view should create a new empty base table, but instead creates a copy of view

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.7.0
• Fix Version/s: 0.8.0
• Component/s: Query Processor
• Hadoop Flags: Reviewed
• Release Note: In 0.8.0, CREATE TABLE LIKE view_name creates a table by adopting the schema of view_name (fields and partition columns) using defaults for serde and file formats. Before 0.8.0, CREATE TABLE LIKE view_name would make a copy of the view.
• Assignee: Charles Chen
• Reporter: John Sichi
• Created: 09/Mar/10 23:23
• Updated: 16/Dec/11 23:56
• Resolved: 18/Jul/11 19:01

Description

I think it should copy only the column definitions from the view metadata. Currently it is copying the entire descriptor, resulting in a new view instead of a new base table.

Issue Links

• blocks: HIVE-2268 CREATE.. TABLE.. LIKE should not inherit the original owner of the table.
• relates to: HIVE-2086 Add test coverage for external table data loss issue
• relates to: HIVE-972 Support views