[ https://issues.apache.org/jira/browse/CASSANDRA-6477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14616644#comment-14616644 ]
Christopher Batey edited comment on CASSANDRA-6477 at 7/7/15 12:58 PM: ----------------------------------------------------------------------- I got a lot of these in my log when playing with the branch, however the views I created worked fine. {code} WARN [CompactionExecutor:111] 2015-07-07 10:57:09,023 MaterializedViewBuilder.java:189 - Materialized View failed to complete, sleeping 5 minutes before restarting org.apache.cassandra.exceptions.InvalidRequestException: Missing mandatory PRIMARY KEY part host_id at org.apache.cassandra.cql3.statements.RequestValidations.invalidRequest(RequestValidations.java:199) ~[main/:na] at org.apache.cassandra.cql3.statements.RequestValidations.checkTrue(RequestValidations.java:63) ~[main/:na] at org.apache.cassandra.cql3.statements.RequestValidations.checkNotNull(RequestValidations.java:140) ~[main/:na] at org.apache.cassandra.cql3.statements.ModificationStatement.buildPartitionKeyNames(ModificationStatement.java:395) ~[main/:na] at org.apache.cassandra.cql3.statements.ModificationStatement.getMutations(ModificationStatement.java:752) ~[main/:na] at org.apache.cassandra.cql3.statements.ModificationStatement.executeInternal(ModificationStatement.java:727) ~[main/:na] at org.apache.cassandra.cql3.QueryProcessor.executeInternal(QueryProcessor.java:293) ~[main/:na] at org.apache.cassandra.db.SystemKeyspace.setMaterializedViewBuilt(SystemKeyspace.java:453) ~[main/:na] at org.apache.cassandra.db.SystemKeyspace.finishMaterializedViewBuildStatus(SystemKeyspace.java:472) ~[main/:na] at org.apache.cassandra.db.view.MaterializedViewBuilder.run(MaterializedViewBuilder.java:174) ~[main/:na] at org.apache.cassandra.db.compaction.CompactionManager$13.run(CompactionManager.java:1364) [main/:na] {code} was (Author: chbatey): I got a lot of these in my log when playing with the branch, however the views I created worked fine. {quote} WARN [CompactionExecutor:111] 2015-07-07 10:57:09,023 MaterializedViewBuilder.java:189 - Materialized View failed to complete, sleeping 5 minutes before restarting org.apache.cassandra.exceptions.InvalidRequestException: Missing mandatory PRIMARY KEY part host_id at org.apache.cassandra.cql3.statements.RequestValidations.invalidRequest(RequestValidations.java:199) ~[main/:na] at org.apache.cassandra.cql3.statements.RequestValidations.checkTrue(RequestValidations.java:63) ~[main/:na] at org.apache.cassandra.cql3.statements.RequestValidations.checkNotNull(RequestValidations.java:140) ~[main/:na] at org.apache.cassandra.cql3.statements.ModificationStatement.buildPartitionKeyNames(ModificationStatement.java:395) ~[main/:na] at org.apache.cassandra.cql3.statements.ModificationStatement.getMutations(ModificationStatement.java:752) ~[main/:na] at org.apache.cassandra.cql3.statements.ModificationStatement.executeInternal(ModificationStatement.java:727) ~[main/:na] at org.apache.cassandra.cql3.QueryProcessor.executeInternal(QueryProcessor.java:293) ~[main/:na] at org.apache.cassandra.db.SystemKeyspace.setMaterializedViewBuilt(SystemKeyspace.java:453) ~[main/:na] at org.apache.cassandra.db.SystemKeyspace.finishMaterializedViewBuildStatus(SystemKeyspace.java:472) ~[main/:na] at org.apache.cassandra.db.view.MaterializedViewBuilder.run(MaterializedViewBuilder.java:174) ~[main/:na] at org.apache.cassandra.db.compaction.CompactionManager$13.run(CompactionManager.java:1364) [main/:na] {quote} > Materialized Views (was: Global Indexes) > ---------------------------------------- > > Key: CASSANDRA-6477 > URL: https://issues.apache.org/jira/browse/CASSANDRA-6477 > Project: Cassandra > Issue Type: New Feature > Components: API, Core > Reporter: Jonathan Ellis > Assignee: Carl Yeksigian > Labels: cql > Fix For: 3.0 beta 1 > > Attachments: test-view-data.sh > > > Local indexes are suitable for low-cardinality data, where spreading the > index across the cluster is a Good Thing. However, for high-cardinality > data, local indexes require querying most nodes in the cluster even if only a > handful of rows is returned. -- This message was sent by Atlassian JIRA (v6.3.4#6332)