[ https://issues.apache.org/jira/browse/CASSANDRA-13956?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16205669#comment-16205669 ]
Kurt Greaves commented on CASSANDRA-13956: ------------------------------------------ See CASSANDRA-13798. This was done on purpose. If you absolutely do need it and can handle potential problems, there is a JVM property you can set to enable this functionality. > Cannot restrict columns on materialized view > -------------------------------------------- > > Key: CASSANDRA-13956 > URL: https://issues.apache.org/jira/browse/CASSANDRA-13956 > Project: Cassandra > Issue Type: Bug > Components: Materialized Views > Environment: [cqlsh 5.0.1 | Cassandra 3.11.1 | CQL spec 3.4.4 | > Native protocol v4] > Reporter: Chema Vinacua > Fix For: 3.11.1 > > > After upgrading from 3.11.0 to 3.11.1 I cannot define materialized views > restricted on non primary key columns. > I get: InvalidRequest: Error from server: code=2200 [Invalid query] > message="Non-primary key columns cannot be restricted in the SELECT statement > used for materialized view creation (got restrictions on: d_destination_set)" > In my 3.11.0 cluster: > $ cqlsh ****** > Connected to Test Cluster at ********:9042. > [cqlsh 5.0.1 | Cassandra 3.11.0 | CQL spec 3.4.4 | Native protocol v4] > Use HELP for help. > cqlsh> CREATE TABLE phoenix.test_table ( > ... datetime_bucket ascii primary key, > ... d_destination_set boolean, > ... d_destination_timestamp timestamp > ... ); > cqlsh> CREATE MATERIALIZED VIEW phoenix.test_view AS > ... SELECT datetime_bucket, > ... d_destination_set > ... FROM phoenix.test_table > ... WHERE datetime_bucket IS NOT NULL > ... AND d_destination_set = FALSE > ... PRIMARY KEY (datetime_bucket, d_destination_set); > cqlsh> > No errors shown here. > In my 3.11.1 cluster: > cqlsh> CREATE TABLE phoenix.test_table ( > ... datetime_bucket ascii primary key, > ... d_destination_set boolean, > ... d_destination_timestamp timestamp > ... ); > cqlsh> CREATE MATERIALIZED VIEW phoenix.test_view AS > ... SELECT datetime_bucket, > ... d_destination_set > ... FROM phoenix.test_table > ... WHERE datetime_bucket IS NOT NULL > ... AND d_destination_set = FALSE > ... PRIMARY KEY (datetime_bucket, d_destination_set); > InvalidRequest: Error from server: code=2200 [Invalid query] > message="Non-primary key columns cannot be restricted in the SELECT statement > used for materialized view creation (got restrictions on: d_destination_set)" -- This message was sent by Atlassian JIRA (v6.4.14#64029) --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org