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 5ED62D962 for ; Wed, 25 Jul 2012 10:46:04 +0000 (UTC) Received: (qmail 31790 invoked by uid 500); 25 Jul 2012 10:46:03 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 31742 invoked by uid 500); 25 Jul 2012 10:46:03 -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 31710 invoked by uid 99); 25 Jul 2012 10:46:02 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Jul 2012 10:46:01 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=FSL_FREEMAIL_1,FSL_FREEMAIL_2,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.91.206] (HELO nm6-vm0.bullet.mail.sp2.yahoo.com) (98.139.91.206) by apache.org (qpsmtpd/0.29) with SMTP; Wed, 25 Jul 2012 10:45:54 +0000 Received: from [98.139.91.70] by nm6.bullet.mail.sp2.yahoo.com with NNFMP; 25 Jul 2012 10:45:33 -0000 Received: from [72.30.22.76] by tm10.bullet.mail.sp2.yahoo.com with NNFMP; 25 Jul 2012 10:45:32 -0000 Received: from [127.0.0.1] by omp1070.mail.sp2.yahoo.com with NNFMP; 25 Jul 2012 10:45:32 -0000 X-Yahoo-Newman-Id: 919429.13075.bm@omp1070.mail.sp2.yahoo.com Received: (qmail 45075 invoked from network); 25 Jul 2012 10:45:32 -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=XacSB8YoJtV1O8oApTGq1Sq/gUuD8K/Qu5Ha0wuFbi6/JoF66QrjRIvoK/CSXSnsrdF6bIPz5jFk1H5cvz419f8c3SNFss8G/BITcrPqug0tOAyIBqXkBtg3A92PniguGlnwZPOIa+iTGVOMShrfPxNLiAxgS3OOY9NuRAI1qhg= ; DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1343213132; bh=5pZLOvbqsDtWlOTJZdzpDXYa//rtNBjjGA59uSit5y8=; 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=seT9MRThnqq2KDSwW8OD846QUZvH95f4BShuKhf8VXeeXeuPifRM1/JPvgUOZXw+YKyRt5WSLYQHFCrDI3vzBvDDvBlC5Nk8T6RSZAe9+CZ40XcXaYg1P7nspxDjubDG8zXQFVvhO+X8XH3GUn0rNE0vY8uMhWU0YssZUWZBPno= X-Yahoo-Newman-Property: ymail-3 X-YMail-OSG: KmNmkVMVM1lOTq8xNKdZezuMlYifhLTD8TEjwwwAR.zbnGX 1dXz14ysWvcl_g1g5jIkrEdLeLe9_ufDMTdIdb1kqP77sAwvqa_Ab8ZiJ0id qwKC4ZGnXfw92c1gDF1qmZF5BM9WYJi2VK02ycy5LqmFF.2BCbRqv3AhsCk9 pNshlqaTBn43Mo4j4LJogx9IVJMqN2L1x.ySz063e2GJkalb6NGLpRIYwR.a dGqZqrWjwK35_O7x3mKArPnNRPbqlU_ZTeiofCsTca9ff.Wzsoiu8UX4UgZq RsJf.uYfgTLn40ls.LJbcyUUNJA1NGpuTwCLgj6HxEg4KbWPbZmM0_JuWhMQ VzPzORTkdDKwQ7RVGauKStGyOFU0m14G7U8kXxukFc3aS1Pitk30KIojrKtd SMXoWZ5ofZMupTzfYOimXpm47wtmC4zKWaEJ54tT9wNh34pS2V1oLpnZpCw- - X-Yahoo-SMTP: fUyZ91eswBBme0tpFWJ5iyHn6M7J Received: from b2.c15.bise7.blackberry (bejoy_ks@178.239.86.185 with xymcookie) by smtp116-mob.biz.mail.gq1.yahoo.com with SMTP; 25 Jul 2012 03:45:31 -0700 PDT X-rim-org-msg-ref-id: 2025986724 Message-ID: <2025986724-1343213127-cardhu_decombobulator_blackberry.rim.net-608421545-@b2.c15.bise7.blackberry> Reply-To: bejoy_ks@yahoo.com X-Priority: Normal References: In-Reply-To: Sensitivity: Normal Importance: Normal Subject: Re: Loading data into data_dim table To: user@hive.apache.org From: "Bejoy KS" Date: Wed, 25 Jul 2012 10:45:32 +0000 Content-Type: multipart/alternative; boundary="part2411-boundary-89633512-1069871818" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org --part2411-boundary-89633512-1069871818 Content-Transfer-Encoding: base64 Content-Type: text/plain; charset="Windows-1252" SGkgUHJhYmh1DQoNCkNhbiB5b3UgY2F0IHRoZSBmaWxlIGluIGhkZnMgYW5kIGVuc3VyZSB0aGF0 IHRoZSBmaWVsZHMgYXJlIGRlbGltaXRlZCBieSAnfCcgY2hhcmFjdGVyLg0KDQpoYWRvb3AgZnMg LXRleHQgdXNlci9oaXZlL3dhcmVob3VzZS9kaW1fZGF0ZS90aW1lLmNzdg0KIA0KUmVnYXJkcw0K QmVqb3kgS1MNCg0KU2VudCBmcm9tIGhhbmRoZWxkLCBwbGVhc2UgZXhjdXNlIHR5cG9zLg0KDQot LS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0tLQ0KRnJvbTogcHJhYmh1IGsgPHByYWJodS5oaXZlQGdt YWlsLmNvbT4NCkRhdGU6IFdlZCwgMjUgSnVsIDIwMTIgMTY6MDU6NDIgDQpUbzogPHVzZXJAaGl2 ZS5hcGFjaGUub3JnPg0KUmVwbHktVG86IHVzZXJAaGl2ZS5hcGFjaGUub3JnDQpTdWJqZWN0OiBM b2FkaW5nIGRhdGEgaW50byBkYXRhX2RpbSB0YWJsZQ0KDQpIaSBVc2VycywNCg0KDQpJIGhhdmUg Y3JlYXRlZCBkaW1fZGF0ZSB0YWJsZSBsaWtlIGJlbG93LiB0YWJsZSBjcmVhdGVkIHN1Y2Nlc3Nm dWxseSBhbmQgaQ0KdGhlbiBsb2FkIHRoZSBkYXRhIGludG8gdGhlIGRpbV9kYXRlIHRhYmxlDQoN CndoaWxlIGkgYW0gc2VsZWN0aW5nIHRoZSB0YWJsZSwgZ2V0dGluZyBudWxsIHZhbHVlcy5teSBp bnB1dCBmaWxlIGlzDQp0aW1lLmNzdiBmaWxlDQoNCmhpdmU+IGNyZWF0ZSB0YWJsZSBkaW1fZGF0 ZShEYXRlSWQgaW50LGRkYXRlIHN0cmluZyxZZWFyIGludCxRdWFydGVyDQppbnQsTW9udGhfTnVt YmVyX1llYXIgaW50LE1vbnRoX051bWJlcl9PZl9RdWFydGVyIGludCxXZWVrX051bWJlcl9PZl9Z ZWFyDQppbnQsV2Vla19OdW1iZXJfT2ZfUXVhcnRlciBpbnQsV2Vla19OdW1iZXJfT2ZfTW9udGgg aW50LERheV9OdW1iZXJfT2ZfWWVhcg0KaW50LERheV9OdW1iZXJfT2ZfUXVhcnRlciBpbnQsRGF5 X051bWJlcl9PZl9Nb250aCBpbnQsRGF5X051bWJlcl9PZl9XZWVrDQppbnQsTW9udGhfTmFtZSBz dHJpbmcsTW9udGhfTmFtZV9BYmJyZXZpYXRpb24gc3RyaW5nLERheV9OYW1lDQpzdHJpbmcsRGF5 X05hbWVfQWJicmV2aWF0aW9uIHN0cmluZylyb3cgZm9ybWF0IGRlbGltaXRlZCBmaWVsZHMgdGVy bWluYXRlZA0KYnkgJ3wnIHN0b3JlZCBhcyB0ZXh0ZmlsZTsNCk9LDQpUaW1lIHRha2VuOiAwLjEy MyBzZWNvbmRzDQoNCmhpdmU+IGxvYWQgZGF0YSBsb2NhbCBpbnBhdGggJy91c3IvbG9jYWwvdGlt ZS5jc3YnIG92ZXJ3cml0ZSBpbnRvIHRhYmxlDQpkaW1fZGF0ZTsNCkNvcHlpbmcgZGF0YSBmcm9t IGZpbGU6L3Vzci9sb2NhbC90aW1lLmNzdg0KQ29weWluZyBmaWxlOiBmaWxlOi91c3IvbG9jYWwv dGltZS5jc3YNCkxvYWRpbmcgZGF0YSB0byB0YWJsZSBkZWZhdWx0LmRpbV9kYXRlDQpEZWxldGVk IGhkZnM6Ly9tZC1hYWExOjU0MzEwL3VzZXIvaGl2ZS93YXJlaG91c2UvZGltX2RhdGUNCk9LDQpU aW1lIHRha2VuOiAwLjIzNCBzZWNvbmRzDQoNCmhpdmU+IHNlbGVjdCAqIGZyb20gZGltX2RhdGU7 DQpOVUxMICAgIE5VTEwgICAgTlVMTCAgICBOVUxMICAgIE5VTEwgICAgTlVMTCAgICBOVUxMICAg IE5VTEwgICAgTlVMTA0KTlVMTCAgICBOVUxMICAgIE5VTEwgICAgTlVMTCAgICBOVUxMICAgIE5V TEwgICAgTlVMTCAgICBOVUxMDQpOVUxMICAgIE5VTEwgICAgTlVMTCAgICBOVUxMICAgIE5VTEwg ICAgTlVMTCAgICBOVUxMICAgIE5VTEwgICAgTlVMTA0KTlVMTCAgICBOVUxMICAgIE5VTEwgICAg TlVMTCAgICBOVUxMICAgIE5VTEwgICAgTlVMTCAgICBOVUxMDQpOVUxMICAgIE5VTEwgICAgTlVM TCAgICBOVUxMICAgIE5VTEwgICAgTlVMTCAgICBOVUxMICAgIE5VTEwgICAgTlVMTA0KTlVMTCAg ICBOVUxMICAgIE5VTEwgICAgTlVMTCAgICBOVUxMICAgIE5VTEwgICAgTlVMTCAgICBOVUxMDQpO VUxMICAgIE5VTEwgICAgTlVMTCAgICBOVUxMICAgIE5VTEwgICAgTlVMTCAgICBOVUxMICAgIE5V TEwgICAgTlVMTA0KTlVMTCAgICBOVUxMICAgIE5VTEwgICAgTlVMTCAgICBOVUxMICAgIE5VTEwg ICAgTlVMTCAgICBOVUxMDQpOVUxMICAgIE5VTEwgICAgTlVMTCAgICBOVUxMICAgIE5VTEwgICAg TlVMTCAgICBOVUxMICAgIE5VTEwgICAgTlVMTA0KTlVMTCAgICBOVUxMICAgIE5VTEwgICAgTlVM TCAgICBOVUxMICAgIE5VTEwgICAgTlVMTCAgICBOVUxMDQpOVUxMICAgIE5VTEwgICAgTlVMTCAg ICBOVUxMICAgIE5VTEwgICAgTlVMTCAgICBOVUxMICAgIE5VTEwgICAgTlVMTA0KTlVMTCAgICBO VUxMICAgIE5VTEwgICAgTlVMTCAgICBOVUxMICAgIE5VTEwgICAgTlVMTCAgICBOVUxMDQpOVUxM ICAgIE5VTEwgICAgTlVMTCAgICBOVUxMICAgIE5VTEwgICAgTlVMTCAgICBOVUxMICAgIE5VTEwg ICAgTlVMTA0KTlVMTCAgICBOVUxMICAgIE5VTEwgICAgTlVMTCAgICBOVUxMICAgIE5VTEwgICAg TlVMTCAgICBOVUxMDQpQbGVhc2UgaGVscCBtZSBvbiB0aGlzIGlzc3VlLCBJIGhhdmUgbWlzc2Vk IGFueXRoaW5nIHdyb25nPw0KDQpUaGFua3MsDQpQcmFiaHUuDQoNCg== --part2411-boundary-89633512-1069871818 Content-Transfer-Encoding: base64 Content-Type: text/html; charset="Windows-1252" PCFET0NUWVBFIGh0bWwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBUcmFuc2l0aW9uYWwv L0VOIj48aHRtbD48aGVhZD48bWV0YSBjb250ZW50PSJ0ZXh0L2h0bWw7IGNoYXJzZXQ9dXRmLTgi IGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSI+PC9oZWFkPjxib2R5PkhpIFByYWJodTxici8+PGJy Lz5DYW4geW91IGNhdCB0aGUgZmlsZSBpbiBoZGZzIGFuZCBlbnN1cmUgdGhhdCB0aGUgZmllbGRz IGFyZSBkZWxpbWl0ZWQgYnkgJ3wnIGNoYXJhY3Rlci48YnIvPjxici8+aGFkb29wIGZzIC10ZXh0 IHVzZXIvaGl2ZS93YXJlaG91c2UvZGltX2RhdGUvdGltZS5jc3Y8YnIvPiA8ZGl2PlJlZ2FyZHM8 YnIvPkJlam95IEtTPGJyLz48YnIvPlNlbnQgZnJvbSBoYW5kaGVsZCwgcGxlYXNlIGV4Y3VzZSB0 eXBvcy48L2Rpdj48aHIvPjxkaXY+PGI+RnJvbTogPC9iPiBwcmFiaHUgayAmbHQ7cHJhYmh1Lmhp dmVAZ21haWwuY29tJmd0Ow0KPC9kaXY+PGRpdj48Yj5EYXRlOiA8L2I+V2VkLCAyNSBKdWwgMjAx MiAxNjowNTo0MiArMDUzMDwvZGl2PjxkaXY+PGI+VG86IDwvYj4mbHQ7dXNlckBoaXZlLmFwYWNo ZS5vcmcmZ3Q7PC9kaXY+PGRpdj48Yj5SZXBseVRvOiA8L2I+IHVzZXJAaGl2ZS5hcGFjaGUub3Jn DQo8L2Rpdj48ZGl2PjxiPlN1YmplY3Q6IDwvYj5Mb2FkaW5nIGRhdGEgaW50byBkYXRhX2RpbSB0 YWJsZTwvZGl2PjxkaXY+PGJyLz48L2Rpdj48cD5IaSBVc2Vycyw8L3A+DQo8cD48YnI+SSBoYXZl IGNyZWF0ZWQgZGltX2RhdGUgdGFibGUgbGlrZSBiZWxvdy4gdGFibGUgY3JlYXRlZCBzdWNjZXNz ZnVsbHkgYW5kIGkgdGhlbiBsb2FkIHRoZSBkYXRhIGludG8gdGhlIGRpbV9kYXRlIHRhYmxlPC9w Pg0KPHA+d2hpbGUgaSBhbSBzZWxlY3RpbmcgdGhlIHRhYmxlLCBnZXR0aW5nIG51bGwgdmFsdWVz Lm15IGlucHV0IGZpbGUgaXMgdGltZS5jc3YgZmlsZSA8L3A+DQo8cD5oaXZlJmd0OyBjcmVhdGUg dGFibGUgZGltX2RhdGUoRGF0ZUlkIGludCxkZGF0ZSBzdHJpbmcsWWVhciBpbnQsUXVhcnRlciBp bnQsTW9udGhfTnVtYmVyX1llYXIgaW50LE1vbnRoX051bWJlcl9PZl9RdWFydGVyIGludCxXZWVr X051bWJlcl9PZl9ZZWFyIGludCxXZWVrX051bWJlcl9PZl9RdWFydGVyIGludCxXZWVrX051bWJl cl9PZl9Nb250aCBpbnQsRGF5X051bWJlcl9PZl9ZZWFyIGludCxEYXlfTnVtYmVyX09mX1F1YXJ0 ZXIgaW50LERheV9OdW1iZXJfT2ZfTW9udGggaW50LERheV9OdW1iZXJfT2ZfV2VlayBpbnQsTW9u dGhfTmFtZSBzdHJpbmcsTW9udGhfTmFtZV9BYmJyZXZpYXRpb24gc3RyaW5nLERheV9OYW1lIHN0 cmluZyxEYXlfTmFtZV9BYmJyZXZpYXRpb24gc3RyaW5nKXJvdyBmb3JtYXQgZGVsaW1pdGVkIGZp ZWxkcyB0ZXJtaW5hdGVkIGJ5ICYjMzk7fCYjMzk7IHN0b3JlZCBhcyB0ZXh0ZmlsZTs8YnI+DQpP Szxicj5UaW1lIHRha2VuOiAwLjEyMyBzZWNvbmRzPC9wPg0KPGRpdj48YnI+aGl2ZSZndDsgbG9h ZCBkYXRhIGxvY2FsIGlucGF0aCAmIzM5Oy91c3IvbG9jYWwvdGltZS5jc3YmIzM5OyBvdmVyd3Jp dGUgaW50byB0YWJsZSBkaW1fZGF0ZTugPC9kaXY+DQo8ZGl2PkNvcHlpbmcgZGF0YSBmcm9tIGZp bGU6L3Vzci9sb2NhbC90aW1lLmNzdqA8L2Rpdj4NCjxkaXY+Q29weWluZyBmaWxlOiBmaWxlOi91 c3IvbG9jYWwvdGltZS5jc3Y8YnI+TG9hZGluZyBkYXRhIHRvIHRhYmxlIGRlZmF1bHQuZGltX2Rh dGU8YnI+RGVsZXRlZCBoZGZzOi8vbWQtYWFhMTo1NDMxMC91c2VyL2hpdmUvd2FyZWhvdXNlL2Rp bV9kYXRlPGJyPk9LPGJyPlRpbWUgdGFrZW46IDAuMjM0IHNlY29uZHM8L2Rpdj4NCjxwPmhpdmUm Z3Q7IHNlbGVjdCAqIGZyb20gZGltX2RhdGU7PGJyPk5VTEygoKAgTlVMTKCgoCBOVUxMoKCgIE5V TEygoKAgTlVMTKCgoCBOVUxMoKCgIE5VTEygoKAgTlVMTKCgoCBOVUxMoKCgIE5VTEygoKAgTlVM TKCgoCBOVUxMoKCgIE5VTEygoKAgTlVMTKCgoCBOVUxMoKCgIE5VTEygoKAgTlVMTDxicj5OVUxM oKCgIE5VTEygoKAgTlVMTKCgoCBOVUxMoKCgIE5VTEygoKAgTlVMTKCgoCBOVUxMoKCgIE5VTEyg oKAgTlVMTKCgoCBOVUxMoKCgIE5VTEygoKAgTlVMTKCgoCBOVUxMoKCgIE5VTEygoKAgTlVMTKCg oCBOVUxMoKCgIE5VTEw8YnI+DQpOVUxMoKCgIE5VTEygoKAgTlVMTKCgoCBOVUxMoKCgIE5VTEyg oKAgTlVMTKCgoCBOVUxMoKCgIE5VTEygoKAgTlVMTKCgoCBOVUxMoKCgIE5VTEygoKAgTlVMTKCg oCBOVUxMoKCgIE5VTEygoKAgTlVMTKCgoCBOVUxMoKCgIE5VTEw8YnI+TlVMTKCgoCBOVUxMoKCg IE5VTEygoKAgTlVMTKCgoCBOVUxMoKCgIE5VTEygoKAgTlVMTKCgoCBOVUxMoKCgIE5VTEygoKAg TlVMTKCgoCBOVUxMoKCgIE5VTEygoKAgTlVMTKCgoCBOVUxMoKCgIE5VTEygoKAgTlVMTKCgoCBO VUxMPGJyPg0KTlVMTKCgoCBOVUxMoKCgIE5VTEygoKAgTlVMTKCgoCBOVUxMoKCgIE5VTEygoKAg TlVMTKCgoCBOVUxMoKCgIE5VTEygoKAgTlVMTKCgoCBOVUxMoKCgIE5VTEygoKAgTlVMTKCgoCBO VUxMoKCgIE5VTEygoKAgTlVMTKCgoCBOVUxMPGJyPk5VTEygoKAgTlVMTKCgoCBOVUxMoKCgIE5V TEygoKAgTlVMTKCgoCBOVUxMoKCgIE5VTEygoKAgTlVMTKCgoCBOVUxMoKCgIE5VTEygoKAgTlVM TKCgoCBOVUxMoKCgIE5VTEygoKAgTlVMTKCgoCBOVUxMoKCgIE5VTEygoKAgTlVMTDxicj4NCk5V TEygoKAgTlVMTKCgoCBOVUxMoKCgIE5VTEygoKAgTlVMTKCgoCBOVUxMoKCgIE5VTEygoKAgTlVM TKCgoCBOVUxMoKCgIE5VTEygoKAgTlVMTKCgoCBOVUxMoKCgIE5VTEygoKAgTlVMTKCgoCBOVUxM oKCgIE5VTEygoKAgTlVMTDwvcD4NCjxkaXY+UGxlYXNlIGhlbHAgbWUgb24gdGhpcyBpc3N1ZSwg SSBoYXZlIG1pc3NlZCBhbnl0aGluZyB3cm9uZz8gPC9kaXY+DQo8ZGl2PqA8L2Rpdj4NCjxkaXY+ VGhhbmtzLDwvZGl2Pg0KPGRpdj5QcmFiaHUuPC9kaXY+DQoNCjwvYm9keT48L2h0bWw+ --part2411-boundary-89633512-1069871818--