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 139EE18AAB for ; Fri, 6 Nov 2015 21:15:34 +0000 (UTC) Received: (qmail 86251 invoked by uid 500); 6 Nov 2015 21:15:31 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 86170 invoked by uid 500); 6 Nov 2015 21:15:31 -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 86160 invoked by uid 99); 6 Nov 2015 21:15:31 -0000 Received: from Unknown (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 06 Nov 2015 21:15:31 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 58E04C4F53 for ; Fri, 6 Nov 2015 21:15:31 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.998 X-Spam-Level: ** X-Spam-Status: No, score=2.998 tagged_above=-999 required=6.31 tests=[HTML_MESSAGE=3, RCVD_IN_MSPIKE_H2=-0.001, SPF_HELO_PASS=-0.001] autolearn=disabled Received: from mx1-us-west.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id q4Etcu32_Pvn for ; Fri, 6 Nov 2015 21:15:30 +0000 (UTC) Received: from na01-bn1-obe.outbound.protection.outlook.com (mail-bn1bon0146.outbound.protection.outlook.com [157.56.111.146]) by mx1-us-west.apache.org (ASF Mail Server at mx1-us-west.apache.org) with ESMTPS id 2DB3120753 for ; Fri, 6 Nov 2015 21:15:30 +0000 (UTC) Received: from BY2PR12MB0600.namprd12.prod.outlook.com (10.163.113.139) by BY2PR12MB0598.namprd12.prod.outlook.com (10.163.113.12) with Microsoft SMTP Server (TLS) id 15.1.312.18; Fri, 6 Nov 2015 21:15:27 +0000 Received: from BY2PR12MB0600.namprd12.prod.outlook.com ([10.163.113.139]) by BY2PR12MB0600.namprd12.prod.outlook.com ([10.163.113.139]) with mapi id 15.01.0318.003; Fri, 6 Nov 2015 21:15:27 +0000 From: Rory Sawyer To: "user@hive.apache.org" Subject: Cross join/cartesian product explanation Thread-Topic: Cross join/cartesian product explanation Thread-Index: AQHRGNhCTWFVgN9150ObkbmcBDEtUg== Date: Fri, 6 Nov 2015 21:15:27 +0000 Message-ID: <930ED234-3293-45C5-BEF6-EB5AEDA7E90A@mediamath.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: spf=none (sender IP is ) smtp.mailfrom=rsawyer@mediamath.com; x-ms-exchange-messagesentrepresentingtype: 1 x-originating-ip: [172.85.47.138] x-microsoft-exchange-diagnostics: 1;BY2PR12MB0598;5:DPg38OuQ9KXxYnX7JPVn65tu9LjiowtPvn2dKjza8VLg0pvrIQ9IU7Jr1FJju0G+wR79UctFC9nDEjt3Toc+IXh33AhCE4/8/7IIy1O6q5AjYEdisgJkrmNAFs7Zx/tHmFIEZab1XMdemOkHUUkHTQ==;24:abkPhfiyaghKsroamDRJMxN0cBUQShyLo0UF0hnd6ZOkfs9L85VQ/efO3hOj9kVFab4yJabCWXEeWjj+5gpWgxWv5JxNTy5ZPTL+rmDYA7k=;20:PFt9N+W8AZxfdGzLm8R9c/u6qXCLQJHAv0Y5oIn5kY/wmRLVSnZMxLGRxl8xK7fipFg7WE/ihVOcAQTm1qXbNw== x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:BY2PR12MB0598; x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:; x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(601004)(2401047)(5005006)(520078)(8121501046)(10201501046)(3002001);SRVR:BY2PR12MB0598;BCL:0;PCL:0;RULEID:;SRVR:BY2PR12MB0598; x-forefront-prvs: 07521929C1 x-forefront-antispam-report: SFV:NSPM;SFS:(10019020)(6009001)(189002)(53754006)(199003)(81156007)(105586002)(5007970100001)(106356001)(122556002)(102836002)(107886002)(101416001)(77096005)(16236675004)(2900100001)(2501003)(97736004)(82746002)(83716003)(5008740100001)(66066001)(11100500001)(110136002)(5001960100002)(189998001)(86362001)(106116001)(54356999)(50986999)(87936001)(36756003)(5002640100001)(5004730100002)(10400500002)(99286002)(450100001)(2351001)(92566002)(40100003)(229853001)(33656002)(104396002);DIR:OUT;SFP:1102;SCL:1;SRVR:BY2PR12MB0598;H:BY2PR12MB0600.namprd12.prod.outlook.com;FPR:;SPF:None;PTR:InfoNoRecords;MX:1;A:1;LANG:en; received-spf: None (protection.outlook.com: mediamath.com does not designate permitted sender hosts) spamdiagnosticoutput: 1:23 spamdiagnosticmetadata: NSPM Content-Type: multipart/alternative; boundary="_000_930ED234329345C5BEF6EB5AEDA7E90Amediamathcom_" MIME-Version: 1.0 X-OriginatorOrg: mediamath.com X-MS-Exchange-CrossTenant-originalarrivaltime: 06 Nov 2015 21:15:27.7498 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 85d8894b-475e-4dd5-b636-4d92f529f7aa X-MS-Exchange-Transport-CrossTenantHeadersStamped: BY2PR12MB0598 --_000_930ED234329345C5BEF6EB5AEDA7E90Amediamathcom_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 SGkgYWxsLA0KDQpPdmVyIHRoZSBsYXN0IGZldyB3ZWVrIEnigJl2ZSBiZWVuIHRyeWluZyB0byB1 c2UgY3Jvc3Mgam9pbnMvY2FydGVzaWFuIHByb2R1Y3RzIGFuZCB3YXMgd29uZGVyaW5nIHdoeSwg ZXhhY3RseSwgdGhpcyBhbGwgZ2V0cyBzZW50IHRvIG9uZSByZWR1Y2VyLiBBbGwgSeKAmXZlIGhl YXJkIG9yIHJlYWQgaXMgdGhhdCBIaXZlIGNhbuKAmXQvZG9lc27igJl0IHBhcmFsbGVsaXplIHRo ZSBqb2IuIElzIHRoZXJlIHNvbWUgY29kZSBwZW9wbGUgY2FuIHBvaW50IG1lIHRvPyBEb2VzIGFu eW9uZSBoYXZlIGEgd29ya2Fyb3VuZD8gVGhhbmtzIQ0KDQpCZXN0LA0KUm9yeSBTYXd5ZXINCg== --_000_930ED234329345C5BEF6EB5AEDA7E90Amediamathcom_ Content-Type: text/html; charset="utf-8" Content-ID: <91065A2DC5444946B2BAEF738ECCA7D3@namprd12.prod.outlook.com> Content-Transfer-Encoding: base64 PGh0bWw+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIgY29udGVudD0i dGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjwvaGVhZD4NCjxib2R5IHN0eWxlPSJ3b3JkLXdy YXA6IGJyZWFrLXdvcmQ7IC13ZWJraXQtbmJzcC1tb2RlOiBzcGFjZTsgLXdlYmtpdC1saW5lLWJy ZWFrOiBhZnRlci13aGl0ZS1zcGFjZTsgY29sb3I6IHJnYigwLCAwLCAwKTsgZm9udC1zaXplOiAx NHB4OyBmb250LWZhbWlseTogQ2FsaWJyaSwgc2Fucy1zZXJpZjsiPg0KPGRpdj5IaSBhbGwsPC9k aXY+DQo8ZGl2Pjxicj4NCjwvZGl2Pg0KPGRpdj5PdmVyIHRoZSBsYXN0IGZldyB3ZWVrIEnigJl2 ZSBiZWVuIHRyeWluZyB0byB1c2UgY3Jvc3Mgam9pbnMvY2FydGVzaWFuIHByb2R1Y3RzIGFuZCB3 YXMgd29uZGVyaW5nIHdoeSwgZXhhY3RseSwgdGhpcyBhbGwgZ2V0cyBzZW50IHRvIG9uZSByZWR1 Y2VyLiBBbGwgSeKAmXZlIGhlYXJkIG9yIHJlYWQgaXMgdGhhdCBIaXZlIGNhbuKAmXQvZG9lc27i gJl0IHBhcmFsbGVsaXplIHRoZSBqb2IuIElzIHRoZXJlIHNvbWUgY29kZSBwZW9wbGUgY2FuIHBv aW50DQogbWUgdG8/IERvZXMgYW55b25lIGhhdmUgYSB3b3JrYXJvdW5kPyBUaGFua3MhPC9kaXY+ DQo8ZGl2Pjxicj4NCjwvZGl2Pg0KPGRpdj5CZXN0LDwvZGl2Pg0KPGRpdj5Sb3J5IFNhd3llcjwv ZGl2Pg0KPGRpdj4NCjxkaXYgaWQ9Ik1BQ19PVVRMT09LX1NJR05BVFVSRSI+PC9kaXY+DQo8L2Rp dj4NCjwvYm9keT4NCjwvaHRtbD4NCg== --_000_930ED234329345C5BEF6EB5AEDA7E90Amediamathcom_--