hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stephen Miller (JIRA)" <>
Subject [jira] [Commented] (HIVE-9576) ALTER TABLE STORED AS - change storage format and/or compression
Date Wed, 17 Feb 2016 16:36:18 GMT


Stephen Miller commented on HIVE-9576:

If it helps, the following command does work:

LIKE MyOldTable

So at least you can copy over the schema easily.

I suspect changing storage type under the hood is trickier than it sounds if you want the
table to remain writeable during the process; there would be delta files involved.

> ALTER TABLE STORED AS - change storage format and/or compression
> ----------------------------------------------------------------
>                 Key: HIVE-9576
>                 URL:
>             Project: Hive
>          Issue Type: New Feature
>          Components: Compression, File Formats, Parser, Query Planning, Query Processor,
Serializers/Deserializers, SQL, StorageHandler
>    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:
> 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

This message was sent by Atlassian JIRA

View raw message