Return-Path: 
 <issues-return-217-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 B403F10227
	for <apmail-hive-issues-archive@minotaur.apache.org>;
 Wed, 25 Feb 2015 01:40:04 +0000 (UTC)
Received: (qmail 19665 invoked by uid 500); 25 Feb 2015 01:40:04 -0000
Delivered-To: apmail-hive-issues-archive@hive.apache.org
Received: (qmail 19648 invoked by uid 500); 25 Feb 2015 01:40:04 -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 19636 invoked by uid 99); 25 Feb 2015 01:40:04 -0000
Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Feb 2015 01:40:04 +0000
Date: Wed, 25 Feb 2015 01:40:04 +0000 (UTC)
From: "Matt McCline (JIRA)" <jira@apache.org>
To: issues@hive.apache.org
Message-ID: <JIRA.12776591.1424477622000.7066.1424828404564@Atlassian.JIRA>
In-Reply-To: <JIRA.12776591.1424477622000@Atlassian.JIRA>
References: <JIRA.12776591.1424477622000@Atlassian.JIRA>
 <JIRA.12776591.1424477622750@arcas>
Subject: [jira] [Updated] (HIVE-9743) incorrect result set for left outer
 join when executed with tez versus mapreduce
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:all-tabpanel ]

Matt McCline updated HIVE-9743:
-------------------------------
    Attachment: HIVE-9743.01.patch

> incorrect result set for left outer join when executed with tez versus mapreduce
> --------------------------------------------------------------------------------
>
>                 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
>         Attachments: HIVE-9743.01.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)