Return-Path: X-Original-To: apmail-hive-dev-archive@www.apache.org Delivered-To: apmail-hive-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 6C2D910A64 for ; Mon, 19 Jan 2015 21:47:33 +0000 (UTC) Received: (qmail 65546 invoked by uid 500); 19 Jan 2015 21:47:35 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 65472 invoked by uid 500); 19 Jan 2015 21:47:35 -0000 Mailing-List: contact dev-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 dev@hive.apache.org Received: (qmail 65460 invoked by uid 500); 19 Jan 2015 21:47:35 -0000 Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org Received: (qmail 65457 invoked by uid 99); 19 Jan 2015 21:47:35 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 19 Jan 2015 21:47:35 +0000 Date: Mon, 19 Jan 2015 21:47:35 +0000 (UTC) From: "Pengcheng Xiong (JIRA)" To: hive-dev@hadoop.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (HIVE-9039) Support Union Distinct 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-9039?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14283055#comment-14283055 ] Pengcheng Xiong commented on HIVE-9039: --------------------------------------- [~jpullokkaran], 2 out of 4 failures testCliDriver_groupby_grouping_window and TestMTQueries.testMTQueries1 also fails in the next test in QA, thus, it is not related. The "org.apache.hive.hcatalog.hbase.TestPigHBaseStorageHandler.org.apache.hive.hcatalog.hbase.TestPigHBaseStorageHandler " query failure seems unrelated. Thus, it is ready to go. Thanks. > Support Union Distinct > ---------------------- > > Key: HIVE-9039 > URL: https://issues.apache.org/jira/browse/HIVE-9039 > Project: Hive > Issue Type: New Feature > Reporter: Pengcheng Xiong > Assignee: Pengcheng Xiong > Attachments: HIVE-9039.01.patch, HIVE-9039.02.patch, HIVE-9039.03.patch, HIVE-9039.04.patch, HIVE-9039.05.patch, HIVE-9039.06.patch, HIVE-9039.07.patch, HIVE-9039.08.patch, HIVE-9039.09.patch, HIVE-9039.10.patch, HIVE-9039.11.patch, HIVE-9039.12.patch, HIVE-9039.13.patch, HIVE-9039.14.patch, HIVE-9039.15.patch, HIVE-9039.16.patch, HIVE-9039.17.patch, HIVE-9039.18.patch, HIVE-9039.19.patch > > > Current version (Hive 0.14) does not support union (or union distinct). It only supports union all. In this patch, we try to add this new feature by rewriting union distinct to union all followed by group by. -- This message was sent by Atlassian JIRA (v6.3.4#6332)