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 3E0CD18AAB for ; Thu, 17 Dec 2015 02:32:44 +0000 (UTC) Received: (qmail 2109 invoked by uid 500); 17 Dec 2015 02:32:42 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 2030 invoked by uid 500); 17 Dec 2015 02:32:42 -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 2020 invoked by uid 99); 17 Dec 2015 02:32:42 -0000 Received: from Unknown (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 17 Dec 2015 02:32:42 +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 15C9818050E for ; Thu, 17 Dec 2015 02:32:42 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.9 X-Spam-Level: ** X-Spam-Status: No, score=2.9 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=3, SPF_HELO_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=microsoft.com Received: from mx1-eu-west.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id 5w30peufyv5T for ; Thu, 17 Dec 2015 02:32:28 +0000 (UTC) Received: from na01-bn1-obe.outbound.protection.outlook.com (mail-bn1on0141.outbound.protection.outlook.com [157.56.110.141]) by mx1-eu-west.apache.org (ASF Mail Server at mx1-eu-west.apache.org) with ESMTPS id 18614203BD for ; Thu, 17 Dec 2015 02:32:27 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=selector1; h=From:To:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=Xyx3hG7W/EXhVcXYHPxCO8HXfW3KTAgMXS13sidvFWI=; b=AnS3sOKQSdg0BOv0F51kGZad5Pq0v+vEwmVWxkKclmR4ImY0/RXDCqyrIZ0hmi2IUPhE+F7bO2ToKXpam1AB6m9HToR7rFay4LDCweWhb/MJvTShfZ2KfxLhp1yRHQOvDLUj0zXCCj9d25AFQ+fV/C6QIO4ueWNreb4VW4ddhUw= Received: from BY2PR03CA073.namprd03.prod.outlook.com (10.141.249.46) by BL2PR03MB564.namprd03.prod.outlook.com (10.141.92.156) with Microsoft SMTP Server (TLS) id 15.1.337.19; Thu, 17 Dec 2015 02:32:23 +0000 Received: from BN1BFFO11FD006.protection.gbl (2a01:111:f400:7c10::1:194) by BY2PR03CA073.outlook.office365.com (2a01:111:e400:2c5d::46) with Microsoft SMTP Server (TLS) id 15.1.355.16 via Frontend Transport; Thu, 17 Dec 2015 02:32:23 +0000 Authentication-Results: spf=pass (sender IP is 206.191.230.20) smtp.mailfrom=microsoft.com; hive.apache.org; dkim=none (message not signed) header.d=none;hive.apache.org; dmarc=pass action=none header.from=microsoft.com; Received-SPF: Pass (protection.outlook.com: domain of microsoft.com designates 206.191.230.20 as permitted sender) receiver=protection.outlook.com; client-ip=206.191.230.20; helo=064-smtp-out.microsoft.com; Received: from 064-smtp-out.microsoft.com (206.191.230.20) by BN1BFFO11FD006.mail.protection.outlook.com (10.58.144.69) with Microsoft SMTP Server (TLS) id 15.1.355.15 via Frontend Transport; Thu, 17 Dec 2015 02:32:22 +0000 Received: from HKXPR3002MB0120.064d.mgd.msft.net (141.251.56.152) by HKXPR3002MB0119.064d.mgd.msft.net (141.251.56.151) with Microsoft SMTP Server (TLS) id 15.1.361.8; Thu, 17 Dec 2015 02:32:20 +0000 Received: from HKXPR3002MB0120.064d.mgd.msft.net ([141.251.56.152]) by HKXPR3002MB0120.064d.mgd.msft.net ([141.251.56.152]) with mapi id 15.01.0361.006; Thu, 17 Dec 2015 02:32:19 +0000 From: Xiaoyong Zhu To: "user@hive.apache.org" Subject: complex join keys cannot be recognized in Hive 0.13 Thread-Topic: complex join keys cannot be recognized in Hive 0.13 Thread-Index: AdE4cZa5Yr2qt1KOQsCFyCWF8xddcg== Date: Thu, 17 Dec 2015 02:32:19 +0000 Message-ID: Accept-Language: en-US, zh-CN Content-Language: en-US X-MS-Has-Attach: yes X-MS-TNEF-Correlator: x-originating-ip: [141.251.197.68] Content-Type: multipart/mixed; boundary="_006_d1da73711bf547e4925243dd04c46564HKXPR3002MB0120064dmgdm_" MIME-Version: 1.0 X-EOPAttributedMessage: 0 X-Microsoft-Exchange-Diagnostics: 1;BN1BFFO11FD006;1:u3KqkGne4qDQEdnzPje56Dj3LAq8QQaKI8FerlhpZn19jtqLuw/8nknf/YL/viXv7uii6JoA5CM4j8b1eh0FZNciwp16DZ1AnqxkpxwC2h+WmHqTz4zTGk/Hz56LlKigmAIFPyiTkUkkRshJWkLQ8zdQ84q8I2VWjSD85fA7LiGhWkQeWiDw968EyIX0/VMOfRQ6QEO4fqKU8AsiIOvS2XEecU8mwi/u3vihF9HKGx4lBqdfEQyT3S4PaI6OaogIpjA/uxdDiWqf3r3vbjKf2YbbXQifmShUbufZJWxfmRBUyRyFyFhtwILcyPAHNVlvlNc2eDtYAXsHASozgiq41A== X-Forefront-Antispam-Report: CIP:206.191.230.20;CTRY:US;IPV:NLI;EFV:NLI;SFV:NSPM;SFS:(10019020)(2980300002)(438002)(189002)(199003)(19300405004)(86362001)(110136002)(54356999)(15975445007)(16796002)(86612001)(99936001)(87936001)(24736003)(189998001)(107886002)(5001960100002)(568964002)(81156007)(84326002)(86146001)(2900100001)(102836003)(69596002)(3846002)(790700001)(586003)(5004730100002)(300700001)(11100500001)(19580395003)(2351001)(6116002)(50986999)(108616004)(10400500002)(19625215002)(6806005)(2501003)(260700001)(229853001)(106466001)(10290500002)(5005710100001)(33646002)(4810100001)(21480400002)(450100001)(19617315012)(10090500001)(4610100001)(92566002)(512954002)(1220700001)(97736004)(66066001)(16236675004)(1096002)(5003600100002)(2476003)(5890100001)(5008740100001);DIR:OUT;SFP:1102;SCL:1;SRVR:BL2PR03MB564;H:064-smtp-out.microsoft.com;FPR:;SPF:Pass;PTR:ErrorRetry;MX:1;A:1;LANG:en; X-Microsoft-Exchange-Diagnostics: 1;BL2PR03MB564;2:M+fnU/dhMFt5D9RhQZaedXitq9jesLGcOaCMGbMspUOu8+jujp0bzzf6/a/nsS8rU3RZf/rNfvKdQ1pWO9qk+iw2K0dMGom1k0fKcDuBmaeXFmq24imNtXXHIEM6ivdyn5BM/5waxawMBNczMoTzJQ==;3:gUzlOo2xJGydmEi0/zwTumbKXnT1QbYbHvwJtVgPZ2lKDTsssVczx1CElAx8Hgf+416NANtUiVDMt/zN0N7R1ZxW0q0WqEB/0ZWNTXuC2UWJovoI80gVcG8hk0nH1AjXDfkdwe4ZLMlqTae3Oah12vvGPemNWYnOGmXjc6zteGf9fISJnYRAbxGRq6mwW9lccWuPV/406YNYxXnYSBq7RPL7RHsj7mNNhsw5objtHAFeclSlZ0z7xCIVAS4jf2nMV5QV+BkFr98arl4/305IcQ==;25:xuDIqIVGS/Ws8ntCW6c7QLeeTc3FmEms5VRHYgwh6AC62aMGMYPQhzIScl+d1/z+mVrYbG07Y8pZjqZgJcpRv1ad3HQtiddygGGPghKda75LxdioaruZmkKVtFvdadMcpmf7xxcAgdNIZ1GAgI2GC8iXicYA5BcNCAfVdRZtwge8hu+yKmmawsCsbwpCtM7zxNmzu/bBH0owCW9xy+0KdA6SzXknh66JLSUs41TXSIkCwM7P7cKv3exiRbVobsUniKV93Dtyc3Pfls26MP5mtLlZOAFLUzO7giqCXVulOxk= X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:(8251501001);SRVR:BL2PR03MB564; X-O365EOP-Header: O365_EOP: AllowList from IP - set SCL to -1 X-Microsoft-Exchange-Diagnostics: 1;BL2PR03MB564;20:I/58utUyc0QwICb7FOVtbl3huf9cni49JVR+6wMvHQ12w5uzaTUsaLSdpXtPqWwvrwOWlawv/LbeJjz3iXTiXYl/AsGGFHNml/302KJHEIMF7JECPessRHHmnXyG9S3e1F5lwtOTOqj/+OQ0DS1rTI/fobI+a/hSI9co3Kt8obW59+cQPc2xR9m+XGpUf4iOhcbZkuzoJ9qf3i8J+amaB5pueUPqQ+pD4DxzUWwQXga2ioKhfYsLzxrnaCpBKIAYVXwaiSzF8qdmzvuVZGjdGYyOa5uUKbr7fzYjK2u23sPi/2vHh/5UmiV0mcmYLP+2LhYBGhn5fsoZHer0BK0x1ZnaYWfapmFqX22d8EJB7d7Cf+SWIyDqdXhDOmE71dhz/ZGdmSlxP5Xoq+GkZxiAWbvRjtRhurkmM8LSwEs8hOpYe/CpZw+sqcpLYlqntKPaD0SYpjoCChrjtPi4kUNkWWwSx33ojYeNOXWmKIPvcHpWD6omGSkWcUbAfqfjVFp626OIMvNgAKD57bTtelZ9Q0f2drJrrySCoFfick5VcuBL8D/W74LLdJ2/NnFqIpl6ioNRZkRoaM9IDQsWDjAYh5s/oGOUMkpu8OZmAehsQRY= X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:; X-Exchange-Antispam-Report-CFA-Test: BCL:0;PCL:0;RULEID:(61425038)(601004)(2401047)(5005006)(8121501046)(520078)(10201501046)(3002001)(61426038)(61427038);SRVR:BL2PR03MB564;BCL:0;PCL:0;RULEID:;SRVR:BL2PR03MB564; X-Microsoft-Exchange-Diagnostics: 1;BL2PR03MB564;4:cK2Upi94myyJrgHhx/ZQObDfhV7nklSru4aqX893bMWeN2CXc2QkheqfQ2bt02SZ8LiE4+Nic9d91ufPAjE9yHUbpgNOLdFS7o5m0C6kpPQvNeQFPhBiTOu//xONXyYGV3DPSVsNaWzMX3wsrQmVS1v2YixmOgVlO7/fp/h0PF69VFjtNUq5I5TTEonmK/I9IehQd8uMvbQ0O4f1dJ1hLs+Gl31NPKTcPQWSCGoV1gE1ys+x4QVi6E68f3tDCI3C9QE8wiYAlI9WMiHZr+GfpRQVrtD3CxVEVn9jhri8FfHeQRawXwEbjfFZOiNFMnmmnMZOZnGnPx250yeKVYjmEUDN3WnvjvyMBUzdhElouP/bMqcDcium8DSc4nhCKiIcQrtMuxlMD92GOmovkjXQOyYgBIqCVV5ULJvy6+Nkmcc8Qvu0cJ9MzVrIn2ShEeOi X-Forefront-PRVS: 07935ACF08 X-Microsoft-Exchange-Diagnostics: =?us-ascii?Q?1;BL2PR03MB564;23:p/hnCq5mdQwP8NOrAjnRdrGWopVr3W4n1VE0Vly4S+?= =?us-ascii?Q?PnNQ6bvnCgR0Gccw9pWoBzccKaHYSNCFdTbgnNrlLGBSZ2K8jGPaalO58sW7?= =?us-ascii?Q?QuEIQ/Z4a0Axd3xVOCcNarVJfcI5qcKfW3/ASClnP36R6jLKRZ569BPXyCZM?= =?us-ascii?Q?s3FUejJkJLKTxy+YkeiR8XlF4hbtObwMshdWFxGVc8uvgo4OdzOvduIEzYnC?= =?us-ascii?Q?henw0WAZv/koa9JBdS1x9bXV7M8Dm72num+TYHrx5N8opRGfUmjse5NPvFo9?= =?us-ascii?Q?9vh1A8ZJ/WtLKbg5RsL0i9CzPYS3sgdwAC2QwdcaLrVMlvzueZ27eWDsxhOB?= =?us-ascii?Q?txW2mTzo0IFQ5jKIlUdB3/UyeFKPBFb+f3RyBIjSGNV5TJhWEhwAfSa2xcmC?= =?us-ascii?Q?ng2hTB+NzvdleQA5m31wZq7VJukW9Zy64AxVJweaPF4yXj1LZiO3mQ6Qbm7I?= =?us-ascii?Q?aGSdMnv5DAsxRICJk7VCaxQxQCxyhOLoWRX5O5k/2VEnlpLg64v51g0uouCv?= =?us-ascii?Q?i0R4LInJfxeSa/nUEmCkT3R2i+CPA/jrnEySIfG2wf4R2u6s/TI6T2khI8uO?= =?us-ascii?Q?xbw1cXr8BwwczmkJdMFTEpyqkpqeF9nYewgAXwzi6cj0UTOwwvj3wl2NhJCd?= =?us-ascii?Q?dwfJyezkgH1IjBytcSYToXE/S+eQ5ulbtS+yLjQ1/N6Tl19zVzlnyAD+dPma?= =?us-ascii?Q?cteyDEH9MUcDFtXyZsv6nKH8RRZkT792zk10PZbVLqYv5sN2oSlmeVNaNZRR?= =?us-ascii?Q?xxDLrXwZp7QnIpiM6Py22nIrlaZbgLQtpU512pdHRIQY0UCjYIDC+E6RpchN?= =?us-ascii?Q?pW/CkuknCGecL8I5BYNkSEU5p+x8mlZ8Kg/vPl56ZDIJirix3GNYER4LCyLJ?= =?us-ascii?Q?IOxOxdl4qACYGbmaqtcpmGUP6OtTz+5I+PREO25Vf0bsXJ6RtsVQUy7BMa2Q?= =?us-ascii?Q?47q8gVyeWbL13i5Co4MBzALDxLa3C3Brrn2cmzndAexuiO2IBBDDtoMAZyMH?= =?us-ascii?Q?y5zO/d8aLGvkqypOO6nXhj3XIgE+BMykEjHtouSHQXgxn8Eh23v4WNqQMjqc?= =?us-ascii?Q?PmpoJR8Ug3G8UJk68bU1iYO1XslW5GFnifskxZw6tbIq8r1mnWdpRpSiw3iW?= =?us-ascii?Q?2ZwaB9Wv8p6Fvbx0fckxccJztZ/0z35+QKwBBW2G5VdI0izQUIUA5CyjGo0/?= =?us-ascii?Q?7brp8Okf3czSE9EbvgAReQn50MU6gqiHibd0gVVIo+h/gbDQuvHhUmQYZ8Lt?= =?us-ascii?Q?/WKwn9RBiFyg82nWcDru6lkhuQQUiOz8gIvVHr3WWEr08tfmo7ZygvJfvt1b?= =?us-ascii?Q?dg7DV8RQ1DaIkowL7GSQMv2VQJJwr/W1qqqPtWE8suwVOmZtiI9W93lqBc5E?= =?us-ascii?Q?PiCI4n8ZnkaDQA3fcPmesEdcHXzuDsSC4bMVFtLk49D5QBZZm3wnFInMvjCD?= =?us-ascii?Q?OggeydxtHSxq2AvD5WMt5qOepjXflX/X26G1xf6N8LHPYoqeLs3s1YrURNCb?= =?us-ascii?Q?qzCgjYr3X9JkmacGIg4kBepEYWT+9SqY+ZwQ6ZkmF7/H9tiId3QwBZV107rH?= =?us-ascii?Q?+Txe7WfBVi4J6OKwlwH0GOCLLBF/mbUvV9KOgVTsUoUJ8CsFISfduUSzI6it?= =?us-ascii?Q?P+b3+4OGjeVVVngJ9Gaw=3D=3D?= X-Microsoft-Exchange-Diagnostics: 1;BL2PR03MB564;5:YdE02tz4GCyBl9LUlbukivftyAV/4uLBbH/CPKiN9SiFyRZF19tr/tURDPD1D2Tgt01VtwW7XQqXatuIYKrWMmH+xepsqW5/3f0UVtlzXK/vWXB7mIRn3WFluX1pVHy8Fy9RWRpA+zGoMrIy++AW/g==;24:OWKiQNITcWyhRrmbQISaOU6Ynb01rfHadCc6E6M9CRk/H2upHC9uTeZTTwpZKH/u48/McEBMIdNNwbfN2VmnhS0NEmgdvjns57bHWi+8Ibw= SpamDiagnosticOutput: 1:23 SpamDiagnosticMetadata: NSPM X-OriginatorOrg: microsoft.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 17 Dec 2015 02:32:22.0870 (UTC) X-MS-Exchange-CrossTenant-Id: 72f988bf-86f1-41af-91ab-2d7cd011db47 X-MS-Exchange-CrossTenant-OriginalAttributedTenantConnectingIp: TenantId=72f988bf-86f1-41af-91ab-2d7cd011db47;Ip=[206.191.230.20];Helo=[064-smtp-out.microsoft.com] X-MS-Exchange-CrossTenant-FromEntityHeader: HybridOnPrem X-MS-Exchange-Transport-CrossTenantHeadersStamped: BL2PR03MB564 --_006_d1da73711bf547e4925243dd04c46564HKXPR3002MB0120064dmgdm_ Content-Type: multipart/alternative; boundary="_000_d1da73711bf547e4925243dd04c46564HKXPR3002MB0120064dmgdm_" --_000_d1da73711bf547e4925243dd04c46564HKXPR3002MB0120064dmgdm_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi Experts I am using Hive 0.13 and find a potential bug. Attached "implicit join.hql"= has several join keys (for example store_sales.ss_addr_sk =3D customer_add= ress.ca_address_sk) and cannot be regonized by Hive. In such cases hive won= 't be able to optimize and can only do a cross join first which makes the j= ob runs really long. If I change the log to explicit join keys, then it wor= ks well. For the below simple query hive can regcogonize the join keys, and I think = Hive should be able to handle the complex situations such as my example, ri= ght? SELECT * FROM table1 t1, table2 t2, table3 t3 WHERE t1.id =3D t2.id AND t2.id =3D t3.id AND t1.zipcode =3D '02535'; I have opened HIVE-12700 = for this issue... Xiaoyong --_000_d1da73711bf547e4925243dd04c46564HKXPR3002MB0120064dmgdm_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi Experts

 

I am using Hive 0.13 and find a potential bug. Attac= hed “implicit join.hql” has several join keys (for example store_sales.ss_addr_sk =3D customer_address.ca_address_sk) and canno= t be regonized by Hive. In such cases hive won’t be able to optimize = and can only do a cross join first which makes the job runs really long. If= I change the log to explicit join keys, then it works well.

 

For the below simple query hive can regcogonize the = join keys, and I think Hive should be able to handle the complex situations= such as my example, right?

SELECT * 
FROM table1 t1, table2 t2, table3 t3 
WHERE t1.id =3D t2.id AND t2.id =3D t3.i= d AND t1.zipcode =3D '02535';

 

I have opened HIVE-12700 for this issue…

 

Xiaoyong

 

--_000_d1da73711bf547e4925243dd04c46564HKXPR3002MB0120064dmgdm_-- --_006_d1da73711bf547e4925243dd04c46564HKXPR3002MB0120064dmgdm_ Content-Type: application/octet-stream; name="Implicit Joins.hql" Content-Description: Implicit Joins.hql Content-Disposition: attachment; filename="Implicit Joins.hql"; size=2248; creation-date="Thu, 17 Dec 2015 02:16:37 GMT"; modification-date="Thu, 17 Dec 2015 02:16:37 GMT" Content-Transfer-Encoding: base64 dXNlIHRwY2RzX3RleHRfMjsNCnNldCBoaXZlLmV4ZWN1dGlvbi5lbmdpbmU9dGV6Ow0Kc2VsZWN0 IGF2Zyhzc19xdWFudGl0eSkNCiAgICAgICAsYXZnKHNzX2V4dF9zYWxlc19wcmljZSkNCiAgICAg ICAsYXZnKHNzX2V4dF93aG9sZXNhbGVfY29zdCkNCiAgICAgICAsc3VtKHNzX2V4dF93aG9sZXNh bGVfY29zdCkNCiBmcm9tIHN0b3JlX3NhbGVzDQogICAgICxzdG9yZQ0KICAgICAsY3VzdG9tZXJf ZGVtb2dyYXBoaWNzDQogICAgICxob3VzZWhvbGRfZGVtb2dyYXBoaWNzDQogICAgICxjdXN0b21l cl9hZGRyZXNzDQogICAgICxkYXRlX2RpbQ0KIHdoZXJlIHN0b3JlLnNfc3RvcmVfc2sgPSBzdG9y ZV9zYWxlcy5zc19zdG9yZV9zaw0KIGFuZCAgc3RvcmVfc2FsZXMuc3Nfc29sZF9kYXRlX3NrID0g ZGF0ZV9kaW0uZF9kYXRlX3NrIGFuZCBkYXRlX2RpbS5kX3llYXIgPSAyMDAxDQogYW5kKChzdG9y ZV9zYWxlcy5zc19oZGVtb19zaz1ob3VzZWhvbGRfZGVtb2dyYXBoaWNzLmhkX2RlbW9fc2sNCiAg YW5kIGN1c3RvbWVyX2RlbW9ncmFwaGljcy5jZF9kZW1vX3NrID0gc3RvcmVfc2FsZXMuc3NfY2Rl bW9fc2sNCiAgYW5kIGN1c3RvbWVyX2RlbW9ncmFwaGljcy5jZF9tYXJpdGFsX3N0YXR1cyA9ICdN Jw0KICBhbmQgY3VzdG9tZXJfZGVtb2dyYXBoaWNzLmNkX2VkdWNhdGlvbl9zdGF0dXMgPSAnNCB5 ciBEZWdyZWUnDQogIGFuZCBzdG9yZV9zYWxlcy5zc19zYWxlc19wcmljZSBiZXR3ZWVuIDEwMC4w MCBhbmQgMTUwLjAwDQogIGFuZCBob3VzZWhvbGRfZGVtb2dyYXBoaWNzLmhkX2RlcF9jb3VudCA9 IDMgICANCiAgICAgKW9yDQogICAgIChzdG9yZV9zYWxlcy5zc19oZGVtb19zaz1ob3VzZWhvbGRf ZGVtb2dyYXBoaWNzLmhkX2RlbW9fc2sNCiAgYW5kIGN1c3RvbWVyX2RlbW9ncmFwaGljcy5jZF9k ZW1vX3NrID0gc3RvcmVfc2FsZXMuc3NfY2RlbW9fc2sNCiAgYW5kIGN1c3RvbWVyX2RlbW9ncmFw aGljcy5jZF9tYXJpdGFsX3N0YXR1cyA9ICdEJw0KICBhbmQgY3VzdG9tZXJfZGVtb2dyYXBoaWNz LmNkX2VkdWNhdGlvbl9zdGF0dXMgPSAnUHJpbWFyeScNCiAgYW5kIHN0b3JlX3NhbGVzLnNzX3Nh bGVzX3ByaWNlIGJldHdlZW4gNTAuMDAgYW5kIDEwMC4wMCAgIA0KICBhbmQgaG91c2Vob2xkX2Rl bW9ncmFwaGljcy5oZF9kZXBfY291bnQgPSAxDQogICAgICkgb3IgDQogICAgIChzdG9yZV9zYWxl cy5zc19oZGVtb19zaz1ob3VzZWhvbGRfZGVtb2dyYXBoaWNzLmhkX2RlbW9fc2sNCiAgYW5kIGN1 c3RvbWVyX2RlbW9ncmFwaGljcy5jZF9kZW1vX3NrID0gc3NfY2RlbW9fc2sNCiAgYW5kIGN1c3Rv bWVyX2RlbW9ncmFwaGljcy5jZF9tYXJpdGFsX3N0YXR1cyA9ICdVJw0KICBhbmQgY3VzdG9tZXJf ZGVtb2dyYXBoaWNzLmNkX2VkdWNhdGlvbl9zdGF0dXMgPSAnQWR2YW5jZWQgRGVncmVlJw0KICBh bmQgc3RvcmVfc2FsZXMuc3Nfc2FsZXNfcHJpY2UgYmV0d2VlbiAxNTAuMDAgYW5kIDIwMC4wMCAN CiAgYW5kIGhvdXNlaG9sZF9kZW1vZ3JhcGhpY3MuaGRfZGVwX2NvdW50ID0gMSAgDQogICAgICkp DQogYW5kKChzdG9yZV9zYWxlcy5zc19hZGRyX3NrID0gY3VzdG9tZXJfYWRkcmVzcy5jYV9hZGRy ZXNzX3NrDQogIGFuZCBjdXN0b21lcl9hZGRyZXNzLmNhX2NvdW50cnkgPSAnVW5pdGVkIFN0YXRl cycNCiAgYW5kIGN1c3RvbWVyX2FkZHJlc3MuY2Ffc3RhdGUgaW4gKCdLWScsICdHQScsICdOTScp DQogIGFuZCBzdG9yZV9zYWxlcy5zc19uZXRfcHJvZml0IGJldHdlZW4gMTAwIGFuZCAyMDAgIA0K ICAgICApIG9yDQogICAgIChzdG9yZV9zYWxlcy5zc19hZGRyX3NrID0gY3VzdG9tZXJfYWRkcmVz cy5jYV9hZGRyZXNzX3NrDQogIGFuZCBjdXN0b21lcl9hZGRyZXNzLmNhX2NvdW50cnkgPSAnVW5p dGVkIFN0YXRlcycNCiAgYW5kIGN1c3RvbWVyX2FkZHJlc3MuY2Ffc3RhdGUgaW4gKCdNVCcsICdP UicsICdJTicpDQogIGFuZCBzdG9yZV9zYWxlcy5zc19uZXRfcHJvZml0IGJldHdlZW4gMTUwIGFu ZCAzMDAgIA0KICAgICApIG9yDQogICAgIChzdG9yZV9zYWxlcy5zc19hZGRyX3NrID0gY3VzdG9t ZXJfYWRkcmVzcy5jYV9hZGRyZXNzX3NrDQogIGFuZCBjdXN0b21lcl9hZGRyZXNzLmNhX2NvdW50 cnkgPSAnVW5pdGVkIFN0YXRlcycNCiAgYW5kIGN1c3RvbWVyX2FkZHJlc3MuY2Ffc3RhdGUgaW4g KCdXSScsICdNTycsICdXVicpDQogIGFuZCBzdG9yZV9zYWxlcy5zc19uZXRfcHJvZml0IGJldHdl ZW4gNTAgYW5kIDI1MCAgDQogICAgICkpOw== --_006_d1da73711bf547e4925243dd04c46564HKXPR3002MB0120064dmgdm_ Content-Type: text/plain; name="job explain plan.txt" Content-Description: job explain plan.txt Content-Disposition: attachment; filename="job explain plan.txt"; size=12042; creation-date="Thu, 17 Dec 2015 02:19:20 GMT"; modification-date="Thu, 17 Dec 2015 02:19:20 GMT" Content-Transfer-Encoding: base64 U1RBR0UgREVQRU5ERU5DSUVTOg0KICBTdGFnZS0xIGlzIGEgcm9vdCBzdGFnZQ0KICBTdGFnZS0w IGRlcGVuZHMgb24gc3RhZ2VzOiBTdGFnZS0xDQoNClNUQUdFIFBMQU5TOg0KICBTdGFnZTogU3Rh Z2UtMQ0KICAgIFRleg0KICAgICAgRWRnZXM6DQogICAgICAgIE1hcCA0IDwtIE1hcCAyIChCUk9B RENBU1RfRURHRSkNCiAgICAgICAgUmVkdWNlciA1IDwtIE1hcCAxIChCUk9BRENBU1RfRURHRSks IE1hcCAzIChCUk9BRENBU1RfRURHRSksIE1hcCA0IChTSU1QTEVfRURHRSksIE1hcCA3IChTSU1Q TEVfRURHRSksIE1hcCA4IChCUk9BRENBU1RfRURHRSkNCiAgICAgICAgUmVkdWNlciA2IDwtIFJl ZHVjZXIgNSAoU0lNUExFX0VER0UpDQogICAgICBEYWdOYW1lOiB5YXJuXzIwMTUxMjE3MDE1NjU2 XzUxODE5Mzg0LTZmM2UtNGEzNi05YzU0LTJjZmNjNWVkMWU4NzoxDQogICAgICBWZXJ0aWNlczoN CiAgICAgICAgTWFwIDEgDQogICAgICAgICAgICBNYXAgT3BlcmF0b3IgVHJlZToNCiAgICAgICAg ICAgICAgICBUYWJsZVNjYW4NCiAgICAgICAgICAgICAgICAgIGFsaWFzOiBob3VzZWhvbGRfZGVt b2dyYXBoaWNzDQogICAgICAgICAgICAgICAgICBTdGF0aXN0aWNzOiBOdW0gcm93czogMTg5NTYg RGF0YSBzaXplOiAxNTE2NTMgQmFzaWMgc3RhdHM6IENPTVBMRVRFIENvbHVtbiBzdGF0czogTk9O RQ0KICAgICAgICAgICAgICAgICAgUmVkdWNlIE91dHB1dCBPcGVyYXRvcg0KICAgICAgICAgICAg ICAgICAgICBzb3J0IG9yZGVyOiANCiAgICAgICAgICAgICAgICAgICAgU3RhdGlzdGljczogTnVt IHJvd3M6IDE4OTU2IERhdGEgc2l6ZTogMTUxNjUzIEJhc2ljIHN0YXRzOiBDT01QTEVURSBDb2x1 bW4gc3RhdHM6IE5PTkUNCiAgICAgICAgICAgICAgICAgICAgdmFsdWUgZXhwcmVzc2lvbnM6IGhk X2RlbW9fc2sgKHR5cGU6IGludCksIGhkX2RlcF9jb3VudCAodHlwZTogaW50KQ0KICAgICAgICBN YXAgMiANCiAgICAgICAgICAgIE1hcCBPcGVyYXRvciBUcmVlOg0KICAgICAgICAgICAgICAgIFRh YmxlU2Nhbg0KICAgICAgICAgICAgICAgICAgYWxpYXM6IHN0b3JlDQogICAgICAgICAgICAgICAg ICBTdGF0aXN0aWNzOiBOdW0gcm93czogMTQ3MiBEYXRhIHNpemU6IDU4ODkgQmFzaWMgc3RhdHM6 IENPTVBMRVRFIENvbHVtbiBzdGF0czogTk9ORQ0KICAgICAgICAgICAgICAgICAgRmlsdGVyIE9w ZXJhdG9yDQogICAgICAgICAgICAgICAgICAgIHByZWRpY2F0ZTogc19zdG9yZV9zayBpcyBub3Qg bnVsbCAodHlwZTogYm9vbGVhbikNCiAgICAgICAgICAgICAgICAgICAgU3RhdGlzdGljczogTnVt IHJvd3M6IDczNiBEYXRhIHNpemU6IDI5NDQgQmFzaWMgc3RhdHM6IENPTVBMRVRFIENvbHVtbiBz dGF0czogTk9ORQ0KICAgICAgICAgICAgICAgICAgICBSZWR1Y2UgT3V0cHV0IE9wZXJhdG9yDQog ICAgICAgICAgICAgICAgICAgICAga2V5IGV4cHJlc3Npb25zOiBzX3N0b3JlX3NrICh0eXBlOiBp bnQpDQogICAgICAgICAgICAgICAgICAgICAgc29ydCBvcmRlcjogKw0KICAgICAgICAgICAgICAg ICAgICAgIE1hcC1yZWR1Y2UgcGFydGl0aW9uIGNvbHVtbnM6IHNfc3RvcmVfc2sgKHR5cGU6IGlu dCkNCiAgICAgICAgICAgICAgICAgICAgICBTdGF0aXN0aWNzOiBOdW0gcm93czogNzM2IERhdGEg c2l6ZTogMjk0NCBCYXNpYyBzdGF0czogQ09NUExFVEUgQ29sdW1uIHN0YXRzOiBOT05FDQogICAg ICAgIE1hcCAzIA0KICAgICAgICAgICAgTWFwIE9wZXJhdG9yIFRyZWU6DQogICAgICAgICAgICAg ICAgVGFibGVTY2FuDQogICAgICAgICAgICAgICAgICBhbGlhczogY3VzdG9tZXJfYWRkcmVzcw0K ICAgICAgICAgICAgICAgICAgU3RhdGlzdGljczogTnVtIHJvd3M6IDM4ODc1IERhdGEgc2l6ZTog NzkzMDU5MiBCYXNpYyBzdGF0czogQ09NUExFVEUgQ29sdW1uIHN0YXRzOiBOT05FDQogICAgICAg ICAgICAgICAgICBSZWR1Y2UgT3V0cHV0IE9wZXJhdG9yDQogICAgICAgICAgICAgICAgICAgIHNv cnQgb3JkZXI6IA0KICAgICAgICAgICAgICAgICAgICBTdGF0aXN0aWNzOiBOdW0gcm93czogMzg4 NzUgRGF0YSBzaXplOiA3OTMwNTkyIEJhc2ljIHN0YXRzOiBDT01QTEVURSBDb2x1bW4gc3RhdHM6 IE5PTkUNCiAgICAgICAgICAgICAgICAgICAgdmFsdWUgZXhwcmVzc2lvbnM6IGNhX2FkZHJlc3Nf c2sgKHR5cGU6IGludCksIGNhX3N0YXRlICh0eXBlOiBzdHJpbmcpLCBjYV9jb3VudHJ5ICh0eXBl OiBzdHJpbmcpDQogICAgICAgIE1hcCA0IA0KICAgICAgICAgICAgTWFwIE9wZXJhdG9yIFRyZWU6 DQogICAgICAgICAgICAgICAgVGFibGVTY2FuDQogICAgICAgICAgICAgICAgICBhbGlhczogc3Rv cmVfc2FsZXMNCiAgICAgICAgICAgICAgICAgIFN0YXRpc3RpY3M6IE51bSByb3dzOiAxOTYwMDY2 MiBEYXRhIHNpemU6IDc4NDAyNjQ5NiBCYXNpYyBzdGF0czogQ09NUExFVEUgQ29sdW1uIHN0YXRz OiBOT05FDQogICAgICAgICAgICAgICAgICBGaWx0ZXIgT3BlcmF0b3INCiAgICAgICAgICAgICAg ICAgICAgcHJlZGljYXRlOiAoc3Nfc3RvcmVfc2sgaXMgbm90IG51bGwgYW5kIHNzX3NvbGRfZGF0 ZV9zayBpcyBub3QgbnVsbCkgKHR5cGU6IGJvb2xlYW4pDQogICAgICAgICAgICAgICAgICAgIFN0 YXRpc3RpY3M6IE51bSByb3dzOiA0OTAwMTY2IERhdGEgc2l6ZTogMTk2MDA2NjQ0IEJhc2ljIHN0 YXRzOiBDT01QTEVURSBDb2x1bW4gc3RhdHM6IE5PTkUNCiAgICAgICAgICAgICAgICAgICAgTWFw IEpvaW4gT3BlcmF0b3INCiAgICAgICAgICAgICAgICAgICAgICBjb25kaXRpb24gbWFwOg0KICAg ICAgICAgICAgICAgICAgICAgICAgICAgSW5uZXIgSm9pbiAwIHRvIDENCiAgICAgICAgICAgICAg ICAgICAgICBjb25kaXRpb24gZXhwcmVzc2lvbnM6DQogICAgICAgICAgICAgICAgICAgICAgICAw IHtzc19zb2xkX2RhdGVfc2t9IHtzc19jZGVtb19za30ge3NzX2hkZW1vX3NrfSB7c3NfYWRkcl9z a30ge3NzX3N0b3JlX3NrfSB7c3NfcXVhbnRpdHl9IHtzc19zYWxlc19wcmljZX0ge3NzX2V4dF9z YWxlc19wcmljZX0ge3NzX2V4dF93aG9sZXNhbGVfY29zdH0ge3NzX25ldF9wcm9maXR9DQogICAg ICAgICAgICAgICAgICAgICAgICAxIHtzX3N0b3JlX3NrfQ0KICAgICAgICAgICAgICAgICAgICAg IGtleXM6DQogICAgICAgICAgICAgICAgICAgICAgICAwIHNzX3N0b3JlX3NrICh0eXBlOiBpbnQp DQogICAgICAgICAgICAgICAgICAgICAgICAxIHNfc3RvcmVfc2sgKHR5cGU6IGludCkNCiAgICAg ICAgICAgICAgICAgICAgICBvdXRwdXRDb2x1bW5OYW1lczogX2NvbDAsIF9jb2w0LCBfY29sNSwg X2NvbDYsIF9jb2w3LCBfY29sMTAsIF9jb2wxMywgX2NvbDE1LCBfY29sMTYsIF9jb2wyMiwgX2Nv bDI2DQogICAgICAgICAgICAgICAgICAgICAgaW5wdXQgdmVydGljZXM6DQogICAgICAgICAgICAg ICAgICAgICAgICAxIE1hcCAyDQogICAgICAgICAgICAgICAgICAgICAgU3RhdGlzdGljczogTnVt IHJvd3M6IDUzOTAxODIgRGF0YSBzaXplOiAyMTU2MDczMTMgQmFzaWMgc3RhdHM6IENPTVBMRVRF IENvbHVtbiBzdGF0czogTk9ORQ0KICAgICAgICAgICAgICAgICAgICAgIFJlZHVjZSBPdXRwdXQg T3BlcmF0b3INCiAgICAgICAgICAgICAgICAgICAgICAgIHNvcnQgb3JkZXI6IA0KICAgICAgICAg ICAgICAgICAgICAgICAgU3RhdGlzdGljczogTnVtIHJvd3M6IDUzOTAxODIgRGF0YSBzaXplOiAy MTU2MDczMTMgQmFzaWMgc3RhdHM6IENPTVBMRVRFIENvbHVtbiBzdGF0czogTk9ORQ0KICAgICAg ICAgICAgICAgICAgICAgICAgdmFsdWUgZXhwcmVzc2lvbnM6IF9jb2wwICh0eXBlOiBpbnQpLCBf Y29sNCAodHlwZTogaW50KSwgX2NvbDUgKHR5cGU6IGludCksIF9jb2w2ICh0eXBlOiBpbnQpLCBf Y29sNyAodHlwZTogaW50KSwgX2NvbDEwICh0eXBlOiBpbnQpLCBfY29sMTMgKHR5cGU6IGZsb2F0 KSwgX2NvbDE1ICh0eXBlOiBmbG9hdCksIF9jb2wxNiAodHlwZTogZmxvYXQpLCBfY29sMjIgKHR5 cGU6IGZsb2F0KSwgX2NvbDI2ICh0eXBlOiBpbnQpDQogICAgICAgIE1hcCA3IA0KICAgICAgICAg ICAgTWFwIE9wZXJhdG9yIFRyZWU6DQogICAgICAgICAgICAgICAgVGFibGVTY2FuDQogICAgICAg ICAgICAgICAgICBhbGlhczogY3VzdG9tZXJfZGVtb2dyYXBoaWNzDQogICAgICAgICAgICAgICAg ICBTdGF0aXN0aWNzOiBOdW0gcm93czogMzk1MzkyIERhdGEgc2l6ZTogODA2NjAwOTYgQmFzaWMg c3RhdHM6IENPTVBMRVRFIENvbHVtbiBzdGF0czogTk9ORQ0KICAgICAgICAgICAgICAgICAgUmVk dWNlIE91dHB1dCBPcGVyYXRvcg0KICAgICAgICAgICAgICAgICAgICBzb3J0IG9yZGVyOiANCiAg ICAgICAgICAgICAgICAgICAgU3RhdGlzdGljczogTnVtIHJvd3M6IDM5NTM5MiBEYXRhIHNpemU6 IDgwNjYwMDk2IEJhc2ljIHN0YXRzOiBDT01QTEVURSBDb2x1bW4gc3RhdHM6IE5PTkUNCiAgICAg ICAgICAgICAgICAgICAgdmFsdWUgZXhwcmVzc2lvbnM6IGNkX2RlbW9fc2sgKHR5cGU6IGludCks IGNkX21hcml0YWxfc3RhdHVzICh0eXBlOiBzdHJpbmcpLCBjZF9lZHVjYXRpb25fc3RhdHVzICh0 eXBlOiBzdHJpbmcpDQogICAgICAgIE1hcCA4IA0KICAgICAgICAgICAgTWFwIE9wZXJhdG9yIFRy ZWU6DQogICAgICAgICAgICAgICAgVGFibGVTY2FuDQogICAgICAgICAgICAgICAgICBhbGlhczog ZGF0ZV9kaW0NCiAgICAgICAgICAgICAgICAgIFN0YXRpc3RpY3M6IE51bSByb3dzOiAxMjg5Njc5 IERhdGEgc2l6ZTogMTAzMTc0MzggQmFzaWMgc3RhdHM6IENPTVBMRVRFIENvbHVtbiBzdGF0czog Tk9ORQ0KICAgICAgICAgICAgICAgICAgRmlsdGVyIE9wZXJhdG9yDQogICAgICAgICAgICAgICAg ICAgIHByZWRpY2F0ZTogKGRfZGF0ZV9zayBpcyBub3QgbnVsbCBhbmQgKGRfeWVhciA9IDIwMDEp KSAodHlwZTogYm9vbGVhbikNCiAgICAgICAgICAgICAgICAgICAgU3RhdGlzdGljczogTnVtIHJv d3M6IDMyMjQyMCBEYXRhIHNpemU6IDI1NzkzNjEgQmFzaWMgc3RhdHM6IENPTVBMRVRFIENvbHVt biBzdGF0czogTk9ORQ0KICAgICAgICAgICAgICAgICAgICBSZWR1Y2UgT3V0cHV0IE9wZXJhdG9y DQogICAgICAgICAgICAgICAgICAgICAga2V5IGV4cHJlc3Npb25zOiBkX2RhdGVfc2sgKHR5cGU6 IGludCkNCiAgICAgICAgICAgICAgICAgICAgICBzb3J0IG9yZGVyOiArDQogICAgICAgICAgICAg ICAgICAgICAgTWFwLXJlZHVjZSBwYXJ0aXRpb24gY29sdW1uczogZF9kYXRlX3NrICh0eXBlOiBp bnQpDQogICAgICAgICAgICAgICAgICAgICAgU3RhdGlzdGljczogTnVtIHJvd3M6IDMyMjQyMCBE YXRhIHNpemU6IDI1NzkzNjEgQmFzaWMgc3RhdHM6IENPTVBMRVRFIENvbHVtbiBzdGF0czogTk9O RQ0KICAgICAgICBSZWR1Y2VyIDUgDQogICAgICAgICAgICBSZWR1Y2UgT3BlcmF0b3IgVHJlZToN CiAgICAgICAgICAgICAgTWVyZ2UgSm9pbiBPcGVyYXRvcg0KICAgICAgICAgICAgICAgIGNvbmRp dGlvbiBtYXA6DQogICAgICAgICAgICAgICAgICAgICBJbm5lciBKb2luIDAgdG8gMQ0KICAgICAg ICAgICAgICAgIGNvbmRpdGlvbiBleHByZXNzaW9uczoNCiAgICAgICAgICAgICAgICAgIDAge1ZB TFVFLl9jb2wwfSB7VkFMVUUuX2NvbDR9IHtWQUxVRS5fY29sNX0ge1ZBTFVFLl9jb2w2fSB7VkFM VUUuX2NvbDd9IHtWQUxVRS5fY29sMTB9IHtWQUxVRS5fY29sMTN9IHtWQUxVRS5fY29sMTV9IHtW QUxVRS5fY29sMTZ9IHtWQUxVRS5fY29sMjJ9IHtWQUxVRS5fY29sMjZ9DQogICAgICAgICAgICAg ICAgICAxIHtWQUxVRS5fY29sMH0ge1ZBTFVFLl9jb2wyfSB7VkFMVUUuX2NvbDN9DQogICAgICAg ICAgICAgICAgb3V0cHV0Q29sdW1uTmFtZXM6IF9jb2wwLCBfY29sNCwgX2NvbDUsIF9jb2w2LCBf Y29sNywgX2NvbDEwLCBfY29sMTMsIF9jb2wxNSwgX2NvbDE2LCBfY29sMjIsIF9jb2wyNiwgX2Nv bDU4LCBfY29sNjAsIF9jb2w2MQ0KICAgICAgICAgICAgICAgIFN0YXRpc3RpY3M6IE51bSByb3dz OiA1OTI5MjAwIERhdGEgc2l6ZTogMjM3MTY4MDQ5IEJhc2ljIHN0YXRzOiBDT01QTEVURSBDb2x1 bW4gc3RhdHM6IE5PTkUNCiAgICAgICAgICAgICAgICBNYXAgSm9pbiBPcGVyYXRvcg0KICAgICAg ICAgICAgICAgICAgY29uZGl0aW9uIG1hcDoNCiAgICAgICAgICAgICAgICAgICAgICAgSW5uZXIg Sm9pbiAwIHRvIDENCiAgICAgICAgICAgICAgICAgIGNvbmRpdGlvbiBleHByZXNzaW9uczoNCiAg ICAgICAgICAgICAgICAgICAgMCB7X2NvbDB9IHtfY29sNH0ge19jb2w1fSB7X2NvbDZ9IHtfY29s N30ge19jb2wxMH0ge19jb2wxM30ge19jb2wxNX0ge19jb2wxNn0ge19jb2wyMn0ge19jb2wyNn0g e19jb2w1OH0ge19jb2w2MH0ge19jb2w2MX0NCiAgICAgICAgICAgICAgICAgICAgMSB7aGRfZGVt b19za30ge2hkX2RlcF9jb3VudH0NCiAgICAgICAgICAgICAgICAgIGtleXM6DQogICAgICAgICAg ICAgICAgICAgIDAgDQogICAgICAgICAgICAgICAgICAgIDEgDQogICAgICAgICAgICAgICAgICBv dXRwdXRDb2x1bW5OYW1lczogX2NvbDAsIF9jb2w0LCBfY29sNSwgX2NvbDYsIF9jb2w3LCBfY29s MTAsIF9jb2wxMywgX2NvbDE1LCBfY29sMTYsIF9jb2wyMiwgX2NvbDI2LCBfY29sNTgsIF9jb2w2 MCwgX2NvbDYxLCBfY29sNzAsIF9jb2w3Mw0KICAgICAgICAgICAgICAgICAgaW5wdXQgdmVydGlj ZXM6DQogICAgICAgICAgICAgICAgICAgIDEgTWFwIDENCiAgICAgICAgICAgICAgICAgIFN0YXRp c3RpY3M6IE51bSByb3dzOiA2NTIyMTIwIERhdGEgc2l6ZTogMjYwODg0ODU5IEJhc2ljIHN0YXRz OiBDT01QTEVURSBDb2x1bW4gc3RhdHM6IE5PTkUNCiAgICAgICAgICAgICAgICAgIE1hcCBKb2lu IE9wZXJhdG9yDQogICAgICAgICAgICAgICAgICAgIGNvbmRpdGlvbiBtYXA6DQogICAgICAgICAg ICAgICAgICAgICAgICAgSW5uZXIgSm9pbiAwIHRvIDENCiAgICAgICAgICAgICAgICAgICAgY29u ZGl0aW9uIGV4cHJlc3Npb25zOg0KICAgICAgICAgICAgICAgICAgICAgIDAge19jb2wwfSB7X2Nv bDR9IHtfY29sNX0ge19jb2w2fSB7X2NvbDd9IHtfY29sMTB9IHtfY29sMTN9IHtfY29sMTV9IHtf Y29sMTZ9IHtfY29sMjJ9IHtfY29sMjZ9IHtfY29sNTh9IHtfY29sNjB9IHtfY29sNjF9IHtfY29s NzB9IHtfY29sNzN9DQogICAgICAgICAgICAgICAgICAgICAgMSB7Y2FfYWRkcmVzc19za30ge2Nh X3N0YXRlfSB7Y2FfY291bnRyeX0NCiAgICAgICAgICAgICAgICAgICAga2V5czoNCiAgICAgICAg ICAgICAgICAgICAgICAwIA0KICAgICAgICAgICAgICAgICAgICAgIDEgDQogICAgICAgICAgICAg ICAgICAgIG91dHB1dENvbHVtbk5hbWVzOiBfY29sMCwgX2NvbDQsIF9jb2w1LCBfY29sNiwgX2Nv bDcsIF9jb2wxMCwgX2NvbDEzLCBfY29sMTUsIF9jb2wxNiwgX2NvbDIyLCBfY29sMjYsIF9jb2w1 OCwgX2NvbDYwLCBfY29sNjEsIF9jb2w3MCwgX2NvbDczLCBfY29sNzgsIF9jb2w4NiwgX2NvbDg4 DQogICAgICAgICAgICAgICAgICAgIGlucHV0IHZlcnRpY2VzOg0KICAgICAgICAgICAgICAgICAg ICAgIDEgTWFwIDMNCiAgICAgICAgICAgICAgICAgICAgU3RhdGlzdGljczogTnVtIHJvd3M6IDcx NzQzMzIgRGF0YSBzaXplOiAyODY5NzMzNTEgQmFzaWMgc3RhdHM6IENPTVBMRVRFIENvbHVtbiBz dGF0czogTk9ORQ0KICAgICAgICAgICAgICAgICAgICBNYXAgSm9pbiBPcGVyYXRvcg0KICAgICAg ICAgICAgICAgICAgICAgIGNvbmRpdGlvbiBtYXA6DQogICAgICAgICAgICAgICAgICAgICAgICAg ICBJbm5lciBKb2luIDAgdG8gMQ0KICAgICAgICAgICAgICAgICAgICAgIGNvbmRpdGlvbiBleHBy ZXNzaW9uczoNCiAgICAgICAgICAgICAgICAgICAgICAgIDAge19jb2wwfSB7X2NvbDR9IHtfY29s NX0ge19jb2w2fSB7X2NvbDd9IHtfY29sMTB9IHtfY29sMTN9IHtfY29sMTV9IHtfY29sMTZ9IHtf Y29sMjJ9IHtfY29sMjZ9IHtfY29sNTh9IHtfY29sNjB9IHtfY29sNjF9IHtfY29sNzB9IHtfY29s NzN9IHtfY29sNzh9IHtfY29sODZ9IHtfY29sODh9DQogICAgICAgICAgICAgICAgICAgICAgICAx IHtkX2RhdGVfc2t9DQogICAgICAgICAgICAgICAgICAgICAga2V5czoNCiAgICAgICAgICAgICAg ICAgICAgICAgIDAgX2NvbDAgKHR5cGU6IGludCkNCiAgICAgICAgICAgICAgICAgICAgICAgIDEg ZF9kYXRlX3NrICh0eXBlOiBpbnQpDQogICAgICAgICAgICAgICAgICAgICAgb3V0cHV0Q29sdW1u TmFtZXM6IF9jb2wwLCBfY29sNCwgX2NvbDUsIF9jb2w2LCBfY29sNywgX2NvbDEwLCBfY29sMTMs IF9jb2wxNSwgX2NvbDE2LCBfY29sMjIsIF9jb2wyNiwgX2NvbDU4LCBfY29sNjAsIF9jb2w2MSwg X2NvbDcwLCBfY29sNzMsIF9jb2w3OCwgX2NvbDg2LCBfY29sODgsIF9jb2w5NA0KICAgICAgICAg ICAgICAgICAgICAgIGlucHV0IHZlcnRpY2VzOg0KICAgICAgICAgICAgICAgICAgICAgICAgMSBN YXAgOA0KICAgICAgICAgICAgICAgICAgICAgIFN0YXRpc3RpY3M6IE51bSByb3dzOiA3ODkxNzY1 IERhdGEgc2l6ZTogMzE1NjcwNjkyIEJhc2ljIHN0YXRzOiBDT01QTEVURSBDb2x1bW4gc3RhdHM6 IE5PTkUNCiAgICAgICAgICAgICAgICAgICAgICBGaWx0ZXIgT3BlcmF0b3INCiAgICAgICAgICAg ICAgICAgICAgICAgIHByZWRpY2F0ZTogKCgoKF9jb2wyNiA9IF9jb2w3KSBhbmQgKF9jb2wwID0g X2NvbDk0KSkgYW5kICgoKCgoKCgoX2NvbDUgPSBfY29sNzApIGFuZCAoX2NvbDU4ID0gX2NvbDQp KSBhbmQgKF9jb2w2MCA9ICdNJykpIGFuZCAoX2NvbDYxID0gJzQgeXIgRGVncmVlJykpIGFuZCBf Y29sMTMgQkVUV0VFTiAxMDAuMCBBTkQgMTUwLjApIGFuZCAoX2NvbDczID0gMykpIG9yICgoKCgo KF9jb2w1ID0gX2NvbDcwKSBhbmQgKF9jb2w1OCA9IF9jb2w0KSkgYW5kIChfY29sNjAgPSAnRCcp KSBhbmQgKF9jb2w2MSA9ICdQcmltYXJ5JykpIGFuZCBfY29sMTMgQkVUV0VFTiA1MC4wIEFORCAx MDAuMCkgYW5kIChfY29sNzMgPSAxKSkpIG9yICgoKCgoKF9jb2w1ID0gX2NvbDcwKSBhbmQgKF9j b2w1OCA9IF9jb2w0KSkgYW5kIChfY29sNjAgPSAnVScpKSBhbmQgKF9jb2w2MSA9ICdBZHZhbmNl ZCBEZWdyZWUnKSkgYW5kIF9jb2wxMyBCRVRXRUVOIDE1MC4wIEFORCAyMDAuMCkgYW5kIChfY29s NzMgPSAxKSkpKSBhbmQgKCgoKCgoX2NvbDYgPSBfY29sNzgpIGFuZCAoX2NvbDg4ID0gJ1VuaXRl ZCBTdGF0ZXMnKSkgYW5kIChfY29sODYpIElOICgnS1knLCAnR0EnLCAnTk0nKSkgYW5kIF9jb2wy MiBCRVRXRUVOIDEwMCBBTkQgMjAwKSBvciAoKCgoX2NvbDYgPSBfY29sNzgpIGFuZCAoX2NvbDg4 ID0gJ1VuaXRlZCBTdGF0ZXMnKSkgYW5kIChfY29sODYpIElOICgnTVQnLCAnT1InLCAnSU4nKSkg YW5kIF9jb2wyMiBCRVRXRUVOIDE1MCBBTkQgMzAwKSkgb3IgKCgoKF9jb2w2ID0gX2NvbDc4KSBh bmQgKF9jb2w4OCA9ICdVbml0ZWQgU3RhdGVzJykpIGFuZCAoX2NvbDg2KSBJTiAoJ1dJJywgJ01P JywgJ1dWJykpIGFuZCBfY29sMjIgQkVUV0VFTiA1MCBBTkQgMjUwKSkpICh0eXBlOiBib29sZWFu KQ0KICAgICAgICAgICAgICAgICAgICAgICAgU3RhdGlzdGljczogTnVtIHJvd3M6IDE3MzQwIERh dGEgc2l6ZTogNjkzNjAwIEJhc2ljIHN0YXRzOiBDT01QTEVURSBDb2x1bW4gc3RhdHM6IE5PTkUN CiAgICAgICAgICAgICAgICAgICAgICAgIFNlbGVjdCBPcGVyYXRvcg0KICAgICAgICAgICAgICAg ICAgICAgICAgICBleHByZXNzaW9uczogX2NvbDEwICh0eXBlOiBpbnQpLCBfY29sMTUgKHR5cGU6 IGZsb2F0KSwgX2NvbDE2ICh0eXBlOiBmbG9hdCkNCiAgICAgICAgICAgICAgICAgICAgICAgICAg b3V0cHV0Q29sdW1uTmFtZXM6IF9jb2wxMCwgX2NvbDE1LCBfY29sMTYNCiAgICAgICAgICAgICAg ICAgICAgICAgICAgU3RhdGlzdGljczogTnVtIHJvd3M6IDE3MzQwIERhdGEgc2l6ZTogNjkzNjAw IEJhc2ljIHN0YXRzOiBDT01QTEVURSBDb2x1bW4gc3RhdHM6IE5PTkUNCiAgICAgICAgICAgICAg ICAgICAgICAgICAgR3JvdXAgQnkgT3BlcmF0b3INCiAgICAgICAgICAgICAgICAgICAgICAgICAg ICBhZ2dyZWdhdGlvbnM6IGF2ZyhfY29sMTApLCBhdmcoX2NvbDE1KSwgYXZnKF9jb2wxNiksIHN1 bShfY29sMTYpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgbW9kZTogaGFzaA0KICAgICAg ICAgICAgICAgICAgICAgICAgICAgIG91dHB1dENvbHVtbk5hbWVzOiBfY29sMCwgX2NvbDEsIF9j b2wyLCBfY29sMw0KICAgICAgICAgICAgICAgICAgICAgICAgICAgIFN0YXRpc3RpY3M6IE51bSBy b3dzOiAxIERhdGEgc2l6ZTogOCBCYXNpYyBzdGF0czogQ09NUExFVEUgQ29sdW1uIHN0YXRzOiBO T05FDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgUmVkdWNlIE91dHB1dCBPcGVyYXRvcg0K ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgc29ydCBvcmRlcjogDQogICAgICAgICAgICAg ICAgICAgICAgICAgICAgICBTdGF0aXN0aWNzOiBOdW0gcm93czogMSBEYXRhIHNpemU6IDggQmFz aWMgc3RhdHM6IENPTVBMRVRFIENvbHVtbiBzdGF0czogTk9ORQ0KICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgdmFsdWUgZXhwcmVzc2lvbnM6IF9jb2wwICh0eXBlOiBzdHJ1Y3Q8Y291bnQ6 YmlnaW50LHN1bTpkb3VibGUsaW5wdXQ6aW50PiksIF9jb2wxICh0eXBlOiBzdHJ1Y3Q8Y291bnQ6 YmlnaW50LHN1bTpkb3VibGUsaW5wdXQ6ZmxvYXQ+KSwgX2NvbDIgKHR5cGU6IHN0cnVjdDxjb3Vu dDpiaWdpbnQsc3VtOmRvdWJsZSxpbnB1dDpmbG9hdD4pLCBfY29sMyAodHlwZTogZG91YmxlKQ0K ICAgICAgICBSZWR1Y2VyIDYgDQogICAgICAgICAgICBSZWR1Y2UgT3BlcmF0b3IgVHJlZToNCiAg ICAgICAgICAgICAgR3JvdXAgQnkgT3BlcmF0b3INCiAgICAgICAgICAgICAgICBhZ2dyZWdhdGlv bnM6IGF2ZyhWQUxVRS5fY29sMCksIGF2ZyhWQUxVRS5fY29sMSksIGF2ZyhWQUxVRS5fY29sMiks IHN1bShWQUxVRS5fY29sMykNCiAgICAgICAgICAgICAgICBtb2RlOiBtZXJnZXBhcnRpYWwNCiAg ICAgICAgICAgICAgICBvdXRwdXRDb2x1bW5OYW1lczogX2NvbDAsIF9jb2wxLCBfY29sMiwgX2Nv bDMNCiAgICAgICAgICAgICAgICBTdGF0aXN0aWNzOiBOdW0gcm93czogMSBEYXRhIHNpemU6IDMy IEJhc2ljIHN0YXRzOiBDT01QTEVURSBDb2x1bW4gc3RhdHM6IE5PTkUNCiAgICAgICAgICAgICAg ICBTZWxlY3QgT3BlcmF0b3INCiAgICAgICAgICAgICAgICAgIGV4cHJlc3Npb25zOiBfY29sMCAo dHlwZTogZG91YmxlKSwgX2NvbDEgKHR5cGU6IGRvdWJsZSksIF9jb2wyICh0eXBlOiBkb3VibGUp LCBfY29sMyAodHlwZTogZG91YmxlKQ0KICAgICAgICAgICAgICAgICAgb3V0cHV0Q29sdW1uTmFt ZXM6IF9jb2wwLCBfY29sMSwgX2NvbDIsIF9jb2wzDQogICAgICAgICAgICAgICAgICBTdGF0aXN0 aWNzOiBOdW0gcm93czogMSBEYXRhIHNpemU6IDMyIEJhc2ljIHN0YXRzOiBDT01QTEVURSBDb2x1 bW4gc3RhdHM6IE5PTkUNCiAgICAgICAgICAgICAgICAgIEZpbGUgT3V0cHV0IE9wZXJhdG9yDQog ICAgICAgICAgICAgICAgICAgIGNvbXByZXNzZWQ6IGZhbHNlDQogICAgICAgICAgICAgICAgICAg IFN0YXRpc3RpY3M6IE51bSByb3dzOiAxIERhdGEgc2l6ZTogMzIgQmFzaWMgc3RhdHM6IENPTVBM RVRFIENvbHVtbiBzdGF0czogTk9ORQ0KICAgICAgICAgICAgICAgICAgICB0YWJsZToNCiAgICAg ICAgICAgICAgICAgICAgICAgIGlucHV0IGZvcm1hdDogb3JnLmFwYWNoZS5oYWRvb3AubWFwcmVk LlRleHRJbnB1dEZvcm1hdA0KICAgICAgICAgICAgICAgICAgICAgICAgb3V0cHV0IGZvcm1hdDog b3JnLmFwYWNoZS5oYWRvb3AuaGl2ZS5xbC5pby5IaXZlSWdub3JlS2V5VGV4dE91dHB1dEZvcm1h dA0KICAgICAgICAgICAgICAgICAgICAgICAgc2VyZGU6IG9yZy5hcGFjaGUuaGFkb29wLmhpdmUu c2VyZGUyLmxhenkuTGF6eVNpbXBsZVNlckRlDQoNCiAgU3RhZ2U6IFN0YWdlLTANCiAgICBGZXRj aCBPcGVyYXRvcg0KICAgICAgbGltaXQ6IC0xDQogICAgICBQcm9jZXNzb3IgVHJlZToNCiAgICAg ICAgTGlzdFNpbmsNCg0K --_006_d1da73711bf547e4925243dd04c46564HKXPR3002MB0120064dmgdm_ Content-Type: application/octet-stream; name="explicit join key.hql" Content-Description: explicit join key.hql Content-Disposition: attachment; filename="explicit join key.hql"; size=1873; creation-date="Thu, 17 Dec 2015 02:23:20 GMT"; modification-date="Thu, 17 Dec 2015 02:23:20 GMT" Content-Transfer-Encoding: base64 dXNlIHRwY2RzX3RleHRfMjsNCnNldCBoaXZlLmV4ZWN1dGlvbi5lbmdpbmU9dGV6Ow0Kc2VsZWN0 IGF2Zyhzc19xdWFudGl0eSkNCiAgICAgICAsYXZnKHNzX2V4dF9zYWxlc19wcmljZSkNCiAgICAg ICAsYXZnKHNzX2V4dF93aG9sZXNhbGVfY29zdCkNCiAgICAgICAsc3VtKHNzX2V4dF93aG9sZXNh bGVfY29zdCkNCmZyb20gc3RvcmVfc2FsZXMNCiAgICAgLHN0b3JlDQogICAgICxjdXN0b21lcl9k ZW1vZ3JhcGhpY3MNCiAgICAgLGhvdXNlaG9sZF9kZW1vZ3JhcGhpY3MNCiAgICAgLGN1c3RvbWVy X2FkZHJlc3MNCiAgICAgLGRhdGVfZGltDQp3aGVyZSBzdG9yZV9zYWxlcy5zc19zdG9yZV9zaz1z dG9yZS5zX3N0b3JlX3NrDQphbmQgIHN0b3JlX3NhbGVzLnNzX3NvbGRfZGF0ZV9zayA9IGRhdGVf ZGltLmRfZGF0ZV9zaw0KYW5kICBzdG9yZV9zYWxlcy5zc19oZGVtb19zaz1ob3VzZWhvbGRfZGVt b2dyYXBoaWNzLmhkX2RlbW9fc2sNCmFuZCAgc3RvcmVfc2FsZXMuc3NfY2RlbW9fc2s9Y3VzdG9t ZXJfZGVtb2dyYXBoaWNzLmNkX2RlbW9fc2sNCmFuZCAgc3RvcmVfc2FsZXMuc3NfYWRkcl9zayA9 IGN1c3RvbWVyX2FkZHJlc3MuY2FfYWRkcmVzc19zaw0KYW5kIGRhdGVfZGltLmRfeWVhciA9IDIw MDENCmFuZCgoDQogIGN1c3RvbWVyX2RlbW9ncmFwaGljcy5jZF9tYXJpdGFsX3N0YXR1cyA9ICdN Jw0KICBhbmQgY3VzdG9tZXJfZGVtb2dyYXBoaWNzLmNkX2VkdWNhdGlvbl9zdGF0dXMgPSAnNCB5 ciBEZWdyZWUnDQogIGFuZCBzdG9yZV9zYWxlcy5zc19zYWxlc19wcmljZSBiZXR3ZWVuIDEwMC4w MCBhbmQgMTUwLjAwDQogIGFuZCBob3VzZWhvbGRfZGVtb2dyYXBoaWNzLmhkX2RlcF9jb3VudCA9 IDMgICANCiAgICAgKW9yDQogICAgIChjdXN0b21lcl9kZW1vZ3JhcGhpY3MuY2RfbWFyaXRhbF9z dGF0dXMgPSAnRCcNCiAgYW5kIGN1c3RvbWVyX2RlbW9ncmFwaGljcy5jZF9lZHVjYXRpb25fc3Rh dHVzID0gJ1ByaW1hcnknDQogIGFuZCBzdG9yZV9zYWxlcy5zc19zYWxlc19wcmljZSBiZXR3ZWVu IDUwLjAwIGFuZCAxMDAuMDAgICANCiAgYW5kIGhvdXNlaG9sZF9kZW1vZ3JhcGhpY3MuaGRfZGVw X2NvdW50ID0gMQ0KICAgICApIG9yIA0KICAgICAoY3VzdG9tZXJfZGVtb2dyYXBoaWNzLmNkX21h cml0YWxfc3RhdHVzID0gJ1UnDQogIGFuZCBjdXN0b21lcl9kZW1vZ3JhcGhpY3MuY2RfZWR1Y2F0 aW9uX3N0YXR1cyA9ICdBZHZhbmNlZCBEZWdyZWUnDQogIGFuZCBzdG9yZV9zYWxlcy5zc19zYWxl c19wcmljZSBiZXR3ZWVuIDE1MC4wMCBhbmQgMjAwLjAwIA0KICBhbmQgaG91c2Vob2xkX2RlbW9n cmFwaGljcy5oZF9kZXBfY291bnQgPSAxICANCiAgICAgKSkNCg0KYW5kKChjdXN0b21lcl9hZGRy ZXNzLmNhX2NvdW50cnkgPSAnVW5pdGVkIFN0YXRlcycNCiAgYW5kIGN1c3RvbWVyX2FkZHJlc3Mu Y2Ffc3RhdGUgaW4gKCdLWScsICdHQScsICdOTScpDQogIGFuZCBzdG9yZV9zYWxlcy5zc19uZXRf cHJvZml0IGJldHdlZW4gMTAwIGFuZCAyMDAgIA0KICAgICApIG9yDQogICAgICgNCiAgY3VzdG9t ZXJfYWRkcmVzcy5jYV9jb3VudHJ5ID0gJ1VuaXRlZCBTdGF0ZXMnDQogIGFuZCBjdXN0b21lcl9h ZGRyZXNzLmNhX3N0YXRlIGluICgnTVQnLCAnT1InLCAnSU4nKQ0KICBhbmQgc3RvcmVfc2FsZXMu c3NfbmV0X3Byb2ZpdCBiZXR3ZWVuIDE1MCBhbmQgMzAwICANCiAgICAgKSBvcg0KICAgICAoY3Vz dG9tZXJfYWRkcmVzcy5jYV9jb3VudHJ5ID0gJ1VuaXRlZCBTdGF0ZXMnDQogIGFuZCBjdXN0b21l cl9hZGRyZXNzLmNhX3N0YXRlIGluICgnV0knLCAnTU8nLCAnV1YnKQ0KICBhbmQgc3RvcmVfc2Fs ZXMuc3NfbmV0X3Byb2ZpdCBiZXR3ZWVuIDUwIGFuZCAyNTAgIA0KICAgICApKTsNCg== --_006_d1da73711bf547e4925243dd04c46564HKXPR3002MB0120064dmgdm_--