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 0F347993D for ; Thu, 27 Oct 2011 18:19:43 +0000 (UTC) Received: (qmail 82285 invoked by uid 500); 27 Oct 2011 18:19:42 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 82247 invoked by uid 500); 27 Oct 2011 18:19: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 82239 invoked by uid 99); 27 Oct 2011 18:19:42 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Oct 2011 18:19:42 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of mark.sunderlin@teamaol.com designates 205.188.105.145 as permitted sender) Received: from [205.188.105.145] (HELO imr-da03.mx.aol.com) (205.188.105.145) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 27 Oct 2011 18:19:36 +0000 Received: from AOLDTCMEI31.ad.aol.aoltw.net (aoldtcmei31.office.aol.com [10.180.121.109]) by imr-da03.mx.aol.com (8.14.1/8.14.1) with ESMTP id p9RIIxWT024399 for ; Thu, 27 Oct 2011 14:18:59 -0400 Received: from AOLDTCMES31.ad.aol.aoltw.net ([169.254.8.230]) by AOLDTCMEI31.ad.aol.aoltw.net ([10.180.121.108]) with mapi id 14.01.0289.001; Thu, 27 Oct 2011 14:18:59 -0400 From: "Sunderlin, Mark" To: "'user@hive.apache.org'" Subject: RE: Question on regexp_extract() , Index? Thread-Topic: Question on regexp_extract() , Index? Thread-Index: AcyU0dgxjj1dUG9UTDe0rM4OhKaM5QAI0tKAAAg0O3A= Date: Thu, 27 Oct 2011 18:18:58 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [172.17.8.193] Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org QWgsIGVhc3kgZW5vdWdoISAgQW5kIGlmIHlvdSBoYXZlIG5vIGdyb3VwcywgeW91IGp1c3Qgd2Fu dCB0aGUgbWF0Y2gsIGl0IHNlZW1zIGluZGV4IG9mIDAgd29ya3MganVzdCBmaW5lLg0KDQpzZWxl Y3QgcmVnZXhwX2V4dHJhY3QoJ2p1bms6dGV4dDp1YTEyMycsJ3VhWzAtOV0rJywwKSBmcm9tIGR1 YWwgLS0gYXNzdW1lcyB5b3UgaGF2ZSBjcmVhdGVkIGEgZHVtbXkgaGl2ZSB0YWJsZSBjYWxsZWQg ZHVhbA0KdWExMjMNCg0KDQotLS0NCk1hcmsgRS4gU3VuZGVybGluDQpTb2x1dGlvbnMgQXJjaGl0 ZWN0IHxBT0wgRGF0YSBXYXJlaG91c2UNClA6IDcwMy0yNTYtNjkzNSB8IEM6IDU0MC0zMjctNjIy Mg0KQUlNOiBNRVN1bmRlcmxpbg0KMjIwMDAgQU9MIFdheSB8IER1bGxlcywgVkEgfCAyMDE2Ng0K DQoNCi0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQpGcm9tOiBNYXJrIEdyb3ZlciBbbWFpbHRv Om1ncm92ZXJAb2FuZGEuY29tXSANClNlbnQ6IFRodXJzZGF5LCBPY3RvYmVyIDI3LCAyMDExIDI6 MTAgUE0NClRvOiB1c2VyQGhpdmUuYXBhY2hlLm9yZw0KU3ViamVjdDogUmU6IFF1ZXN0aW9uIG9u IHJlZ2V4cF9leHRyYWN0KCkgLCBJbmRleD8NCg0KTWFyaywNCkl0IHNwZWNpZmllcyB0aGUgZ3Jv dXAgdGhhdCB5b3Ugd2FudCB0byBiZSBleHRyYWN0IGFmdGVyIHRoZSBSZWdleCBoYXMgYmVlbiBt YXRjaGVkLiBHcm91cCBudW1iZXJzIGFyZSAxLXJlZmVyZW5jZWQuIEluIHRoZSBleGFtcGxlIHlv dSBnYXZlLCB0aGUgZmlyc3QgZ3JvdXAgY29ycmVzcG9uZHMgdG8gInRoZSIsIHRoZSBzZWNvbmQg Z3JvdXAgY29ycmVzcG9uZHMgdG8gImJhciIuIEEgZ3JvdXAgaW4gUmVnZXggaXMgc3BlY2lmaWVk IGJ5IGEgcGFpciBvZiBwYXJlbnRoZXNpcy4NCg0KWW91IGNhbiBhbHNvIGxvb2sgYXQgdGhlIHNv dXJjZSBjb2RlIHRvIGdhaW4gZnVydGhlciB1bmRlcnN0YW5kaW5nLg0KaHR0cDovL3d3dy5qYXZh c291cmNlY29kZS5vcmcvaHRtbC9vcGVuLXNvdXJjZS9oaXZlL2hpdmUtMC43LjEvb3JnL2FwYWNo ZS9oYWRvb3AvaGl2ZS9xbC91ZGYvVURGUmVnRXhwRXh0cmFjdC5qYXZhLmh0bWwNCg0KTWF0Y2hl ciBpcyB0aGUgQVBJIHRoYXQgaXMgdXNlZCB0byBtYXRjaCB0aGUgUmVnZXguIE1vcmUgb24gdGhh dCBhdDoNCmh0dHA6Ly9kb3dubG9hZC5vcmFjbGUuY29tL2phdmFzZS8xLjQuMi9kb2NzL2FwaS9q YXZhL3V0aWwvcmVnZXgvTWF0Y2hlci5odG1sDQoNCk1hcmsNCg0KLS0tLS0gT3JpZ2luYWwgTWVz c2FnZSAtLS0tLQ0KRnJvbTogIk1hcmsgU3VuZGVybGluIiA8bWFyay5zdW5kZXJsaW5AdGVhbWFv bC5jb20+DQpUbzogInVzZXJAaGl2ZS5hcGFjaGUub3JnIiA8dXNlckBoaXZlLmFwYWNoZS5vcmc+ DQpTZW50OiBUaHVyc2RheSwgT2N0b2JlciAyNywgMjAxMSAxOjU3OjA4IFBNDQpTdWJqZWN0OiBR dWVzdGlvbiBvbiByZWdleHBfZXh0cmFjdCgpICwgSW5kZXg/DQoNCkkndmUgYmVlbiB3b3JraW5n IHdpdGggdGhlIGhpdmUgcmVnZXhwX2V4dHJhY3Qoc3RyaW5nIHN1YmplY3QsIHN0cmluZyBwYXR0 ZXJuLCBpbnQgaW5kZXgpIGNvbW1hbmQuICBJbiB0aGUgaGl2ZSBsYW5ndWFnZSBtYW51YWwsIGh0 dHBzOi8vY3dpa2kuYXBhY2hlLm9yZy9jb25mbHVlbmNlL2Rpc3BsYXkvSGl2ZS9MYW5ndWFnZU1h bnVhbCtVREYjTGFuZ3VhZ2VNYW51YWxVREYtU3RyaW5nRnVuY3Rpb25zLCB0aGUgZm9sbG93aW5n IGRlc2NyaXB0aW9uIGZvciB0aGlzIGZ1bmN0aW9uIGlzIGdpdmVuOg0KDQpSZXR1cm5zIHRoZSBz dHJpbmcgZXh0cmFjdGVkIHVzaW5nIHRoZSBwYXR0ZXJuLiBlLmcuIHJlZ2V4cF9leHRyYWN0KCdm b290aGViYXInLCAnZm9vKC4qPykoYmFyKScsIDIpIHJldHVybnMgJ2Jhci4nIE5vdGUgdGhhdCBz b21lIGNhcmUgaXMgbmVjZXNzYXJ5IGluIHVzaW5nIHByZWRlZmluZWQgY2hhcmFjdGVyIGNsYXNz ZXM6IHVzaW5nICdccycgYXMgdGhlIHNlY29uZCBhcmd1bWVudCB3aWxsIG1hdGNoIHRoZSBsZXR0 ZXIgczsgJw0KcycgaXMgbmVjZXNzYXJ5IHRvIG1hdGNoIHdoaXRlc3BhY2UsIGV0Yy4gVGhlICdp bmRleCcgcGFyYW1ldGVyIGlzIHRoZSBKYXZhIHJlZ2V4IE1hdGNoZXIgZ3JvdXAoKSBtZXRob2Qg aW5kZXguIFNlZSBkb2NzL2FwaS9qYXZhL3V0aWwvcmVnZXgvTWF0Y2hlci5odG1sIGZvciBtb3Jl IGluZm9ybWF0aW9uIG9uIHRoZSAnaW5kZXgnIG9yIEphdmEgcmVnZXggZ3JvdXAoKSBtZXRob2Qu DQoNCkkgdHJpZWQgZG9pbmcgc29tZSBiYXNpYyB3ZWIgc2VhcmNoZXMgYW5kIGNhbm5vdCBmaW5k IHdoYXQgSSBzZWVrLCB1bmRlcnN0YW5kaW5nIG9mIHdoYXQgdGhlIEluZGV4IHZhbHVlIGluIHRo ZSByZWdleHAoKSBjYWxsIGRvZXMuIA0KDQpXaGVyZSBleGFjdGx5IGlzIHRoZSBpbmZvcm1hdGlv biBsaXN0ZWQgYXMsICJTZWUgZG9jcy9hcGkvamF2YS91dGlsL3JlZ2V4L01hdGNoZXIuaHRtbD8i ICBJcyBpdCBvbmxpbmUgc29tZXdoZXJlPw0KDQoNCi0tLQ0KTWFyayBFLiBTdW5kZXJsaW4NClNv bHV0aW9ucyBBcmNoaXRlY3QgfEFPTCBEYXRhIFdhcmVob3VzZQ0KUDogNzAzLTI1Ni02OTM1IHwg QzogNTQwLTMyNy02MjIyDQpBSU06IE1FU3VuZGVybGluDQoyMjAwMCBBT0wgV2F5IHwgRHVsbGVz LCBWQSB8IDIwMTY2DQoNCg0K