[CASSANDRA-9664] Allow MV's select statements to be more complex

• Type: New Feature
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 3.0.0 rc1
• Component/s: Feature/Materialized Views, Legacy/CQL
• Labels: doc-impacting
• Impacts: Clients
• Assignee: Tom Hobbs
• Reporter: Carl Yeksigian

Authors

Tom Hobbs

Reviewers

Sylvain Lebresne

• Tester: Alan Boudreault
• Created: 26/Jun/15 20:05
• Updated: 06/Nov/19 21:57
• Resolved: 28/Oct/15 14:16

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.

Issue Links

• is duplicated by: CASSANDRA-9809 Full support for WHERE clause in MV
• is duplicated by: CASSANDRA-9922 Add Materialized View WHERE schema support
• is related to: CASSANDRA-6477 Materialized Views (was: Global Indexes)
• is related to: CASSANDRA-10368 Support Restricting non-PK Cols in Materialized View Select Statements
• relates to: CASSANDRA-10609 MV performance regression