Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-538 Support UDFs
  3. PHOENIX-1907

Update functional index data created with UDF when there is change in implementation.

    Details

    • Type: Sub-task
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: 4.4.1
    • Labels:
      None

      Description

      There is possibility that user can change the implementation of udf function. Then handle unloading the existing jars of the old implementation and upload the index data with new implementation. Recreating index might be faster than updating the index. Need to check better solution for this.

        Activity

        Hide
        tdsilva Thomas D'Silva added a comment -

        Updating the index would involve updating the column containing the function whereas recreating the index would involve re-running the UPSERT SELECT for all indexed columns.
        Both of these might take a long time depending on the number of indexes there are that use the function and the rows in the data table for each index.

        Maybe the best option is to disable the functional indexes, and then the user can rebuild them.

        Show
        tdsilva Thomas D'Silva added a comment - Updating the index would involve updating the column containing the function whereas recreating the index would involve re-running the UPSERT SELECT for all indexed columns. Both of these might take a long time depending on the number of indexes there are that use the function and the rows in the data table for each index. Maybe the best option is to disable the functional indexes, and then the user can rebuild them.

          People

          • Assignee:
            rajeshbabu Rajeshbabu Chintaguntla
            Reporter:
            rajeshbabu Rajeshbabu Chintaguntla
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:

              Development