Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-2968

Minimize RPCs for ALTER statement over APPEND_ONLY_SCHEMA

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 4.8.0
    • None

    Description

      View is created with CREATE VIEW IF NOT EXISTS ... APPEND_ONLY_SCHEMA = true, UPDATE_CACHE_FREQUENCY=900000

      If ALTER VIEW <VIEW_NAME> ADD IF NOT EXISTS MYCOL VARCHAR is executed before each upsert statement then performance for each 1K batch upsert degrades by ~40X (50ms for 1K batch without alter statement vs 2300ms with alter statement)

      This is for the case when MYCOL exists.

      Attachments

        1. PHOENIX-2968.patch
          13 kB
          Thomas D'Silva

        Issue Links

          is related to

          Sub-task - The sub-task of the issue PHOENIX-2791 Support append only schema declaration

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. PHOENIX-3300 Writing rows to multiple views on the same physical table with different indexes in a single batch fails.

          • Major - Major loss of function.
          • Open

          Activity

            People

              tdsilva Thomas D'Silva
              mujtabachohan Mujtaba Chohan
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: