[HIVE-9576] ALTER TABLE STORED AS - change storage format and/or compression

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.14.0
• Component/s: Compression, File Formats, Parser, Query Planning, Query Processor, Serializers/Deserializers, SQL, StorageHandler

Environment

HDP 2.2

• Assignee: Unassigned
• Reporter: Hari Sekhon
• Created: 04/Feb/15 14:11
• Updated: 17/Feb/16 16:36

Description

Feature request to support rewriting a table into a different format or compression level via a single alter table statement:

ALTER TABLE ... STORED AS... TBLPROPERTIES(...)

Currently we create a new table of a different format and do

INSERT OVERWRITE newtable SELECT * FROM oldtable

but a colleague has just asked me why this can't be handled by a single alter statement via a tempory table replacement under the hood, which seems like a fair question.

Best Regards,

Hari Sekhon
http://www.linkedin.com/in/harisekhon