[jira] [Resolved] (CASSANDRA-5640) Allow JOIN on partition key for tables in the same keyspace

["Aleksey Yeschenko (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CASSANDRA-5640?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Aleksey Yeschenko resolved CASSANDRA-5640.
------------------------------------------
    Resolution: Later

This would be nice to have indeed, but getting it right is not trivial at all.

Furthermore, given the limitations (same ks, same partition key), a very limited # of data models would be able to utilise the functionality - making it not working in most cases more confusing.

Resolving as Later for now.

> Allow JOIN on partition key for tables in the same keyspace
> -----------------------------------------------------------
>
>                 Key: CASSANDRA-5640
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-5640
>             Project: Cassandra
>          Issue Type: New Feature
>          Components: CQL
>            Reporter: Jeremiah Jordan
>            Priority: Minor
>              Labels: cql
>         Attachments: SIMPLE-CRUDE-OUTER-JOIN.patch
>
>
> People whine about there not being any JOIN in CQL a lot.  I was thinking we could add JOIN with the restriction that you can only join on partition key, and only if the tables are in the same keyspace.  That way it could be done local to each node, and would not need to be a true distributed join.
> Feel free to shoot me down ;)



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