[jira] [Resolved] (IMPALA-3231) renaming table discards column statistics

["Tim Armstrong (JIRA)" <ji...@apache.org>]

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

Tim Armstrong resolved IMPALA-3231.
-----------------------------------
    Resolution: Duplicate

> renaming table discards column statistics
> -----------------------------------------
>
>                 Key: IMPALA-3231
>                 URL: https://issues.apache.org/jira/browse/IMPALA-3231
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Catalog
>    Affects Versions: impala 2.3
>         Environment: CDH 5.5.2
>            Reporter: Ruslan Dautkhanov
>              Labels: CBO, DDL, ramp-up, statistics
>
> Renaming table discards column statistics.
> Some of the tables we have collecting stats takes an hour, so it would be great to preserve stats if we have to rename a table.
> Test case:
> {quote}create table test_col_stats_a 
> as 
> select 'aa' union all select 'bb' ;
> show column stats test_col_stats_a;
> compute stats test_col_stats_a;
> show column stats test_col_stats_a;
> alter table test_col_stats_a rename to test_col_stats_b;
> show column stats test_col_stats_b;
> {quote}



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