ser@hive.apache.org<mailto:user@hive.apache.org>>
Date: Wednesday, May 4, 2016 at 1:04 AM
To: "user@hive.apache.org<mailto:user@hive.apache.org>"
<user@hive.apache.org<mailto:user@hive.apache.org>>
Cc: Rebecca Yang <yiy...@merkleinc.com<mailto:yiy...@merkleinc.com
Hdp 2.2 also works fine.
From: Markovitz, Dudu [mailto:dmarkov...@paypal.com]
Sent: Tuesday, May 03, 2016 6:56 PM
To: user@hive.apache.org
Cc: Rebecca Yang <yiy...@merkleinc.com>
Subject: RE: multiple selects on a left join give incorrect result
There is no issue on Cloudera VM
Dudu
[cl
12:37:34 PST 2015
From source with checksum 8dfc2aac3731e4e5f0e8bd1b442be0e2
From: Frank Luo [mailto:j...@merkleinc.com]
Sent: Wednesday, May 04, 2016 1:58 AM
To: user@hive.apache.org
Cc: Rebecca Yang <yiy...@merkleinc.com>
Subject: multiple selects on a left join give incorrect result
A
All,
I have found that when doing a multiple selects on a left join, the “on” clause
seems to be ignored!!! (It is hard to believe).
Below is a very simple test case and please tell me I am crazy. I am on hdp
2.3.4.7.
CREATE TABLE T_A ( idSTRING, val STRING );
CREATE TABLE T_B ( id