Return-Path: 
 <issues-return-6726-apmail-hive-issues-archive=hive.apache.org@hive.apache.org>
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 7D09F173BC
	for <apmail-hive-issues-archive@minotaur.apache.org>;
 Tue,  5 May 2015 01:11:06 +0000 (UTC)
Received: (qmail 4000 invoked by uid 500); 5 May 2015 01:11:06 -0000
Delivered-To: apmail-hive-issues-archive@hive.apache.org
Received: (qmail 3979 invoked by uid 500); 5 May 2015 01:11:06 -0000
Mailing-List: contact issues-help@hive.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:issues-help@hive.apache.org>
List-Unsubscribe: <mailto:issues-unsubscribe@hive.apache.org>
List-Post: <mailto:issues@hive.apache.org>
List-Id: <issues.hive.apache.org>
Reply-To: dev@hive.apache.org
Delivered-To: mailing list issues@hive.apache.org
Received: (qmail 3969 invoked by uid 99); 5 May 2015 01:11:06 -0000
Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 May 2015 01:11:06 +0000
Date: Tue, 5 May 2015 01:11:06 +0000 (UTC)
From: "Matt McCline (JIRA)" <jira@apache.org>
To: issues@hive.apache.org
Message-ID: <JIRA.12776591.1424477622000.77274.1430788266311@Atlassian.JIRA>
In-Reply-To: <JIRA.12776591.1424477622000@Atlassian.JIRA>
References: <JIRA.12776591.1424477622000@Atlassian.JIRA>
 <JIRA.12776591.1424477622750@arcas>
Subject: [jira] [Commented] (HIVE-9743) Incorrect result set for vectorized
 left outer join
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-9743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14527707#comment-14527707 ] 

Matt McCline commented on HIVE-9743:
------------------------------------

This patch was intended to go in February and fell between the cracks because it went into another branch.

[~vikram.dixit] it is relevant because although the new native vector map join is on by default, it can be turned off and there are cases like N-way where we haven't gone native yet.

Since Hybrid Grace was added, the change got a little more complicated (I added a common base class).

[~sushanth] Yes, it needs to go into 1.2.

> Incorrect result set for vectorized left outer join
> ---------------------------------------------------
>
>                 Key: HIVE-9743
>                 URL: https://issues.apache.org/jira/browse/HIVE-9743
>             Project: Hive
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 0.14.0
>            Reporter: N Campbell
>            Assignee: Matt McCline
>         Attachments: HIVE-9743.01.patch, HIVE-9743.02.patch, HIVE-9743.03.patch, HIVE-9743.04.patch, HIVE-9743.05.patch, HIVE-9743.06.patch
>
>
> This query is supposed to return 3 rows and will when run without Tez but returns 2 rows when run with Tez.
> select tjoin1.rnum, tjoin1.c1, tjoin1.c2, tjoin2.c2 as c2j2 from tjoin1 left outer join tjoin2 on ( tjoin1.c1 = tjoin2.c1 and tjoin1.c2 > 15 )
> tjoin1.rnum	tjoin1.c1	tjoin1.c2	c2j2
> 1	20	25	<null>
> 2	<null>	50	<null>
> instead of
> tjoin1.rnum	tjoin1.c1	tjoin1.c2	c2j2
> 0	10	15	<null>
> 1	20	25	<null>
> 2	<null>	50	<null>
> create table  if not exists TJOIN1 (RNUM int , C1 int, C2 int)
>  STORED AS orc ;
> 0|10|15
> 1|20|25
> 2|\N|50
> create table  if not exists TJOIN2 (RNUM int , C1 int, C2 char(2))
> ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' 
>  STORED AS TEXTFILE ;
> 0|10|BB
> 1|15|DD
> 2|\N|EE
> 3|10|FF



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