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 8D4D2D5DA for ; Wed, 27 Jun 2012 18:46:45 +0000 (UTC) Received: (qmail 19274 invoked by uid 500); 27 Jun 2012 18:46:44 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 19186 invoked by uid 500); 27 Jun 2012 18:46:44 -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 19178 invoked by uid 99); 27 Jun 2012 18:46:44 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 27 Jun 2012 18:46:44 +0000 X-ASF-Spam-Status: No, hits=3.2 required=5.0 tests=FSL_FREEMAIL_1,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS,UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [98.139.52.202] (HELO nm5.bullet.mail.ac4.yahoo.com) (98.139.52.202) by apache.org (qpsmtpd/0.29) with SMTP; Wed, 27 Jun 2012 18:46:37 +0000 Received: from [98.139.52.192] by nm5.bullet.mail.ac4.yahoo.com with NNFMP; 27 Jun 2012 18:46:15 -0000 Received: from [98.139.52.130] by tm5.bullet.mail.ac4.yahoo.com with NNFMP; 27 Jun 2012 18:46:15 -0000 Received: from [127.0.0.1] by omp1013.mail.ac4.yahoo.com with NNFMP; 27 Jun 2012 18:46:15 -0000 X-Yahoo-Newman-Id: 734464.71134.bm@omp1013.mail.ac4.yahoo.com Received: (qmail 11640 invoked from network); 27 Jun 2012 18:46:15 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=DKIM-Signature:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:X-rim-org-msg-ref-id:Message-ID:Reply-To:X-Priority:References:In-Reply-To:Sensitivity:Importance:Subject:To:From:Date:Content-Type:MIME-Version; b=RIwpj6KFTl07kboH8vUNxp35pCHFtnA0DK/WXBH/lnA2kzG+FIHfslXffHNRXAS83Fum1c/YL02SqFW9gS4wRP8KpRy8yCqCCDHE98uae2cFlXqCWJX5Nlk0WwRfk05uLqxhqpz24Adr0JTx4H4xkLWwwC+Xh6flFRWLK1r3Z9U= ; DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1340822775; bh=xxiwZ/y9i8qvAizui74O826DRXg7Ct6DEAfiy1tp9/8=; h=X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:X-rim-org-msg-ref-id:Message-ID:Reply-To:X-Priority:References:In-Reply-To:Sensitivity:Importance:Subject:To:From:Date:Content-Type:MIME-Version; b=5RPnHThL+V2IRaWFCayG6uaPKhH50J24wjNtsakowf7WUDwBrmhL53ka4jLL+soHOrXYkIFzMSBriX+Ly7W2gFBZQNWuGvGnG+/Q+GXZvi3Vrx5BuBgXoH8tbt7g4vz4ZdFFdHH84PuFQPS+G8KpKjPL5aa3O5kyWi0BYn+1T30= X-Yahoo-Newman-Property: ymail-3 X-YMail-OSG: 7G1ldX0VM1kYbLZsCuFbJKjkLvVC8i8SvAGBDpjueD3Qxap VGqpHKj5zPachcspEe3pfyE.5d7DIaKXgmpGGSiKhCmfUGm29OjJ3pT9GGGb A5yPPnOFjRb2I3bTgLEvngOqy65z3aAYyYMf822DGA2HscZFagV7WuP5foTp 6B58okiYgQKF837punHdN1f6X5yTPyxr_l.EBNpld6lcQ0MLy9ZXFpE19EkL 8an43b014d2eydyMicma9sJnZl3_jCKXF5sBjx_joACbzDcZVZcQu_g4yGvt _NUqkSILJwX5B091uKxB2_jzf5PwePhYEF22AzjbswzNcpA7ZD30C84VI_42 1ayXXBTTNpyDYCqD5Vfes0hXMk3vsGrojeq5oK2MMMg_pUka3o5g3 X-Yahoo-SMTP: fUyZ91eswBBme0tpFWJ5iyHn6M7J Received: from b2.c15.bise7.blackberry (bejoy_ks@178.239.86.185 with xymcookie) by smtp122-mob.biz.mail.ac4.yahoo.com with SMTP; 27 Jun 2012 11:46:15 -0700 PDT X-rim-org-msg-ref-id: 1511844346 Message-ID: <1511844346-1340822772-cardhu_decombobulator_blackberry.rim.net-346875112-@b17.c15.bise7.blackberry> Reply-To: bejoy_ks@yahoo.com X-Priority: Normal References: <2AD0F14A76338B4FA3C06F5BA1C1D2DB043918EB@008-AM1MPN1-071.mgdnok.nokia.com> In-Reply-To: <2AD0F14A76338B4FA3C06F5BA1C1D2DB043918EB@008-AM1MPN1-071.mgdnok.nokia.com> Sensitivity: Normal Importance: Normal Subject: Re: Obvious and not so obvious query optimzations in Hive To: user@hive.apache.org From: "Bejoy KS" Date: Wed, 27 Jun 2012 18:46:14 +0000 Content-Type: multipart/alternative; boundary="part4553-boundary-910530327-561674954" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org --part4553-boundary-910530327-561674954 Content-Transfer-Encoding: base64 Content-Type: text/plain; charset="Windows-1252" SGkgUmljaGluCgpJJ20gbm90IGFuIEFXUyBndXkgYnV0IHN0aWxsIGxlbW1lIHRyeSBhbnN3ZXJp bmcgYSBmZXcgcXVlc3Rpb25zIGluIGdlbmVyYWwgKG5vdCB3cnQgQVdTIEVNUikKCjEuoKCgoKCg IEhhdmluZyBteSBleHRlcm5hbCB0YWJsZSBkYXRhIGd6aXBwZWQgYW5kIHJlYWRpbmcgaXQgaW4g dGhlIHRhYmxlIHYvcyBubyBjb21wcmVzc2lvbiBhdCBhbGwuCgpCZWpveTogV2hlbiB0aGUgZGF0 YSB2b2x1bWUgaXMgbGFyZ2UgY29tcHJlc3Npb24gc2F2ZXMgdXAgdGhlIGRpc2sgc3BhY2UgYW5k IGhlbmNlIGl0IGlzIHJlY29tbWVuZGVkLiBHemlwIGlzIG5vdCBzcGxpdHRhYmxlLCBtZWFucyBv bmUgZmlsZSBjYW4ndCBiZSBkaXN0cmlidXRlZCBhY3Jvc3MgbWFwIHRhc2tzLiBHbyBpbiB3aXRo IEx6byBvciBTbmFwcHkuCgoyLqCgoKCgoCBIYXZpbmcgdGhlIGV4dGVybmFsIHRhYmxlIGRhdGEg b24gUzMgdi9zIGhhdmluZyBpdCBvbiBIREZTPwoKMy6goKCgoKAgQ3JlYXRpbmcgaW50ZXJtZWRp YXRlIGV4dGVybmFsIHRhYmxlcyB2L3Mgbm9uIGV4dGVybmFsIHRhYmxlcyB2L3MgY3JlYXRpbmcg dmlld3M/CgpCZWpveTogRXh0ZXJuYWwgVGFibGVzIGFyZSBub3QgbXVjaCBkaWZmZXJlbnQgdGhh biBtYW5hZ2VkIHRhYmxlcy4gSW4gbWFuYWdlZCB0YWJsZXMgd2hlbiB5b3UgZHJvcCB0aGUgdGFi bGUgdXNpbmcgSFFMIHRoZSB1bmRlcmx5aW5nIGRhdGEgaW4gaGRmcyBpcyBhbHNvIGRlbGV0ZWQg YnV0IGluIGNhc2Ugb2YgRXh0ZXJuYWwgdGFibGVzIG9ubHkgdGhlIHRhYmxlIGRlZm4gaXMgZHJv cHBlZCBhbmQgdGhlIGRhdGEgaW4gaGRmcyBpcyBwcmVzZXJ2ZWQuIFZpZXdzIGFyZSBub3QgZXZh bHVhdGVkIG9uIGl0cyBjcmVhdGlvbiB0aW1lLCBidXQgd2hlbiBpdCBpcyB1c2VkIE1SIGpvYnMg YXJlIHRyaWdnZXJlZCBhbmQgdGhlIHJlcXVpcmVkIGRhdGEgaXMgZXh0cmFjdGVkIG91dCBvZiBz b3VyY2UgdGFibGVzLiBTbyBpZiB5b3UgYXJlIHBsYW5uaW5nIHRvIHJldXNlIGEgdmlldyBuIG51 bWJlciBvZiB0aW1lcyBpdCdsbCBiZSBiZXR0ZXIgY3JlYXRpbmcgYSB0YWJsZSBhbmQgdXNpbmcg aXQgZWxzZSB0aGUgdmlldyBxdWVyeSB3aWxsIGJlIGV2YWx1YXRlZCBuIHRpbWVzLgoKNC6goKCg oKAgU3RvcmluZyB0aGUgZXh0ZXJuYWwgdGFibGUgYXMgVGV4dGZpbGUgdi9zIFNlcXVlbmNlIGZp bGUuIEkga25vdyBzZXF1ZW5jZSBmaWxlIGNvbXByZXNzZXMgdGhlIGRhdGEsIGJ1dCBpbiB3aGF0 IGZvcm1hdD8gSSByZWFkIGFib3V0IFJDIGZpbGVzIGFuZCBob3cgZWZmaWNpZW50IHRoZXkgYXJl LCBob3cgdG8gdXNlIHRoZW0/CgpCZWpveTogU2VxdWVuY2UgZmlsZXMgYXJlIHNwbGl0YWJsZSBv biBpdHMgb3duIHNvIGl0IGlzIGEgZ29vZCBjaG9pY2Ugd2hlbiB1c2luZyB3aXRoIFNuYXBweS4g SW4gc2VxdWVuY2UgZmlsZSwgY29tcHJlc3Npb24gaGFwcGVucyBlaXRoZXIgYXQgcmVjb3JkIGxl dmVsIG9yIGJsb2NrIGxldmVsIHdoaWNoIGlzIGNvbmZpZ3VyYWJsZSBhdCB0aGUgdGltZSBvZiBj b21wcmVzc2luZy4gSWYgeW91IGFyZSB1c2luZyBHemlwLCBUZXh0RmlsZXMgb2ZmZXIgbW9yZSBj b21wcmVzc2lvbiByYXRpbyBhcyB0aGUgd2hvbGUgZGF0YSBpcyBjb21wcmVzc2VkIGluIGEgZ28g Y29tcGFyZWQgd2l0aCBTZXF1ZW5jZSBmaWxlcyB3aGVyZSBpdCBoYXBwZW5zIHBlciByZWNvcmQv YmxvY2suIEJ1dCB0aGVuIHlvdSBjb21wcm9taXNlIG9uIHNwbGl0YWJpbGl0eS4gUkMgZmlsZXMg YXJlIGEgZ29vZCBjaG9pY2Ugd2hlbiB5b3VyIHF1ZXJpZXMgaW52b2x2ZSBxdWVyeWluZyBvbmx5 IGEgZmV3IGNvbHVtbnMgcmF0aGVyIHRoYW4gYWxsIGNvbHVtbnMgaW4gYSByb3cuIAoKNS6goKCg oKAgSG93IGFyZSBudW1iZXIgb2YgcmVkdWNlcnMgZ2V0IHNldCBmb3IgYSBIaXZlIHF1ZXJ5IChU aGUgd2F5IGdyb3VwIGJ5IGFuZCBvcmRlciBieSBzZXRzIHRoZSBudW1iZXIgb2YgcmVkdWNlcnMg dG8gMSkgPyBJZiBJIGFtIG5vdCBjaGFuZ2luZyBpdCBleHBsaWNpdGx5IGRvZXMgaXQgcGljayBp dCBmcm9tIHRoZSB1bmRlcmx5aW5nIEhhZG9vcCBjbHVzdGVyPyBJIGFtIHRyeWluZyB0byB1bmRl cnN0YW5kIHRoZSBib3R0bGVuZWNrIGJldHdlZW4gcXVlcnkgYW5kIGNsdXN0ZXIgc2l6ZS4KCkJl am95OiBTb21lIHF1ZXJpZXMgaW4gaGl2ZSBhcmUgZm9yY2VkIHRvIGhhdmUganVzdCBhIHNpbmds ZSByZWR1Y2VyIGxpa2UgT3JkZXIgQnkuIEluIGNhc2Ugb2Ygb3RoZXIgcXVlcmllcyBoaXZlIGRl dGVybWluZXMgdGhlIG51bWJlciBvZiByZWR1Y2Vycy4gSG93ZXZlciB5b3UgY2FuIGFsd2F5cyBz cGVjaWZ5IHRoZSBudW1iZXIgb2YgcmVkdWNlciBvbiBhIHBlciBxdWVyeSBiYXNpcyBiYXNlZCBv biB0aGUgZGF0YSBpdCBwcm9jZXNzLiAKCjYuoKCgoKCgIEFueSBvdGhlciBvcHRpbWl6YXRpb25z LyBiZXN0IHByYWN0aWNlcz8KCkJlam95OiBUaGVyZSBhcmUgbG90cyBvZiBvdGhlciBvcHRpbWl6 YXRpb25zIGluIGhpdmUgd2hpY2ggY2FuIGJlIGluamVjdGVkIGJhc2VkIG9uIHRoZSBxdWVyeS4g VGhlcmUgYXJlIHZhcmlvdXMgam9pbiBvcHRpbWl6YXRpb25zLCBncm91cCBieSBvcHRpbWl6YXRp b25zIGV0YyBzdWl0ZWQgZm9yIHNwZWNpZmljIG5lZWRzLgoKCg0KUmVnYXJkcw0KQmVqb3kgS1MN Cg0KU2VudCBmcm9tIGhhbmRoZWxkLCBwbGVhc2UgZXhjdXNlIHR5cG9zLg0KDQotLS0tLU9yaWdp bmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTogPHJpY2hpbi5qYWluQG5va2lhLmNvbT4NCkRhdGU6IFdl ZCwgMjcgSnVuIDIwMTIgMTU6NDc6NTQgDQpUbzogPHVzZXJAaGl2ZS5hcGFjaGUub3JnPg0KUmVw bHktVG86IHVzZXJAaGl2ZS5hcGFjaGUub3JnDQpTdWJqZWN0OiBPYnZpb3VzIGFuZCBub3Qgc28g b2J2aW91cyBxdWVyeSBvcHRpbXphdGlvbnMgaW4gSGl2ZQ0KDQpIZXkgSGl2ZXJzLA0KDQpJIGFt IHRyeWluZyB0byB1bmRlcnN0YW5kIHdoYXQgYXJlIHNvbWUgb2YgdGhlIG9idmlvdXMgYW5kIG5v dCBzbyBvYnZpb3VzIG9wdGltaXphdGlvbiBJIGNvdWxkIGRvIGZvciBhIEhpdmUgUXVlcnkgb24g QVdTIEVNUiBjbHVzdGVyLiBJIGtub3cgdGhlIGFuc3dlciBmb3Igc29tZSBvZiB0aGVzZSBxdWVz dGlvbnMgYnV0IHdhbnQgdG8ga25vdyB3aGF0IGRvIHlvdSBndXlzIHRoaW5rIGFuZCBieSB3aGF0 IGZhY3RvciBpdCBhZmZlY3RzIHRoZSBwZXJmb3JtYW5jZSBvdmVyIHRoZSBvdGhlciBhcHByb2Fj aC4NCg0KDQoxLiAgICAgICBIYXZpbmcgbXkgZXh0ZXJuYWwgdGFibGUgZGF0YSBnemlwcGVkIGFu ZCByZWFkaW5nIGl0IGluIHRoZSB0YWJsZSB2L3Mgbm8gY29tcHJlc3Npb24gYXQgYWxsLg0KDQoy LiAgICAgICBIYXZpbmcgdGhlIGV4dGVybmFsIHRhYmxlIGRhdGEgb24gUzMgdi9zIGhhdmluZyBp dCBvbiBIREZTPw0KDQozLiAgICAgICBDcmVhdGluZyBpbnRlcm1lZGlhdGUgZXh0ZXJuYWwgdGFi bGVzIHYvcyBub24gZXh0ZXJuYWwgdGFibGVzIHYvcyBjcmVhdGluZyB2aWV3cz8NCg0KNC4gICAg ICAgU3RvcmluZyB0aGUgZXh0ZXJuYWwgdGFibGUgYXMgVGV4dGZpbGUgdi9zIFNlcXVlbmNlIGZp bGUuIEkga25vdyBzZXF1ZW5jZSBmaWxlIGNvbXByZXNzZXMgdGhlIGRhdGEsIGJ1dCBpbiB3aGF0 IGZvcm1hdD8gSSByZWFkIGFib3V0IFJDIGZpbGVzIGFuZCBob3cgZWZmaWNpZW50IHRoZXkgYXJl LCBob3cgdG8gdXNlIHRoZW0/DQoNCjUuICAgICAgIEhvdyBhcmUgbnVtYmVyIG9mIHJlZHVjZXJz IGdldCBzZXQgZm9yIGEgSGl2ZSBxdWVyeSAoVGhlIHdheSBncm91cCBieSBhbmQgb3JkZXIgYnkg c2V0cyB0aGUgbnVtYmVyIG9mIHJlZHVjZXJzIHRvIDEpID8gSWYgSSBhbSBub3QgY2hhbmdpbmcg aXQgZXhwbGljaXRseSBkb2VzIGl0IHBpY2sgaXQgZnJvbSB0aGUgdW5kZXJseWluZyBIYWRvb3Ag Y2x1c3Rlcj8gSSBhbSB0cnlpbmcgdG8gdW5kZXJzdGFuZCB0aGUgYm90dGxlbmVjayBiZXR3ZWVu IHF1ZXJ5IGFuZCBjbHVzdGVyIHNpemUuDQoNCjYuICAgICAgIEFueSBvdGhlciBvcHRpbWl6YXRp b25zLyBiZXN0IHByYWN0aWNlcz8NCg0KVGhhbmtzIGEgbG90IGluIGFkdmFuY2UuDQpSaWNoaW4N Cg0K --part4553-boundary-910530327-561674954 Content-Transfer-Encoding: base64 Content-Type: text/html; charset="Windows-1252" PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6bT0iaHR0cDovL3NjaGVtYXMubWlj cm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcv VFIvUkVDLWh0bWw0MCI+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIg Y29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PXVzLWFzY2lpIj4NCjxtZXRhIG5hbWU9IkdlbmVy YXRvciIgY29udGVudD0iTWljcm9zb2Z0IFdvcmQgMTQgKGZpbHRlcmVkIG1lZGl1bSkiPg0KPHN0 eWxlPjwhLS0NCi8qIEZvbnQgRGVmaW5pdGlvbnMgKi8NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1p bHk6Q2FsaWJyaTsNCglwYW5vc2UtMToyIDE1IDUgMiAyIDIgNCAzIDIgNDt9DQovKiBTdHlsZSBE ZWZpbml0aW9ucyAqLw0KcC5Nc29Ob3JtYWwsIGxpLk1zb05vcm1hbCwgZGl2Lk1zb05vcm1hbA0K CXttYXJnaW46MGluOw0KCW1hcmdpbi1ib3R0b206LjAwMDFwdDsNCglmb250LXNpemU6MTEuMHB0 Ow0KCWZvbnQtZmFtaWx5OiJDYWxpYnJpIiwic2Fucy1zZXJpZiI7fQ0KYTpsaW5rLCBzcGFuLk1z b0h5cGVybGluaw0KCXttc28tc3R5bGUtcHJpb3JpdHk6OTk7DQoJY29sb3I6Ymx1ZTsNCgl0ZXh0 LWRlY29yYXRpb246dW5kZXJsaW5lO30NCmE6dmlzaXRlZCwgc3Bhbi5Nc29IeXBlcmxpbmtGb2xs b3dlZA0KCXttc28tc3R5bGUtcHJpb3JpdHk6OTk7DQoJY29sb3I6cHVycGxlOw0KCXRleHQtZGVj b3JhdGlvbjp1bmRlcmxpbmU7fQ0KcC5Nc29MaXN0UGFyYWdyYXBoLCBsaS5Nc29MaXN0UGFyYWdy YXBoLCBkaXYuTXNvTGlzdFBhcmFncmFwaA0KCXttc28tc3R5bGUtcHJpb3JpdHk6MzQ7DQoJbWFy Z2luLXRvcDowaW47DQoJbWFyZ2luLXJpZ2h0OjBpbjsNCgltYXJnaW4tYm90dG9tOjBpbjsNCglt YXJnaW4tbGVmdDouNWluOw0KCW1hcmdpbi1ib3R0b206LjAwMDFwdDsNCglmb250LXNpemU6MTEu MHB0Ow0KCWZvbnQtZmFtaWx5OiJDYWxpYnJpIiwic2Fucy1zZXJpZiI7fQ0Kc3Bhbi5FbWFpbFN0 eWxlMTcNCgl7bXNvLXN0eWxlLXR5cGU6cGVyc29uYWwtY29tcG9zZTsNCglmb250LWZhbWlseToi Q2FsaWJyaSIsInNhbnMtc2VyaWYiOw0KCWNvbG9yOndpbmRvd3RleHQ7fQ0KLk1zb0NocERlZmF1 bHQNCgl7bXNvLXN0eWxlLXR5cGU6ZXhwb3J0LW9ubHk7DQoJZm9udC1mYW1pbHk6IkNhbGlicmki LCJzYW5zLXNlcmlmIjt9DQpAcGFnZSBXb3JkU2VjdGlvbjENCgl7c2l6ZTo4LjVpbiAxMS4waW47 DQoJbWFyZ2luOjEuMGluIDEuMGluIDEuMGluIDEuMGluO30NCmRpdi5Xb3JkU2VjdGlvbjENCgl7 cGFnZTpXb3JkU2VjdGlvbjE7fQ0KLyogTGlzdCBEZWZpbml0aW9ucyAqLw0KQGxpc3QgbDANCgl7 bXNvLWxpc3QtaWQ6ODM0MTA0NzkwOw0KCW1zby1saXN0LXR5cGU6aHlicmlkOw0KCW1zby1saXN0 LXRlbXBsYXRlLWlkczotMTg3Nzk4MzAxMCA2NzY5ODcwMyA2NzY5ODcxMyA2NzY5ODcxNSA2NzY5 ODcwMyA2NzY5ODcxMyA2NzY5ODcxNSA2NzY5ODcwMyA2NzY5ODcxMyA2NzY5ODcxNTt9DQpAbGlz dCBsMDpsZXZlbDENCgl7bXNvLWxldmVsLXRhYi1zdG9wOm5vbmU7DQoJbXNvLWxldmVsLW51bWJl ci1wb3NpdGlvbjpsZWZ0Ow0KCXRleHQtaW5kZW50Oi0uMjVpbjt9DQpAbGlzdCBsMDpsZXZlbDIN Cgl7bXNvLWxldmVsLW51bWJlci1mb3JtYXQ6YWxwaGEtbG93ZXI7DQoJbXNvLWxldmVsLXRhYi1z dG9wOm5vbmU7DQoJbXNvLWxldmVsLW51bWJlci1wb3NpdGlvbjpsZWZ0Ow0KCXRleHQtaW5kZW50 Oi0uMjVpbjt9DQpAbGlzdCBsMDpsZXZlbDMNCgl7bXNvLWxldmVsLW51bWJlci1mb3JtYXQ6cm9t YW4tbG93ZXI7DQoJbXNvLWxldmVsLXRhYi1zdG9wOm5vbmU7DQoJbXNvLWxldmVsLW51bWJlci1w b3NpdGlvbjpyaWdodDsNCgl0ZXh0LWluZGVudDotOS4wcHQ7fQ0KQGxpc3QgbDA6bGV2ZWw0DQoJ e21zby1sZXZlbC10YWItc3RvcDpub25lOw0KCW1zby1sZXZlbC1udW1iZXItcG9zaXRpb246bGVm dDsNCgl0ZXh0LWluZGVudDotLjI1aW47fQ0KQGxpc3QgbDA6bGV2ZWw1DQoJe21zby1sZXZlbC1u dW1iZXItZm9ybWF0OmFscGhhLWxvd2VyOw0KCW1zby1sZXZlbC10YWItc3RvcDpub25lOw0KCW1z by1sZXZlbC1udW1iZXItcG9zaXRpb246bGVmdDsNCgl0ZXh0LWluZGVudDotLjI1aW47fQ0KQGxp c3QgbDA6bGV2ZWw2DQoJe21zby1sZXZlbC1udW1iZXItZm9ybWF0OnJvbWFuLWxvd2VyOw0KCW1z by1sZXZlbC10YWItc3RvcDpub25lOw0KCW1zby1sZXZlbC1udW1iZXItcG9zaXRpb246cmlnaHQ7 DQoJdGV4dC1pbmRlbnQ6LTkuMHB0O30NCkBsaXN0IGwwOmxldmVsNw0KCXttc28tbGV2ZWwtdGFi LXN0b3A6bm9uZTsNCgltc28tbGV2ZWwtbnVtYmVyLXBvc2l0aW9uOmxlZnQ7DQoJdGV4dC1pbmRl bnQ6LS4yNWluO30NCkBsaXN0IGwwOmxldmVsOA0KCXttc28tbGV2ZWwtbnVtYmVyLWZvcm1hdDph bHBoYS1sb3dlcjsNCgltc28tbGV2ZWwtdGFiLXN0b3A6bm9uZTsNCgltc28tbGV2ZWwtbnVtYmVy LXBvc2l0aW9uOmxlZnQ7DQoJdGV4dC1pbmRlbnQ6LS4yNWluO30NCkBsaXN0IGwwOmxldmVsOQ0K CXttc28tbGV2ZWwtbnVtYmVyLWZvcm1hdDpyb21hbi1sb3dlcjsNCgltc28tbGV2ZWwtdGFiLXN0 b3A6bm9uZTsNCgltc28tbGV2ZWwtbnVtYmVyLXBvc2l0aW9uOnJpZ2h0Ow0KCXRleHQtaW5kZW50 Oi05LjBwdDt9DQpvbA0KCXttYXJnaW4tYm90dG9tOjBpbjt9DQp1bA0KCXttYXJnaW4tYm90dG9t OjBpbjt9DQotLT48L3N0eWxlPjwhLS1baWYgZ3RlIG1zbyA5XT48eG1sPg0KPG86c2hhcGVkZWZh dWx0cyB2OmV4dD0iZWRpdCIgc3BpZG1heD0iMTAyNiIgLz4NCjwveG1sPjwhW2VuZGlmXS0tPjwh LS1baWYgZ3RlIG1zbyA5XT48eG1sPg0KPG86c2hhcGVsYXlvdXQgdjpleHQ9ImVkaXQiPg0KPG86 aWRtYXAgdjpleHQ9ImVkaXQiIGRhdGE9IjEiIC8+DQo8L286c2hhcGVsYXlvdXQ+PC94bWw+PCFb ZW5kaWZdLS0+DQo8L2hlYWQ+DQo8Ym9keSBsYW5nPSJFTi1VUyIgbGluaz0iYmx1ZSIgdmxpbms9 InB1cnBsZSI+SGkgUmljaGluPGJyLz48YnIvPkknbSBub3QgYW4gQVdTIGd1eSBidXQgc3RpbGwg bGVtbWUgdHJ5IGFuc3dlcmluZyBhIGZldyBxdWVzdGlvbnMgaW4gZ2VuZXJhbCAobm90IHdydCBB V1MgRU1SKTxici8+PGJyLz4xLqCgoKCgoCBIYXZpbmcgbXkgZXh0ZXJuYWwgdGFibGUgZGF0YSBn emlwcGVkIGFuZCByZWFkaW5nIGl0IGluIHRoZSB0YWJsZSB2L3Mgbm8gY29tcHJlc3Npb24gYXQg YWxsLjxici8+PGJyLz5CZWpveTogV2hlbiB0aGUgZGF0YSB2b2x1bWUgaXMgbGFyZ2UgY29tcHJl c3Npb24gc2F2ZXMgdXAgdGhlIGRpc2sgc3BhY2UgYW5kIGhlbmNlIGl0IGlzIHJlY29tbWVuZGVk LiBHemlwIGlzIG5vdCBzcGxpdHRhYmxlLCBtZWFucyBvbmUgZmlsZSBjYW4ndCBiZSBkaXN0cmli dXRlZCBhY3Jvc3MgbWFwIHRhc2tzLiBHbyBpbiB3aXRoIEx6byBvciBTbmFwcHkuPGJyLz48YnIv PjIuoKCgoKCgIEhhdmluZyB0aGUgZXh0ZXJuYWwgdGFibGUgZGF0YSBvbiBTMyB2L3MgaGF2aW5n IGl0IG9uIEhERlM/PGJyLz48YnIvPjMuoKCgoKCgIENyZWF0aW5nIGludGVybWVkaWF0ZSBleHRl cm5hbCB0YWJsZXMgdi9zIG5vbiBleHRlcm5hbCB0YWJsZXMgdi9zIGNyZWF0aW5nIHZpZXdzPzxi ci8+PGJyLz5CZWpveTogRXh0ZXJuYWwgVGFibGVzIGFyZSBub3QgbXVjaCBkaWZmZXJlbnQgdGhh biBtYW5hZ2VkIHRhYmxlcy4gSW4gbWFuYWdlZCB0YWJsZXMgd2hlbiB5b3UgZHJvcCB0aGUgdGFi bGUgdXNpbmcgSFFMIHRoZSB1bmRlcmx5aW5nIGRhdGEgaW4gaGRmcyBpcyBhbHNvIGRlbGV0ZWQg YnV0IGluIGNhc2Ugb2YgRXh0ZXJuYWwgdGFibGVzIG9ubHkgdGhlIHRhYmxlIGRlZm4gaXMgZHJv cHBlZCBhbmQgdGhlIGRhdGEgaW4gaGRmcyBpcyBwcmVzZXJ2ZWQuIFZpZXdzIGFyZSBub3QgZXZh bHVhdGVkIG9uIGl0cyBjcmVhdGlvbiB0aW1lLCBidXQgd2hlbiBpdCBpcyB1c2VkIE1SIGpvYnMg YXJlIHRyaWdnZXJlZCBhbmQgdGhlIHJlcXVpcmVkIGRhdGEgaXMgZXh0cmFjdGVkIG91dCBvZiBz b3VyY2UgdGFibGVzLiBTbyBpZiB5b3UgYXJlIHBsYW5uaW5nIHRvIHJldXNlIGEgdmlldyBuIG51 bWJlciBvZiB0aW1lcyBpdCdsbCBiZSBiZXR0ZXIgY3JlYXRpbmcgYSB0YWJsZSBhbmQgdXNpbmcg aXQgZWxzZSB0aGUgdmlldyBxdWVyeSB3aWxsIGJlIGV2YWx1YXRlZCBuIHRpbWVzLjxici8+PGJy Lz40LqCgoKCgoCBTdG9yaW5nIHRoZSBleHRlcm5hbCB0YWJsZSBhcyBUZXh0ZmlsZSB2L3MgU2Vx dWVuY2UgZmlsZS4gSSBrbm93IHNlcXVlbmNlIGZpbGUgY29tcHJlc3NlcyB0aGUgZGF0YSwgYnV0 IGluIHdoYXQgZm9ybWF0PyBJIHJlYWQgYWJvdXQgUkMgZmlsZXMgYW5kIGhvdyBlZmZpY2llbnQg dGhleSBhcmUsIGhvdyB0byB1c2UgdGhlbT88YnIvPjxici8+QmVqb3k6IFNlcXVlbmNlIGZpbGVz IGFyZSBzcGxpdGFibGUgb24gaXRzIG93biBzbyBpdCBpcyBhIGdvb2QgY2hvaWNlIHdoZW4gdXNp bmcgd2l0aCBTbmFwcHkuIEluIHNlcXVlbmNlIGZpbGUsIGNvbXByZXNzaW9uIGhhcHBlbnMgZWl0 aGVyIGF0IHJlY29yZCBsZXZlbCBvciBibG9jayBsZXZlbCB3aGljaCBpcyBjb25maWd1cmFibGUg YXQgdGhlIHRpbWUgb2YgY29tcHJlc3NpbmcuIElmIHlvdSBhcmUgdXNpbmcgR3ppcCwgVGV4dEZp bGVzIG9mZmVyIG1vcmUgY29tcHJlc3Npb24gcmF0aW8gYXMgdGhlIHdob2xlIGRhdGEgaXMgY29t cHJlc3NlZCBpbiBhIGdvIGNvbXBhcmVkIHdpdGggU2VxdWVuY2UgZmlsZXMgd2hlcmUgaXQgaGFw cGVucyBwZXIgcmVjb3JkL2Jsb2NrLiBCdXQgdGhlbiB5b3UgY29tcHJvbWlzZSBvbiBzcGxpdGFi aWxpdHkuIFJDIGZpbGVzIGFyZSBhIGdvb2QgY2hvaWNlIHdoZW4geW91ciBxdWVyaWVzIGludm9s dmUgcXVlcnlpbmcgb25seSBhIGZldyBjb2x1bW5zIHJhdGhlciB0aGFuIGFsbCBjb2x1bW5zIGlu IGEgcm93LiA8YnIvPjxici8+NS6goKCgoKAgSG93IGFyZSBudW1iZXIgb2YgcmVkdWNlcnMgZ2V0 IHNldCBmb3IgYSBIaXZlIHF1ZXJ5IChUaGUgd2F5IGdyb3VwIGJ5IGFuZCBvcmRlciBieSBzZXRz IHRoZSBudW1iZXIgb2YgcmVkdWNlcnMgdG8gMSkgPyBJZiBJIGFtIG5vdCBjaGFuZ2luZyBpdCBl eHBsaWNpdGx5IGRvZXMgaXQgcGljayBpdCBmcm9tIHRoZSB1bmRlcmx5aW5nIEhhZG9vcCBjbHVz dGVyPyBJIGFtIHRyeWluZyB0byB1bmRlcnN0YW5kIHRoZSBib3R0bGVuZWNrIGJldHdlZW4gcXVl cnkgYW5kIGNsdXN0ZXIgc2l6ZS48YnIvPjxici8+QmVqb3k6IFNvbWUgcXVlcmllcyBpbiBoaXZl IGFyZSBmb3JjZWQgdG8gaGF2ZSBqdXN0IGEgc2luZ2xlIHJlZHVjZXIgbGlrZSBPcmRlciBCeS4g SW4gY2FzZSBvZiBvdGhlciBxdWVyaWVzIGhpdmUgZGV0ZXJtaW5lcyB0aGUgbnVtYmVyIG9mIHJl ZHVjZXJzLiBIb3dldmVyIHlvdSBjYW4gYWx3YXlzIHNwZWNpZnkgdGhlIG51bWJlciBvZiByZWR1 Y2VyIG9uIGEgcGVyIHF1ZXJ5IGJhc2lzIGJhc2VkIG9uIHRoZSBkYXRhIGl0IHByb2Nlc3MuIDxi ci8+PGJyLz42LqCgoKCgoCBBbnkgb3RoZXIgb3B0aW1pemF0aW9ucy8gYmVzdCBwcmFjdGljZXM/ PGJyLz48YnIvPkJlam95OiBUaGVyZSBhcmUgbG90cyBvZiBvdGhlciBvcHRpbWl6YXRpb25zIGlu IGhpdmUgd2hpY2ggY2FuIGJlIGluamVjdGVkIGJhc2VkIG9uIHRoZSBxdWVyeS4gVGhlcmUgYXJl IHZhcmlvdXMgam9pbiBvcHRpbWl6YXRpb25zLCBncm91cCBieSBvcHRpbWl6YXRpb25zIGV0YyBz dWl0ZWQgZm9yIHNwZWNpZmljIG5lZWRzLjxici8+PGJyLz48YnIvPjxkaXY+UmVnYXJkczxici8+ QmVqb3kgS1M8YnIvPjxici8+U2VudCBmcm9tIGhhbmRoZWxkLCBwbGVhc2UgZXhjdXNlIHR5cG9z LjwvZGl2Pjxoci8+PGRpdj48Yj5Gcm9tOiA8L2I+ICZsdDtyaWNoaW4uamFpbkBub2tpYS5jb20m Z3Q7DQo8L2Rpdj48ZGl2PjxiPkRhdGU6IDwvYj5XZWQsIDI3IEp1biAyMDEyIDE1OjQ3OjU0ICsw MDAwPC9kaXY+PGRpdj48Yj5UbzogPC9iPiZsdDt1c2VyQGhpdmUuYXBhY2hlLm9yZyZndDs8L2Rp dj48ZGl2PjxiPlJlcGx5VG86IDwvYj4gdXNlckBoaXZlLmFwYWNoZS5vcmcNCjwvZGl2PjxkaXY+ PGI+U3ViamVjdDogPC9iPk9idmlvdXMgYW5kIG5vdCBzbyBvYnZpb3VzIHF1ZXJ5IG9wdGltemF0 aW9ucyBpbiBIaXZlPC9kaXY+PGRpdj48YnIvPjwvZGl2Pg0KPGRpdiBjbGFzcz0iV29yZFNlY3Rp b24xIj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPkhleSBIaXZlcnMsPG86cD48L286cD48L3A+DQo8 cCBjbGFzcz0iTXNvTm9ybWFsIj48bzpwPiZuYnNwOzwvbzpwPjwvcD4NCjxwIGNsYXNzPSJNc29O b3JtYWwiPkkgYW0gdHJ5aW5nIHRvIHVuZGVyc3RhbmQgd2hhdCBhcmUgc29tZSBvZiB0aGUgb2J2 aW91cyBhbmQgbm90IHNvIG9idmlvdXMgb3B0aW1pemF0aW9uIEkgY291bGQgZG8gZm9yIGEgSGl2 ZSBRdWVyeSBvbiBBV1MgRU1SIGNsdXN0ZXIuIEkga25vdyB0aGUgYW5zd2VyIGZvciBzb21lIG9m IHRoZXNlIHF1ZXN0aW9ucyBidXQgd2FudCB0byBrbm93IHdoYXQgZG8geW91IGd1eXMgdGhpbmsg YW5kIGJ5IHdoYXQgZmFjdG9yDQogaXQgYWZmZWN0cyB0aGUgcGVyZm9ybWFuY2Ugb3ZlciB0aGUg b3RoZXIgYXBwcm9hY2guPG86cD48L286cD48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48bzpw PiZuYnNwOzwvbzpwPjwvcD4NCjxwIGNsYXNzPSJNc29MaXN0UGFyYWdyYXBoIiBzdHlsZT0idGV4 dC1pbmRlbnQ6LS4yNWluO21zby1saXN0OmwwIGxldmVsMSBsZm8xIj48IVtpZiAhc3VwcG9ydExp c3RzXT48c3BhbiBzdHlsZT0ibXNvLWxpc3Q6SWdub3JlIj4xLjxzcGFuIHN0eWxlPSJmb250Ojcu MHB0ICZxdW90O1RpbWVzIE5ldyBSb21hbiZxdW90OyI+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7DQo8L3NwYW4+PC9zcGFuPjwhW2VuZGlmXT5IYXZpbmcgbXkgZXh0ZXJuYWwg dGFibGUgZGF0YSBnemlwcGVkIGFuZCByZWFkaW5nIGl0IGluIHRoZSB0YWJsZSB2L3Mgbm8gY29t cHJlc3Npb24gYXQgYWxsLjxvOnA+PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb0xpc3RQYXJhZ3Jh cGgiIHN0eWxlPSJ0ZXh0LWluZGVudDotLjI1aW47bXNvLWxpc3Q6bDAgbGV2ZWwxIGxmbzEiPjwh W2lmICFzdXBwb3J0TGlzdHNdPjxzcGFuIHN0eWxlPSJtc28tbGlzdDpJZ25vcmUiPjIuPHNwYW4g c3R5bGU9ImZvbnQ6Ny4wcHQgJnF1b3Q7VGltZXMgTmV3IFJvbWFuJnF1b3Q7Ij4mbmJzcDsmbmJz cDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsNCjwvc3Bhbj48L3NwYW4+PCFbZW5kaWZdPkhhdmlu ZyB0aGUgZXh0ZXJuYWwgdGFibGUgZGF0YSBvbiBTMyB2L3MgaGF2aW5nIGl0IG9uIEhERlM/PG86 cD48L286cD48L3A+DQo8cCBjbGFzcz0iTXNvTGlzdFBhcmFncmFwaCIgc3R5bGU9InRleHQtaW5k ZW50Oi0uMjVpbjttc28tbGlzdDpsMCBsZXZlbDEgbGZvMSI+PCFbaWYgIXN1cHBvcnRMaXN0c10+ PHNwYW4gc3R5bGU9Im1zby1saXN0Oklnbm9yZSI+My48c3BhbiBzdHlsZT0iZm9udDo3LjBwdCAm cXVvdDtUaW1lcyBOZXcgUm9tYW4mcXVvdDsiPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw OyZuYnNwOw0KPC9zcGFuPjwvc3Bhbj48IVtlbmRpZl0+Q3JlYXRpbmcgaW50ZXJtZWRpYXRlIGV4 dGVybmFsIHRhYmxlcyB2L3Mgbm9uIGV4dGVybmFsIHRhYmxlcyB2L3MgY3JlYXRpbmcgdmlld3M/ PG86cD48L286cD48L3A+DQo8cCBjbGFzcz0iTXNvTGlzdFBhcmFncmFwaCIgc3R5bGU9InRleHQt aW5kZW50Oi0uMjVpbjttc28tbGlzdDpsMCBsZXZlbDEgbGZvMSI+PCFbaWYgIXN1cHBvcnRMaXN0 c10+PHNwYW4gc3R5bGU9Im1zby1saXN0Oklnbm9yZSI+NC48c3BhbiBzdHlsZT0iZm9udDo3LjBw dCAmcXVvdDtUaW1lcyBOZXcgUm9tYW4mcXVvdDsiPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu YnNwOyZuYnNwOw0KPC9zcGFuPjwvc3Bhbj48IVtlbmRpZl0+U3RvcmluZyB0aGUgZXh0ZXJuYWwg dGFibGUgYXMgVGV4dGZpbGUgdi9zIFNlcXVlbmNlIGZpbGUuIEkga25vdyBzZXF1ZW5jZSBmaWxl IGNvbXByZXNzZXMgdGhlIGRhdGEsIGJ1dCBpbiB3aGF0IGZvcm1hdD8gSSByZWFkIGFib3V0IFJD IGZpbGVzIGFuZCBob3cgZWZmaWNpZW50IHRoZXkgYXJlLCBob3cgdG8gdXNlIHRoZW0/PG86cD48 L286cD48L3A+DQo8cCBjbGFzcz0iTXNvTGlzdFBhcmFncmFwaCIgc3R5bGU9InRleHQtaW5kZW50 Oi0uMjVpbjttc28tbGlzdDpsMCBsZXZlbDEgbGZvMSI+PCFbaWYgIXN1cHBvcnRMaXN0c10+PHNw YW4gc3R5bGU9Im1zby1saXN0Oklnbm9yZSI+NS48c3BhbiBzdHlsZT0iZm9udDo3LjBwdCAmcXVv dDtUaW1lcyBOZXcgUm9tYW4mcXVvdDsiPiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu YnNwOw0KPC9zcGFuPjwvc3Bhbj48IVtlbmRpZl0+SG93IGFyZSBudW1iZXIgb2YgcmVkdWNlcnMg Z2V0IHNldCBmb3IgYSBIaXZlIHF1ZXJ5IChUaGUgd2F5IGdyb3VwIGJ5IGFuZCBvcmRlciBieSBz ZXRzIHRoZSBudW1iZXIgb2YgcmVkdWNlcnMgdG8gMSkgPyBJZiBJIGFtIG5vdCBjaGFuZ2luZyBp dCBleHBsaWNpdGx5IGRvZXMgaXQgcGljayBpdCBmcm9tIHRoZSB1bmRlcmx5aW5nIEhhZG9vcCBj bHVzdGVyPyBJIGFtIHRyeWluZyB0byB1bmRlcnN0YW5kIHRoZQ0KIGJvdHRsZW5lY2sgYmV0d2Vl biBxdWVyeSBhbmQgY2x1c3RlciBzaXplLjxvOnA+PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb0xp c3RQYXJhZ3JhcGgiIHN0eWxlPSJ0ZXh0LWluZGVudDotLjI1aW47bXNvLWxpc3Q6bDAgbGV2ZWwx IGxmbzEiPjwhW2lmICFzdXBwb3J0TGlzdHNdPjxzcGFuIHN0eWxlPSJtc28tbGlzdDpJZ25vcmUi PjYuPHNwYW4gc3R5bGU9ImZvbnQ6Ny4wcHQgJnF1b3Q7VGltZXMgTmV3IFJvbWFuJnF1b3Q7Ij4m bmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsNCjwvc3Bhbj48L3NwYW4+PCFbZW5k aWZdPkFueSBvdGhlciBvcHRpbWl6YXRpb25zLyBiZXN0IHByYWN0aWNlcz88bzpwPjwvbzpwPjwv cD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxvOnA+Jm5ic3A7PC9vOnA+PC9wPg0KPHAgY2xhc3M9 Ik1zb05vcm1hbCI+VGhhbmtzIGEgbG90IGluIGFkdmFuY2UuPG86cD48L286cD48L3A+DQo8cCBj bGFzcz0iTXNvTm9ybWFsIj5SaWNoaW48bzpwPjwvbzpwPjwvcD4NCjwvZGl2Pg0KPC9ib2R5Pg0K PC9odG1sPg0KDQo= --part4553-boundary-910530327-561674954--