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

Allow MV's select statements to be more complex

    XMLWordPrintableJSON

Details

    • Clients

    Description

      Materialized Views add support for a syntax which includes a SELECT statement, but only allows selection of direct columns, and does not allow any filtering to take place.

      We should add support to the MV SELECT statement to bring better parity with the normal CQL SELECT statement, specifically simple functions in the selected columns, as well as specifying a WHERE clause.

      Attachments

        Issue Links

          is duplicated by

          New Feature - A new feature of the product, which has yet to be developed. CASSANDRA-9809 Full support for WHERE clause in MV

          • Normal -
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. CASSANDRA-9922 Add Materialized View WHERE schema support

          • Normal -
          • Resolved
          is related to

          New Feature - A new feature of the product, which has yet to be developed. CASSANDRA-6477 Materialized Views (was: Global Indexes)

          • Normal -
          • Resolved

          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-10609 MV performance regression

          • Urgent - This issue should block release until it is resolved, and trigger immediate release once resolved.
          • Resolved

          Activity

            People

              thobbs Tom Hobbs
              carlyeks Carl Yeksigian
              Tom Hobbs
              Sylvain Lebresne
              Alan Boudreault Alan Boudreault
              Votes:
              0 Vote for this issue
              Watchers:
              15 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: