Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 16B4518233 for ; Tue, 1 Mar 2016 18:57:30 +0000 (UTC) Received: (qmail 62205 invoked by uid 500); 1 Mar 2016 18:57:22 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 62129 invoked by uid 500); 1 Mar 2016 18:57:22 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 62114 invoked by uid 99); 1 Mar 2016 18:57:22 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 01 Mar 2016 18:57:22 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id C84781804F9 for ; Tue, 1 Mar 2016 18:57:21 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.998 X-Spam-Level: * X-Spam-Status: No, score=1.998 tagged_above=-999 required=6.31 tests=[FSL_HELO_BARE_IP_2=1.499, KAM_LINEPADDING=1.2, RCVD_IN_DNSWL_LOW=-0.7, SPF_PASS=-0.001] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id K0mLkwrZu12H for ; Tue, 1 Mar 2016 18:57:20 +0000 (UTC) Received: from relayvx12c.securemail.intermedia.net (relayvx12c.securemail.intermedia.net [64.78.52.187]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id B40775FBC0 for ; Tue, 1 Mar 2016 18:49:54 +0000 (UTC) Received: from securemail.intermedia.net (localhost [127.0.0.1]) (using TLSv1 with cipher AES256-SHA (256/256 bits)) (No client certificate requested) by emg-ca-1-2.localdomain (Postfix) with ESMTPS id BC7CD53E87; Tue, 1 Mar 2016 10:41:55 -0800 (PST) Subject: Re: Wrong column is picked in HIVE 2.0.0 + TEZ 0.8.2 left join MIME-Version: 1.0 x-echoworx-msg-id: bf6778bc-ef05-4e1a-8fdd-61ef1708ff78 x-echoworx-emg-received: Tue, 1 Mar 2016 10:41:55.705 -0800 x-echoworx-message-code-hashed: 01a364442498405b513c69e9cf7905b81f6c01552fc6650d5abb32e7a2177c25 x-echoworx-action: delivered Received: from 10.254.155.17 ([10.254.155.17]) by emg-ca-1-2 (JAMES SMTP Server 2.3.2) with SMTP ID 572; Tue, 1 Mar 2016 10:41:55 -0800 (PST) Received: from MBX080-W4-CO-2.exch080.serverpod.net (unknown [10.224.117.102]) (using TLSv1 with cipher AES256-SHA (256/256 bits)) (No client certificate requested) by emg-ca-1-2.localdomain (Postfix) with ESMTPS id 8320353E82; Tue, 1 Mar 2016 10:41:55 -0800 (PST) Received: from MBX080-W4-CO-1.exch080.serverpod.net (10.224.117.101) by MBX080-W4-CO-2.exch080.serverpod.net (10.224.117.102) with Microsoft SMTP Server (TLS) id 15.0.1130.7; Tue, 1 Mar 2016 10:41:45 -0800 Received: from MBX080-W4-CO-1.exch080.serverpod.net ([10.224.117.101]) by mbx080-w4-co-1.exch080.serverpod.net ([10.224.117.101]) with mapi id 15.00.1130.005; Tue, 1 Mar 2016 10:41:45 -0800 From: Sergey Shelukhin To: "user@hive.apache.org" CC: GAO Chi Thread-Topic: Wrong column is picked in HIVE 2.0.0 + TEZ 0.8.2 left join Thread-Index: AQHRc+gZxznXra6Qu0qJr1tPYV7DQ59E7C+A Date: Tue, 1 Mar 2016 18:41:44 +0000 Message-ID: References: <061b01d17372$310a9c60$931fd520$@microfun.com> <063e01d1737b$8ff477b0$afdd6710$@microfun.com> <065701d173db$36caafa0$a4600ee0$@microfun.com> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [73.53.28.216] x-source-routing-agent: Processed Content-Type: text/plain; charset="utf-8" Content-ID: <619FE2BAADC58A4EB405B54FB6FE4AE0@exch080.serverpod.net> Content-Transfer-Encoding: base64 Q2FuIHlvdSBwbGVhc2Ugb3BlbiBhIEhpdmUgSklSQT8gSXQgaXMgYSBidWcuDQoNCk9uIDE2LzMv MSwgMTA6MjgsICJHb3BhbCBWaWpheWFyYWdoYXZhbiIgPGdvcGFsdkBhcGFjaGUub3JnPiB3cm90 ZToNCg0KPihCY2M6IFRleiwgQ3Jvc3MtcG9zdCB0byBoaXZlKQ0KPg0KPj4gSSBhZGRlZCDCs3Nl dCBoaXZlLmV4ZWN1dGlvbi5lbmdpbmU9bXI7wrIgYXQgdG9wIG9mIHRoZSBzY3JpcHQsIHNlZW1z IHRoZQ0KPj5yZXN1bHQgaXMgY29ycmVjdMWgDQo+DQo+UHJldHR5IHN1cmUgaXQncyBkdWUgdG8g dGhlIHNhbWUgdGFibGUgYWxpYXNlcyBmb3IgYm90aCBkdW1teSB0YWJsZXMNCj4odGhleSdyZSBi b3RoIGNhbGxlZCBfZHVtbXlfdGFibGUpIGF1dG8gam9pbiBjb252ZXJzaW9uLg0KPg0KPmhpdmU+ IHNldCBoaXZlLmF1dG8uY29udmVydC5qb2luPWZhbHNlOw0KPg0KPg0KPlNob3VsZCBnbyBiYWNr IHRvIHVzaW5nIHNsb3dlciB0YWdnZWQgam9pbnMgZXZlbiBpbiBUZXosIHdoaWNoIHdpbGwgYWRk IGENCj50YWJsZS10YWcgaS5lIGZpcnN0IHRhYmxlIHdpbGwgYmUgKDx0YWJsZS1rZXk+LCAwKSBh bWQgMm5kIHRhYmxlIHdpbGwgYmUNCj4oPHRhYmxlLWtleT4sIDEpLg0KPg0KPkkgc3VzcGVjdCB0 aGUgZGlmZmVyZW5jZSBiZXR3ZWVuIHRoZSBNUiBhbmQgVGV6IHJ1bnMgYXJlIGxvb2t1cCBiZXR3 ZWVuDQo+dGhlIHRhYmxlLW5hbWUgKyBleHByIChib3RoIGVxdWFsIGZvciBfZHVtbXlfdGFibGUu MTEpLg0KPg0KPj4gcGVyIEplZmYgWmhhbmcncyB0aGlua2luZyBpZiB5b3Ugd2VyZSB0byBzZXQg dGhlIGV4ZWMgZW5naW5lIHRvICdtcicNCj4+d291bGQgaXQgc3RpbGwgZmFpbD8gICBpZiBzbywg dGhlbiBpdHMgbm90IFRleiAuIDopDQo+DQo+SGl2ZSBoYXMgYSBhIHdob2xlIHNldCBvZiBqb2lu IGFsZ29yaXRobXMgd2hpY2ggY2FuIG9ubHkgd29yayBvbiBUZXosIHNvDQo+aXQncyBub3QgYWx3 YXlzIHRoYXQgZWFzeS4NCj4NCj5Db25zaWRlcmluZyB0aGlzIGlzIG9uIGhpdmUtMi4wLjAsIEkg cmVjb21tZW5kIGZpbGluZyBhIEpJUkEgb24gMi4wLjAgYW5kDQo+bWFya2luZyBpdCB3aXRoIDIu MC4xIGFzIGEgdGFyZ2V0IHZlcnNpb24uDQo+DQo+Q2hlZXJzLA0KPkdvcGFsDQo+DQo+DQo+DQo+ DQo+IA0KPg0KPg0KPg0KPg0KPg0KPg0KPg0KPg0KPiANCj4NCj4NCj4NCg0K