cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Ellis (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (CASSANDRA-6477) Materialized Views (was: Global Indexes)
Date Tue, 14 Jul 2015 18:14:13 GMT

    [ https://issues.apache.org/jira/browse/CASSANDRA-6477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14626797#comment-14626797
] 

Jonathan Ellis edited comment on CASSANDRA-6477 at 7/14/15 6:13 PM:
--------------------------------------------------------------------

I don't think this is the right solution, because *sometimes* denormalizing the null as partition
key *is* the right thing to do.  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.


was (Author: jbellis):
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)

Mime
View raw message