cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ryan Svihla (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (CASSANDRA-9284) support joins if partition key is the same in both tables
Date Fri, 01 May 2015 14:33:06 GMT

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

Ryan Svihla edited comment on CASSANDRA-9284 at 5/1/15 2:32 PM:
----------------------------------------------------------------

This could add some flexibility to data modeling practices and would allow one giant table
to be split up into smaller tables. One would still have to be mindful of the total retrieval
size in a way we do not have to consider now, but this would I believe help people new to
Cassandra still keep their table models conceptually broken up into smaller easier to understand
pieces.

Also is has the side effect of reducing partition size into smaller logical units wrt compaction.
Some data models that would probably go over the in_memory_compaction_limit previously would
no longer as that data would be split up into different tables. This effectively allows another
type of sharding for large logical rows.


was (Author: rssvihla):
This could add some flexibility to data modeling practices and would allow one giant table
to be split up into smaller tables. One would still have to be mindful of the total retrieval
size in a way we do not have to consider now, but this would I believe help people new to
Cassandra still keep their table models conceptually broken up into smaller easier to understand
pieces.

> support joins if partition key is the same in both tables
> ---------------------------------------------------------
>
>                 Key: CASSANDRA-9284
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-9284
>             Project: Cassandra
>          Issue Type: Improvement
>            Reporter: Jon Haddad
>            Priority: Minor
>
> Based off this conversation: https://mail-archives.apache.org/mod_mbox/cassandra-dev/201505.mbox/%3CCACUnPaAfJqU%2B86fFd4S6MS7Wv0KhpT_vavdkvDS%2Bm4Madi8_cg%40mail.gmail.com%3E
> It would be nice to have the flexibility of joins if we knew the query could be satisfied
on a single node.  



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message