Return-Path: X-Original-To: apmail-hive-issues-archive@minotaur.apache.org Delivered-To: apmail-hive-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id D9AE3188DC for ; Mon, 1 Feb 2016 22:10:43 +0000 (UTC) Received: (qmail 12767 invoked by uid 500); 1 Feb 2016 22:10:40 -0000 Delivered-To: apmail-hive-issues-archive@hive.apache.org Received: (qmail 12739 invoked by uid 500); 1 Feb 2016 22:10:40 -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 12717 invoked by uid 99); 1 Feb 2016 22:10:40 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 01 Feb 2016 22:10:40 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id 7FDB02C14F7 for ; Mon, 1 Feb 2016 22:10:40 +0000 (UTC) Date: Mon, 1 Feb 2016 22:10:40 +0000 (UTC) From: "Ashutosh Chauhan (JIRA)" To: issues@hive.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (HIVE-12543) Disable Hive ConstantPropagate optimizer when CBO has optimized the plan 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/HIVE-12543?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15127143#comment-15127143 ] Ashutosh Chauhan commented on HIVE-12543: ----------------------------------------- I think join merging needs to happen for such cases, as it could be substantial perf regression wherever its applicable. For constant propagation, I think existing plan is better than new one, since atleast one operator is not doing additional column processing at run time. But it may be ok to tackle this later. For DPP, this could add quite a bit latency, this needs to be looked into. So, I think join merging & DPP needs to be looked immediately, its ok to do it in follow-up. Constant propagation would be good to have as well, but can be deferred for later. > Disable Hive ConstantPropagate optimizer when CBO has optimized the plan > ------------------------------------------------------------------------ > > Key: HIVE-12543 > URL: https://issues.apache.org/jira/browse/HIVE-12543 > Project: Hive > Issue Type: Sub-task > Components: CBO, Logical Optimizer > Affects Versions: 2.0.0 > Reporter: Jesus Camacho Rodriguez > Assignee: Jesus Camacho Rodriguez > Attachments: HIVE-12543.01.patch, HIVE-12543.02.patch, HIVE-12543.03.patch, HIVE-12543.04.patch, HIVE-12543.05.patch, HIVE-12543.patch > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)