Return-Path: X-Original-To: apmail-cassandra-commits-archive@www.apache.org Delivered-To: apmail-cassandra-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 78F3D1892A for ; Fri, 18 Mar 2016 20:07:34 +0000 (UTC) Received: (qmail 57647 invoked by uid 500); 18 Mar 2016 20:07:34 -0000 Delivered-To: apmail-cassandra-commits-archive@cassandra.apache.org Received: (qmail 57608 invoked by uid 500); 18 Mar 2016 20:07:34 -0000 Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cassandra.apache.org Delivered-To: mailing list commits@cassandra.apache.org Received: (qmail 57322 invoked by uid 99); 18 Mar 2016 20:07:34 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 18 Mar 2016 20:07:34 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id C1E482C1F78 for ; Fri, 18 Mar 2016 20:07:33 +0000 (UTC) Date: Fri, 18 Mar 2016 20:07:33 +0000 (UTC) From: "Aleksey Yeschenko (JIRA)" To: commits@cassandra.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Resolved] (CASSANDRA-5640) Allow JOIN on partition key for tables in the same keyspace MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ 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)