[jira] [Resolved] (IMPALA-10700) Introduce an option to skip deleting column statistics on truncate

["Vihang Karajgaonkar (Jira)" <ji...@apache.org>]

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

Vihang Karajgaonkar resolved IMPALA-10700.
------------------------------------------
    Fix Version/s: Impala 4.0
       Resolution: Fixed

> Introduce an option to skip deleting column statistics on truncate
> ------------------------------------------------------------------
>
>                 Key: IMPALA-10700
>                 URL: https://issues.apache.org/jira/browse/IMPALA-10700
>             Project: IMPALA
>          Issue Type: Improvement
>          Components: Catalog
>            Reporter: Vihang Karajgaonkar
>            Assignee: Vihang Karajgaonkar
>            Priority: Major
>             Fix For: Impala 4.0
>
>
> Currently when a user issues {{truncate table}} command on a non-transactional table, catalogd also deletes the table and column statistics. However, this can affect the performance of the truncate operation especially at high concurrency. Based on preliminary research it looks like other databases do not delete statistics after truncate operation (e.g Oracle, Hive). It would be good to introduce a query option which can set by the user to skip deleting the column statistics during the truncate table execution.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)