hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dmitry Tolpeko (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-12676) [hive+impala] Alter table Rename to + Set location in a single step
Date Sun, 10 Sep 2017 21:46:00 GMT

     [ https://issues.apache.org/jira/browse/HIVE-12676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Dmitry Tolpeko updated HIVE-12676:
----------------------------------
    Component/s:     (was: hpl/sql)

> [hive+impala] Alter table Rename to + Set location in a single step
> -------------------------------------------------------------------
>
>                 Key: HIVE-12676
>                 URL: https://issues.apache.org/jira/browse/HIVE-12676
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Egmont Koblinger
>            Assignee: Dmitry Tolpeko
>            Priority: Minor
>
> Assume a nonstandard table location, let's say /foo/bar/table1. You might want to rename
from table1 to table2 and move the underlying data accordingly to /foo/bar/table2.
> The "alter table ... rename to ..." clause alters the table name, but in the same step
moves the data into the standard location /user/hive/warehouse/table2. Then a subsequent "alter
table ... set location ..." can move it back to the desired location /foo/bar/table2.
> This is problematic if there's any permission problem in the game, e.g. not being able
to write to /user/hive/warehouse. So it should be possible to move the underlying data to
its desired final place without intermittent places in between.
> A probably hard to discover workaround is to set the table to external, then rename it,
then set back to internal and then change its location.
> It would be great to be able to do an "alter table ... rename to ... set location ..."
operation in a single step.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message