[
https://issues.apache.org/jira/browse/CASSANDRA-6477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14626797#comment-14626797
]
Jonathan Ellis commented on CASSANDRA-6477:
-------------------------------------------
I don't think this is the right solution, because *sometimes* denormalizing the
null as partition key *is* the right solution. Which means we do need to
support using columns that are not marked NOT NULL in MV PK. Adding a warning
in that case is appealing but I think history shows that this won't actually
help the people who need it. (See: everyone shooting themselves in the foot
with ALLOW FILTERING queries.)
So ultimately, if we're not going to disallow it entirely (and we shouldn't),
then we really haven't gained very much. Especially if the band aid is as ugly
as this one.
> 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, users.yaml
>
>
> 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)
