Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-13798

Disallow filtering on non-primary-key base column for MV

    XMLWordPrintableJSON

Details

    • Correctness - API / Semantic Implementation
    • Normal

    Description

      We should probably consider disallow filtering conditions on non-primary-key base column for Materialized View which is introduced in CASSANDRA-10368.

      The main problem is that the liveness of view row is now depending on multiple base columns (multiple filtered non-pk base column + base column used in view pk) and this semantic could not be properly support without drastic storage format changes. (SEE CASSANDRA-11500, background)

      We should step back and re-consider the non-primary-key filtering feature together with supporting multiple non-PK cols in MV clustering key in CASSANDRA-10226.

      Attachments

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. CASSANDRA-11500 Obsolete MV entry may not be properly deleted

          • Normal -
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. CASSANDRA-10226 Support multiple non-PK cols in MV clustering key when partition key is shared

          • Normal -
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. CASSANDRA-10368 Support Restricting non-PK Cols in Materialized View Select Statements

          • Low -
          • Resolved
          relates to

          Bug - A problem which impairs or prevents the functions of the product. CASSANDRA-13956 Cannot restrict columns on materialized view

          • Normal -
          • Resolved

          Activity

            People

              jasonstack Zhao Yang
              jasonstack Zhao Yang
              Zhao Yang
              Paulo Motta
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: