[ https://issues.apache.org/jira/browse/CASSANDRA-11947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
C. Scott Andreas updated CASSANDRA-11947: ----------------------------------------- Component/s: Materialized Views > Ability to create a Materialized View without primary key column that has '=' > relation > -------------------------------------------------------------------------------------- > > Key: CASSANDRA-11947 > URL: https://issues.apache.org/jira/browse/CASSANDRA-11947 > Project: Cassandra > Issue Type: Improvement > Components: Materialized Views > Reporter: Nimi Wariboko Jr. > Priority: Major > > I have a use case where I'd like to create a materialized view where one of > the columns is filtered on a '=' relation and the primary key for that > materialized view doesn't include that column. > Example: > {code} > CREATE TABLE analytics ( > resourceId text, > country text, > date timestamp, > clicks int, > PRIMARY KEY(resourceId, date, country) > ); > CREATE MATERIALIZED VIEW analytics_ww AS > SELECT * FROM analytics > WHERE country = 'WW' > PRIMARY KEY (resourceId, date); > {code} > This way I can have a table filtered on a high cardinality column, and I > don't also have to specify that column, even though I already know thats the > only value in the view. -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org