Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-10700

Introduce an option to skip deleting column statistics on truncate

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: Impala 4.0.0
    • Component/s: Catalog
    • Labels:
      None
    • Epic Color:
      ghx-label-12

      Description

      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.

        Attachments

          Activity

            People

            • Assignee:
              vihangk1 Vihang Karajgaonkar
              Reporter:
              vihangk1 Vihang Karajgaonkar
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: