Return-Path: X-Original-To: apmail-phoenix-dev-archive@minotaur.apache.org Delivered-To: apmail-phoenix-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 1EC5110962 for ; Fri, 26 Dec 2014 01:12:53 +0000 (UTC) Received: (qmail 29294 invoked by uid 500); 26 Dec 2014 01:12:53 -0000 Delivered-To: apmail-phoenix-dev-archive@phoenix.apache.org Received: (qmail 29232 invoked by uid 500); 26 Dec 2014 01:12:53 -0000 Mailing-List: contact dev-help@phoenix.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@phoenix.apache.org Delivered-To: mailing list dev@phoenix.apache.org Received: (qmail 29220 invoked by uid 99); 26 Dec 2014 01:12:53 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 26 Dec 2014 01:12:53 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED,T_RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.3] (HELO mail.apache.org) (140.211.11.3) by apache.org (qpsmtpd/0.29) with SMTP; Fri, 26 Dec 2014 01:12:30 +0000 Received: (qmail 29002 invoked by uid 99); 26 Dec 2014 01:11:13 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 26 Dec 2014 01:11:13 +0000 Date: Fri, 26 Dec 2014 01:11:13 +0000 (UTC) From: "Anoop Sam John (JIRA)" To: dev@phoenix.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (PHOENIX-1560) Join between global index and data table if INDEX hint used MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/PHOENIX-1560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14258883#comment-14258883 ] Anoop Sam John commented on PHOENIX-1560: ----------------------------------------- I see.. In HIndex it was seek + scan.. (basically skip scan) > Join between global index and data table if INDEX hint used > ----------------------------------------------------------- > > Key: PHOENIX-1560 > URL: https://issues.apache.org/jira/browse/PHOENIX-1560 > Project: Phoenix > Issue Type: Bug > Reporter: James Taylor > > We already have an INDEX hint, and we already have a mechanism to collect referenced columns in the data table that are not in the index table (used only for local indexes currently). Instead of not using the global index when a referenced data column is not found in the index, we should rewrite the query to join back to the data table when the INDEX hint is present. This is always possible, as we always have the data PK columns in the index table, and our join optimization would kick in as well. -- This message was sent by Atlassian JIRA (v6.3.4#6332)