Return-Path: 
 <dev-return-129856-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 AD8DC18AC3
	for <apmail-hive-dev-archive@www.apache.org>;
 Thu, 21 May 2015 07:30:00 +0000 (UTC)
Received: (qmail 73935 invoked by uid 500); 21 May 2015 07:30:00 -0000
Delivered-To: apmail-hive-dev-archive@hive.apache.org
Received: (qmail 73859 invoked by uid 500); 21 May 2015 07:30:00 -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 73847 invoked by uid 99); 21 May 2015 07:30:00 -0000
Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 21 May 2015 07:30:00 +0000
Date: Thu, 21 May 2015 07:30:00 +0000 (UTC)
From: "sanjiv singh (JIRA)" <jira@apache.org>
To: dev@hive.apache.org
Message-ID: <JIRA.12831640.1432193381000.178116.1432193400132@Atlassian.JIRA>
In-Reply-To: <JIRA.12831640.1432193381000@Atlassian.JIRA>
References: <JIRA.12831640.1432193381000@Atlassian.JIRA>
 <JIRA.12831640.1432193381934@arcas>
Subject: [jira] [Created] (HIVE-10783) Support MINUS set operation
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394

sanjiv singh created HIVE-10783:
-----------------------------------

             Summary: Support MINUS set operation 
                 Key: HIVE-10783
                 URL: https://issues.apache.org/jira/browse/HIVE-10783
             Project: Hive
          Issue Type: Improvement
          Components: SQL
            Reporter: sanjiv singh


Support a MINUS operation  as <qb1> MINUS <qb2> .


Common requirement of queries to project two sets where you want result set which contains only unique rows returned by the first query but not by the second.


The following sample statement combines results with the MINUS operator, which returns only unique rows returned by the first query but not by the second:

SELECT * FROM tableA
MINUS
SELECT * FROM tableB;

current exception:
FAILED: ParseException line *:** missing EOF at 'SELECT' near 'MINUS'



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