You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Quanlong Huang (Jira)" <ji...@apache.org> on 2021/05/27 01:04:00 UTC

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

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

Quanlong Huang updated IMPALA-10700:
------------------------------------
    Component/s: Catalog

> 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
>
> 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)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org