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 9CD2718967 for ; Thu, 24 Sep 2015 02:19:55 +0000 (UTC) Received: (qmail 26859 invoked by uid 500); 24 Sep 2015 02:19:52 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 26787 invoked by uid 500); 24 Sep 2015 02:19:52 -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 26774 invoked by uid 99); 24 Sep 2015 02:19:52 -0000 Received: from Unknown (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 24 Sep 2015 02:19:52 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 31D3B1A7D26 for ; Thu, 24 Sep 2015 02:19:52 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 3.248 X-Spam-Level: *** X-Spam-Status: No, score=3.248 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_ENVFROM_END_DIGIT=0.25, FROM_EXCESS_BASE64=0.105, HTML_MESSAGE=3, RP_MATCHES_RCVD=-0.006, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=qq.com Received: from mx1-us-west.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id njXFHNuyhAdP for ; Thu, 24 Sep 2015 02:19:40 +0000 (UTC) Received: from smtpbg333.qq.com (smtpbg333.qq.com [14.17.43.228]) by mx1-us-west.apache.org (ASF Mail Server at mx1-us-west.apache.org) with ESMTPS id 80F7E23075 for ; Thu, 24 Sep 2015 02:19:38 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=qq.com; s=s201307; t=1443061149; bh=2wDErWT0ba77JTWad96iaE72DxIqh72ThVGRcgKZOrU=; h=From:To:Subject:Mime-Version:Content-Type:Content-Transfer-Encoding:Date:Message-ID; b=gTyo7g9DAiqTdxph0Eafs6zDTHqtk1iptEJ85Q08ZusrZfQHw0Idq+T16GXnfnWle diswC8QeA61l95qeLVBZ/3gkZZWJ96xPSMVcIkFWit24SiUTTSMjfsFU3QWjVeCxta jXhW3GIapVIBANhl17GUjbmMyqmBwrna/Pz/dqJA= X-QQ-FEAT: 2G5YO/TUUeyaX5rUEYlTvhMtN1tz/BveGexHp8C+2TFhtyrsmGGHkOR05MQri vBtCiimCO0053rc2pNhWmZK2LtT9U3MiI22MD3H3SL978zAG7s6eNIWbnoyb18AfC6eLqm1 0lYNVN1zepj6+qmMawN2TSm168MqDIlxABZdU314Kc5fagsrnEnr8qU5obeeHOgWdrZruDL ybdcppSWOGo7G3QwD4ThGOlGbhlp6JNuMFszAQ5K79g== X-QQ-SSF: 0000000000000030000000000000007 X-HAS-ATTACH: no X-QQ-BUSINESS-ORIGIN: 2 X-Originating-IP: 192.154.119.203 X-QQ-STYLE: X-QQ-mid: webmail452t1443061149t8000217 From: "=?ISO-8859-1?B?aWNlYmVyZw==?=" To: "=?ISO-8859-1?B?dXNlcg==?=" Subject: Some Join sql cannot get result in hive-1.2.1 and hive-1.1.1 Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_56035D9C_08E31C58_3761B3AB" Content-Transfer-Encoding: 8Bit Date: Thu, 24 Sep 2015 10:19:08 +0800 X-Priority: 3 Message-ID: X-QQ-MIME: TCMime 1.0 by Tencent X-Mailer: QQMail 2.x X-QQ-Mailer: QQMail 2.x X-QQ-SENDSIZE: 520 X-QQ-Bgrelay: 1 This is a multi-part message in MIME format. ------=_NextPart_56035D9C_08E31C58_3761B3AB Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: base64 SGkgYWxsLCANCkFueSBvbmUgY291bGQga2luZGx5IGhlbHAgbWUgdG8gdGFrZSBhIGxvb2sg b24gdGhpcyBpc3N1ZT8NClBsZWFzZSBmaW5kIGRldGFpbHMgaW4gaHR0cHM6Ly9pc3N1ZXMu YXBhY2hlLm9yZy9qaXJhL2Jyb3dzZS9ISVZFLTExOTMxDQoNClJlY2VudGx5LCBJIGZvdW5k IGEgam9pbiBpc3N1ZSBpbiBoaXZlLTEuMi4xIGFuZCBoaXZlLTEuMS4xLg0KVGhlIGNyZWF0 ZSB0YWJsZSBzcWwgaXMgYXMgYmVsb3cuDQoNCkNSRUFURSBUQUJMRSBJRiBOT1QgRVhJU1RT IGpvaW5fY2FzZSgNCiAgICBvcmRlcmlkICBiaWdpbnQsDQogICAgdHJhZGVpdGVtaWQgYmln aW50LA0KICAgIGlkIGJpZ2ludA0KKSBST1cgRk9STUFUIERFTElNSVRFRA0KRklFTERTIFRF Uk1JTkFURUQgQlkgJywnIA0KTElORVMgVEVSTUlOQVRFRCBCWSAnXG4nDQpTVE9SRUQgQVMg VEVYVEZJTEU7DQpSdW4gdGhlIGZvbGxvd2luZyBzcWwsIGJ1dCBjYW5ub3QgZ2V0IHNlYXJj aGluZyByZXN1bHQuDQoNCnNlbGVjdCBhLmlkIGZyb20gDQooDQpzZWxlY3Qgb3JkZXJpZCBh cyBvcmRlcmlkLCBtYXgoaWQpIGFzIGlkIGZyb20gam9pbl9jYXNlIGdyb3VwIGJ5IG9yZGVy aWQNCikgYSANCmpvaW4gDQooDQpzZWxlY3QgaWQgYXMgaWQgLCBvcmRlcmlkIGFzIG9yZGVy aWQgZnJvbSBqb2luX2Nhc2UNCikgYg0Kb24gYS5pZCA9IGIuaWQgbGltaXQgMTA7DQoNClRo aXMgaXNzdWUgYWxzbyBvY2N1cnMgaW4gaGl2ZS0xLjEuMC1jZGg1LjQuNS4NCkJ1dCBpbiBh cGFjaGUgaGl2ZS0xLjAuMSB0aGUgYWJvdmUgc3FsIGNhbiByZXR1cm4gMTAgcm93cy4NCg0K QWZ0ZXIgZXhjaGFuZ2luZyB0aGUgc2VxdWVuY2Ugb2YgIm9yZGVyaWQgYXMgb3JkZXJpZCIg YW5kICJtYXgoaWQpIGFzIGlkIiwgdGhlIGZvbGxvd2luZyBzcWwgY2FuIGdldCByZXN1bHQg aW4gaGl2ZS0xLjIuMSBhbmQgaGl2ZS0xLjEuMS4NCg0Kc2VsZWN0IGEuaWQgZnJvbSANCigN CnNlbGVjdCBtYXgoaWQpIGFzIGlkLCBvcmRlcmlkIGFzIG9yZGVyaWQgZnJvbSBqb2luX2Nh c2UgZ3JvdXAgYnkgb3JkZXJpZA0KKSBhIA0Kam9pbiANCigNCnNlbGVjdCBpZCBhcyBpZCAs IG9yZGVyaWQgYXMgb3JkZXJpZCBmcm9tIGpvaW5fY2FzZQ0KKSBiDQpvbiBhLmlkID0gYi5p ZCBsaW1pdCAxMDsNCg0KQWxzbywgdGhlIGZvbGxvd2luZyBzcWwgY2FuIGdldCByZXN1bHRz IGluIGhpdmUtMS4yLjEgYW5kIGhpdmUtMS4xLjEuDQoNCnNlbGVjdCBhLmlkIGZyb20gDQoo DQpzZWxlY3Qgb3JkZXJpZCBhcyBvcmRlcmlkLCBpZCBhcyBpZCBmcm9tIGpvaW5fY2FzZSBn cm91cCBieSBvcmRlcmlkLCBpZA0KKSBhIA0Kam9pbiANCigNCnNlbGVjdCBpZCBhcyBpZCAs IG9yZGVyaWQgYXMgb3JkZXJpZCBmcm9tIGpvaW5fY2FzZQ0KKSBiDQpvbiBhLmlkID0gYi5p ZCBsaW1pdCAxMDsgDQoNClRoYW5rcy4= ------=_NextPart_56035D9C_08E31C58_3761B3AB Content-Type: text/html; charset="ISO-8859-1" Content-Transfer-Encoding: base64 SGkgYWxsLCA8YnI+QW55IG9uZSBjb3VsZCBraW5kbHkgaGVscCBtZSB0byB0YWtlIGEgbG9v ayBvbiB0aGlzIGlzc3VlPzxicj5QbGVhc2UgZmluZCBkZXRhaWxzIGluIGh0dHBzOi8vaXNz dWVzLmFwYWNoZS5vcmcvamlyYS9icm93c2UvSElWRS0xMTkzMTxicj48YnI+UmVjZW50bHks IEkgZm91bmQgYSBqb2luIGlzc3VlIGluIGhpdmUtMS4yLjEgYW5kIGhpdmUtMS4xLjEuPGJy PlRoZSBjcmVhdGUgdGFibGUgc3FsIGlzIGFzIGJlbG93Ljxicj48YnI+Q1JFQVRFIFRBQkxF IElGIE5PVCBFWElTVFMgam9pbl9jYXNlKDxicj4mbmJzcDsmbmJzcDsmbmJzcDsgb3JkZXJp ZCZuYnNwOyBiaWdpbnQsPGJyPiZuYnNwOyZuYnNwOyZuYnNwOyB0cmFkZWl0ZW1pZCBiaWdp bnQsPGJyPiZuYnNwOyZuYnNwOyZuYnNwOyBpZCBiaWdpbnQ8YnI+KSBST1cgRk9STUFUIERF TElNSVRFRDxicj5GSUVMRFMgVEVSTUlOQVRFRCBCWSAnLCcgPGJyPkxJTkVTIFRFUk1JTkFU RUQgQlkgJ1xuJzxicj5TVE9SRUQgQVMgVEVYVEZJTEU7PGJyPlJ1biB0aGUgZm9sbG93aW5n IHNxbCwgYnV0IGNhbm5vdCBnZXQgc2VhcmNoaW5nIHJlc3VsdC48YnI+PGJyPnNlbGVjdCBh LmlkIGZyb20gPGJyPig8YnI+c2VsZWN0IG9yZGVyaWQgYXMgb3JkZXJpZCwgbWF4KGlkKSBh cyBpZCBmcm9tIGpvaW5fY2FzZSBncm91cCBieSBvcmRlcmlkPGJyPikgYSA8YnI+am9pbiA8 YnI+KDxicj5zZWxlY3QgaWQgYXMgaWQgLCBvcmRlcmlkIGFzIG9yZGVyaWQgZnJvbSBqb2lu X2Nhc2U8YnI+KSBiPGJyPm9uIGEuaWQgPSBiLmlkIGxpbWl0IDEwOzxicj48YnI+VGhpcyBp c3N1ZSBhbHNvIG9jY3VycyBpbiBoaXZlLTEuMS4wLWNkaDUuNC41Ljxicj5CdXQgaW4gYXBh Y2hlIGhpdmUtMS4wLjEgdGhlIGFib3ZlIHNxbCBjYW4gcmV0dXJuIDEwIHJvd3MuPGJyPjxi cj5BZnRlciBleGNoYW5naW5nIHRoZSBzZXF1ZW5jZSBvZiAib3JkZXJpZCBhcyBvcmRlcmlk IiBhbmQgIm1heChpZCkgYXMgaWQiLCB0aGUgZm9sbG93aW5nIHNxbCBjYW4gZ2V0IHJlc3Vs dCBpbiBoaXZlLTEuMi4xIGFuZCBoaXZlLTEuMS4xLjxicj48YnI+c2VsZWN0IGEuaWQgZnJv bSA8YnI+KDxicj5zZWxlY3QgbWF4KGlkKSBhcyBpZCwgb3JkZXJpZCBhcyBvcmRlcmlkIGZy b20gam9pbl9jYXNlIGdyb3VwIGJ5IG9yZGVyaWQ8YnI+KSBhIDxicj5qb2luIDxicj4oPGJy PnNlbGVjdCBpZCBhcyBpZCAsIG9yZGVyaWQgYXMgb3JkZXJpZCBmcm9tIGpvaW5fY2FzZTxi cj4pIGI8YnI+b24gYS5pZCA9IGIuaWQgbGltaXQgMTA7PGJyPjxicj5BbHNvLCB0aGUgZm9s bG93aW5nIHNxbCBjYW4gZ2V0IHJlc3VsdHMgaW4gaGl2ZS0xLjIuMSBhbmQgaGl2ZS0xLjEu MS48YnI+PGJyPnNlbGVjdCBhLmlkIGZyb20gPGJyPig8YnI+c2VsZWN0IG9yZGVyaWQgYXMg b3JkZXJpZCwgaWQgYXMgaWQgZnJvbSBqb2luX2Nhc2UgZ3JvdXAgYnkgb3JkZXJpZCwgaWQ8 YnI+KSBhIDxicj5qb2luIDxicj4oPGJyPnNlbGVjdCBpZCBhcyBpZCAsIG9yZGVyaWQgYXMg b3JkZXJpZCBmcm9tIGpvaW5fY2FzZTxicj4pIGI8YnI+b24gYS5pZCA9IGIuaWQgbGltaXQg MTA7IDxicj48YnI+VGhhbmtzLjxicj48YnI+ ------=_NextPart_56035D9C_08E31C58_3761B3AB--