[jira] [Comment Edited] (CASSANDRA-9284) support joins if partition key is the same in both tables

["Ryan Svihla (JIRA)" <ji...@apache.org>]

    [ 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)