[jira] [Commented] (CASSANDRA-5640) Allow JOIN on partition key for tables in the same keyspace
[ https://issues.apache.org/jira/browse/CASSANDRA-5640?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13683569#comment-13683569 ] Jonathan Ellis commented on CASSANDRA-5640: --- I've had the same thought but I hate cluttering Jira with "maybe someday" ponies. :P > 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: ponies > > 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 is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-5640) Allow JOIN on partition key for tables in the same keyspace
[ https://issues.apache.org/jira/browse/CASSANDRA-5640?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14252271#comment-14252271 ] Gerrit Jansen van Vuuren commented on CASSANDRA-5640: - A basic example of how the patch works is: cqlsh:test> select * from src ; id | a ---+--- 5 | a5 1 | a1 2 | a2 4 | a4 3 | a3 (5 rows) cqlsh:test> select * from dst; a | b ---+--- a4 | b4 a3 | b3 a2 | b2 a1 | b1 cqlsh:test> select a, dst.b as q from src join dst on a; a | q ---+- a5 | null a1 | b1 a2 | b2 a4 | b4 a3 | b3 > 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)
[jira] [Commented] (CASSANDRA-5640) Allow JOIN on partition key for tables in the same keyspace
[ https://issues.apache.org/jira/browse/CASSANDRA-5640?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14252322#comment-14252322 ] Jonathan Ellis commented on CASSANDRA-5640: --- /cc [~tupshin] > 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)
[jira] [Commented] (CASSANDRA-5640) Allow JOIN on partition key for tables in the same keyspace
[ https://issues.apache.org/jira/browse/CASSANDRA-5640?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14188542#comment-14188542 ] Jeremiah Jordan commented on CASSANDRA-5640: Just came up with one reason to need this. Getting counter and non counter data in the same query. > 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 > > 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)