Nimi Wariboko Jr. created CASSANDRA-11947: ---------------------------------------------
Summary: 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 Reporter: Nimi Wariboko Jr. 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 (v6.3.4#6332)