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

Minimize RPCs for ALTER statement over APPEND_ONLY_SCHEMA

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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

        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
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment