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

["Hari Sekhon (JIRA)" <ji...@apache.org>]

Hari Sekhon created HIVE-9576:
---------------------------------

             Summary: ALTER TABLE STORED AS - change storage format and/or compression
                 Key: HIVE-9576
                 URL: https://issues.apache.org/jira/browse/HIVE-9576
             Project: Hive
          Issue Type: New Feature
    Affects Versions: 0.14.0
         Environment: HDP 2.2
            Reporter: Hari Sekhon


Feature request to support rewriting a table into a different format or compression level via a single alter table statement:
{code}ALTER TABLE ... STORED AS... TBLPROPERTIES(...){code}
Currently we create a new table of a different format and do
{code}INSERT OVERWRITE newtable SELECT * FROM oldtable{code}
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



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)