Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 0783C200D49 for ; Fri, 10 Nov 2017 00:54:05 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 063DA160BEF; Thu, 9 Nov 2017 23:54:05 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 4F20B160C02 for ; Fri, 10 Nov 2017 00:54:04 +0100 (CET) Received: (qmail 79379 invoked by uid 500); 9 Nov 2017 23:54:03 -0000 Mailing-List: contact issues-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list issues@hive.apache.org Received: (qmail 79350 invoked by uid 99); 9 Nov 2017 23:54:03 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 09 Nov 2017 23:54:03 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 7EE79180783 for ; Thu, 9 Nov 2017 23:54:02 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -99.202 X-Spam-Level: X-Spam-Status: No, score=-99.202 tagged_above=-999 required=6.31 tests=[KAM_ASCII_DIVIDERS=0.8, RP_MATCHES_RCVD=-0.001, SPF_PASS=-0.001, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id csCnIErM72-H for ; Thu, 9 Nov 2017 23:54:01 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTP id A89F660D95 for ; Thu, 9 Nov 2017 23:54:01 +0000 (UTC) Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id EADE4E0F95 for ; Thu, 9 Nov 2017 23:54:00 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 561EF240EE for ; Thu, 9 Nov 2017 23:54:00 +0000 (UTC) Date: Thu, 9 Nov 2017 23:54:00 +0000 (UTC) From: "Vineet Garg (JIRA)" To: issues@hive.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (HIVE-18008) Add optimization rule to remove gby from right side of left semi-join MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Thu, 09 Nov 2017 23:54:05 -0000 [ https://issues.apache.org/jira/browse/HIVE-18008?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-18008: ------------------------------- Status: Patch Available (was: Open) > Add optimization rule to remove gby from right side of left semi-join > --------------------------------------------------------------------- > > Key: HIVE-18008 > URL: https://issues.apache.org/jira/browse/HIVE-18008 > Project: Hive > Issue Type: Improvement > Components: Query Planning > Reporter: Vineet Garg > Assignee: Vineet Garg > Attachments: HIVE-18008.1.patch, HIVE-18008.2.patch > > > Group by (on same keys as semi join) as right side of Left semi join is unnecessary and could be removed. We see this pattern in subqueries with explicit distinct keyword e.g. > {code:sql} > explain select * from src b where b.key in (select distinct key from src a where a.value = b.value) > {code} -- This message was sent by Atlassian JIRA (v6.4.14#64029)