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

Improve performance of ALTER TABLE ADD PARTITION

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • Impala 1.1.1
    • Impala 1.2
    • None
    • None

    Description

      Each time an "ALTER TABLE ADD PARTITION" statement is executed, the table metadata is partially invalidated and reloaded. For tables with few partitions, this is relatively fast (<1 second), but increases linearly over time with the number of partitions. A table with 2000 partitions can take 20s+ to complete execution of a single ALTER TABLE ADD PARTITION statement. We should fix this by skipping the invalidation/reload step and instead directly applying the metadata changes to the HdfsTable object.

      Attachments

        Activity

          People

            lskuff Lenni Kuff
            lskuff Lenni Kuff
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: