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 B4EF217E24 for ; Thu, 19 Nov 2015 18:18:11 +0000 (UTC) Received: (qmail 98225 invoked by uid 500); 19 Nov 2015 18:18:11 -0000 Delivered-To: apmail-hive-issues-archive@hive.apache.org Received: (qmail 98162 invoked by uid 500); 19 Nov 2015 18:18:11 -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 97967 invoked by uid 99); 19 Nov 2015 18:18:11 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 19 Nov 2015 18:18:11 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id 3791D2C1F73 for ; Thu, 19 Nov 2015 18:18:11 +0000 (UTC) Date: Thu, 19 Nov 2015 18:18:11 +0000 (UTC) From: "Ashutosh Chauhan (JIRA)" To: issues@hive.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (HIVE-12017) Do not disable CBO by default when number of joins in a query is equal or less than 1 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-12017?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15014074#comment-15014074 ] Ashutosh Chauhan commented on HIVE-12017: ----------------------------------------- HIVE-12465 is important one. Lets continue it there. Good that after this patch goes in, we will be doing right thing in default config atleast. We need to fix it regardless, though. Joining on different key types is rare enough that we can take that up later. We might get that for free in return path anyway. Rest of changes LGTM. +1 pending QA run. > Do not disable CBO by default when number of joins in a query is equal or less than 1 > ------------------------------------------------------------------------------------- > > Key: HIVE-12017 > URL: https://issues.apache.org/jira/browse/HIVE-12017 > Project: Hive > Issue Type: Improvement > Components: CBO > Affects Versions: 2.0.0 > Reporter: Jesus Camacho Rodriguez > Assignee: Jesus Camacho Rodriguez > Attachments: HIVE-12017.01.patch, HIVE-12017.02.patch, HIVE-12017.03.patch, HIVE-12017.04.patch, HIVE-12017.05.patch, HIVE-12017.06.patch, HIVE-12017.07.patch, HIVE-12017.08.patch, HIVE-12017.09.patch, HIVE-12017.10.patch, HIVE-12017.11.patch, HIVE-12017.12.patch, HIVE-12017.13.patch > > > Instead, we could disable some parts of CBO that are not relevant if the query contains 1 or 0 joins. Implementation should be able to define easily other query patterns for which we might disable some parts of CBO (in case we want to do it in the future). -- This message was sent by Atlassian JIRA (v6.3.4#6332)