Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Mon, 6 Jan 2014 22:23:51 +0000 (UTC)
From: "Alan Gates (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <JIRA.12686201.1387831749518.50188.1389047031474@arcas>
In-Reply-To: <JIRA.12686201.1387831749518@arcas>
References: <JIRA.12686201.1387831749518@arcas>
Subject: [jira] [Commented] (HIVE-6100) Introduce basic set operations as
 UDFs
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


    [ https://issues.apache.org/jira/browse/HIVE-6100?page=3Dcom.atlassian.=
jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D13863=
506#comment-13863506 ]=20

Alan Gates commented on HIVE-6100:
----------------------------------

Ok, never mind my comments then.  It makes sense to do this in a UDF.

> Introduce basic set operations as UDFs
> --------------------------------------
>
>                 Key: HIVE-6100
>                 URL: https://issues.apache.org/jira/browse/HIVE-6100
>             Project: Hive
>          Issue Type: New Feature
>          Components: UDF
>            Reporter: Kostiantyn Kudriavtsev
>            Priority: Minor
>             Fix For: 0.13.0
>
>
> Introduce basic set operations:
> 1. Intersection: The intersection of A and B, denoted by A =E2=88=A9 B, i=
s the set of all things that are members of both A and B.
> select set_intersection(arr_a, arr_b) from dual
> 2. Union: The union of A and B, denoted by A =E2=88=AA B, is the set of a=
ll things that are members of either A or B.
> select set_union(arr_a, arr_b) from dual
> 3. Symmetric difference: the symmetric difference of two sets is the set =
of elements which are in either of the sets and not in their intersection.
> select set_symdiff(arr_a, arr_b) from dual


--
This message was sent by Atlassian JIRA
(v6.1.5#6160)