Return-Path: 
 <dev-return-126107-apmail-hive-dev-archive=hive.apache.org@hive.apache.org>
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 F3AF11025A
	for <apmail-hive-dev-archive@www.apache.org>;
 Mon,  9 Feb 2015 18:14:35 +0000 (UTC)
Received: (qmail 26020 invoked by uid 500); 9 Feb 2015 18:14:35 -0000
Delivered-To: apmail-hive-dev-archive@hive.apache.org
Received: (qmail 25946 invoked by uid 500); 9 Feb 2015 18:14:35 -0000
Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@hive.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@hive.apache.org>
List-Post: <mailto:dev@hive.apache.org>
List-Id: <dev.hive.apache.org>
Reply-To: dev@hive.apache.org
Delivered-To: mailing list dev@hive.apache.org
Received: (qmail 25909 invoked by uid 500); 9 Feb 2015 18:14:35 -0000
Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org
Received: (qmail 25900 invoked by uid 99); 9 Feb 2015 18:14:35 -0000
Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 09 Feb 2015 18:14:35 +0000
Date: Mon, 9 Feb 2015 18:14:35 +0000 (UTC)
From: "Ashutosh Chauhan (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <JIRA.12595709.1340540679000.301999.1423505675108@Atlassian.JIRA>
In-Reply-To: <JIRA.12595709.1340540679000@Atlassian.JIRA>
References: <JIRA.12595709.1340540679000@Atlassian.JIRA>
 <JIRA.12595709.1340540679855@arcas>
Subject: [jira] [Resolved] (HIVE-3185) allow union set operation without ALL
 keyword (align to ISO-SQL 2011 specification)
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-3185?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ashutosh Chauhan resolved HIVE-3185.
------------------------------------
       Resolution: Duplicate
    Fix Version/s: 1.2.0
         Assignee: Pengcheng Xiong

> allow union set operation without ALL keyword (align to ISO-SQL 2011 specification)
> -----------------------------------------------------------------------------------
>
>                 Key: HIVE-3185
>                 URL: https://issues.apache.org/jira/browse/HIVE-3185
>             Project: Hive
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 0.8.0
>            Reporter: N Campbell
>            Assignee: Pengcheng Xiong
>             Fix For: 1.2.0
>
>
> Allow a union operation to be specified as <qb1> union <qb2> in addition to th <qb1> union all <qb2>
> Common requirement of queries to project two sets where it is not always the case you want distinct rows in the set. Failing to do so obviously will result in the current exception:
> mismatched input 'select' expecting ALL near 'union' in query operator



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)