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

["Gerrit Jansen van Vuuren (JIRA)" <ji...@apache.org>]

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

Gerrit Jansen van Vuuren updated CASSANDRA-5640:
------------------------------------------------
    Attachment: SIMPLE-CRUDE-OUTER-JOIN.patch

I've done some work on a simple outer join, its far from complete and requires:
 validation logic
 ability to distribute the join onto other nodes, or at least the key scan part.

In the SelectStatement (line 1255)
The JoinRowIterator.RowFinder anonymous class does the key lookup for the joined in row, the logic to get a remote row can be placed here.

 

> 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: API
>            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)