Return-Path: Delivered-To: apmail-hadoop-hive-user-archive@minotaur.apache.org Received: (qmail 59683 invoked from network); 27 Feb 2010 13:01:13 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 27 Feb 2010 13:01:13 -0000 Received: (qmail 98079 invoked by uid 500); 27 Feb 2010 13:01:12 -0000 Delivered-To: apmail-hadoop-hive-user-archive@hadoop.apache.org Received: (qmail 98054 invoked by uid 500); 27 Feb 2010 13:01:12 -0000 Mailing-List: contact hive-user-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-user@hadoop.apache.org Delivered-To: mailing list hive-user@hadoop.apache.org Received: (qmail 98046 invoked by uid 99); 27 Feb 2010 13:01:12 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 27 Feb 2010 13:01:12 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of prakashsejwani@gmail.com designates 209.85.223.172 as permitted sender) Received: from [209.85.223.172] (HELO mail-iw0-f172.google.com) (209.85.223.172) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 27 Feb 2010 13:01:07 +0000 Received: by iwn2 with SMTP id 2so1110636iwn.29 for ; Sat, 27 Feb 2010 05:00:46 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type; bh=yK9T2933TvtcCjenqJVPzIFnzJjy9Evi5ar78z0elVI=; b=YzR+q5FDF/6b/4piwdnVyzcizjxTcDCiqo+nHJL53xXIWoBgZGKpkCLHz5TAfQuCUH djUfdtpmAvDXwk+XFaK5XpuuFQZzpNzC3qbpozTe5dhLr/j26FH+IGC7pA3fMf6kivBk c4l+61xNdQcn/q307UeIo6yWNjjS4pW2E+cIE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=H7LP/0nwGwiSCC3Lg1PrdX6r7rOc6kN9O9lYTUcG7DFbOtwwAwaEeiX+3sAJTer0Uy s7jwhf43bTN6uABEmmrnBOaghsB46UGk+7nv7D96ckbTuN+S3uJxqMbNCadf1GJU6ChW /ioKY62k31Tpz8cBU//MhHDbmHL/4GpfywavQ= MIME-Version: 1.0 Received: by 10.231.170.14 with SMTP id b14mr341231ibz.26.1267275646152; Sat, 27 Feb 2010 05:00:46 -0800 (PST) In-Reply-To: <1267275332.95354.ezmlm@hadoop.apache.org> References: <1267275332.95354.ezmlm@hadoop.apache.org> Date: Sat, 27 Feb 2010 18:30:46 +0530 Message-ID: <714b94041002270500s6465cedex1f821e28ddfcf9cd@mail.gmail.com> Subject: Re: WELCOME to hive-user@hadoop.apache.org From: prakash sejwani To: hive-user@hadoop.apache.org Content-Type: multipart/alternative; boundary=001636d34a9bb8b00f0480949a99 --001636d34a9bb8b00f0480949a99 Content-Type: text/plain; charset=ISO-8859-1 I am using hive and hadoop 0.20.0 When i create the table in hive i get the following below is the log $HIVE_HOME/bin/hive -hiveconf hive.root.logger=INFO,console Hive history file=/tmp/prakash/hive_job_log_prakash_201002271718_1967794083.txt 10/02/27 17:18:34 INFO exec.HiveHistory: Hive history file=/tmp/prakash/hive_job_log_prakash_201002271718_1967794083.txt hive> CREATE TABLE nginx_ref (foo INT, bar STRING); 10/02/27 17:18:37 INFO parse.ParseDriver: Parsing command: CREATE TABLE nginx_ref (foo INT, bar STRING) 10/02/27 17:18:37 INFO parse.ParseDriver: Parse Completed 10/02/27 17:18:37 INFO parse.SemanticAnalyzer: Starting Semantic Analysis 10/02/27 17:18:37 INFO parse.SemanticAnalyzer: Creating table nginx_ref position=14 10/02/27 17:18:37 INFO ql.Driver: Semantic Analysis Completed 10/02/27 17:18:37 INFO ql.Driver: Returning Hive schema: Schema(fieldSchemas:null, properties:null) 10/02/27 17:18:37 INFO ql.Driver: query plan = file:/tmp/prakash/hive_2010-02-27_17-18-37_564_4339795143228998991/queryplan.xml 10/02/27 17:18:38 INFO ql.Driver: Starting command: CREATE TABLE nginx_ref (foo INT, bar STRING) 10/02/27 17:18:38 INFO exec.DDLTask: Default to LazySimpleSerDe for table nginx_ref 10/02/27 17:18:38 INFO hive.log: DDL: struct nginx_ref { i32 foo, string bar} 10/02/27 17:18:38 INFO metastore.HiveMetaStore: 0: Opening raw store with implemenation class:org.apache.hadoop.hive.metastore.ObjectStore 10/02/27 17:18:38 INFO metastore.ObjectStore: ObjectStore, initialize called 10/02/27 17:18:38 ERROR DataNucleus.Plugin: Bundle "org.eclipse.jdt.core" requires "org.eclipse.core.resources" but it cannot be resolved. 10/02/27 17:18:38 ERROR DataNucleus.Plugin: Bundle "org.eclipse.jdt.core" requires "org.eclipse.core.runtime" but it cannot be resolved. 10/02/27 17:18:38 ERROR DataNucleus.Plugin: Bundle "org.eclipse.jdt.core" requires "org.eclipse.text" but it cannot be resolved. 10/02/27 17:18:42 INFO metastore.ObjectStore: Initialized ObjectStore 10/02/27 17:18:42 INFO metastore.HiveMetaStore: 0: create_table: db=default tbl=nginx_ref 10/02/27 17:18:42 INFO metastore.HiveMetaStore: 0: get_table : db=default tbl=nginx_ref 10/02/27 17:18:42 ERROR hive.log: Got exception: java.io.FileNotFoundException File file:/user/hive/warehouse/nginx_ref does not exist. 10/02/27 17:18:42 ERROR hive.log: java.io.FileNotFoundException: File file:/user/hive/warehouse/nginx_ref does not exist. at org.apache.hadoop.fs.RawLocalFileSystem.getFileStatus(RawLocalFileSystem.java:372) at org.apache.hadoop.fs.FilterFileSystem.getFileStatus(FilterFileSystem.java:251) at org.apache.hadoop.hive.metastore.Warehouse.mkdirs(Warehouse.java:124) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table(HiveMetaStore.java:340) at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:265) at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:320) at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:1391) at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:123) at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:107) at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:55) at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:630) at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:504) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:382) at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:138) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:197) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:303) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.hadoop.util.RunJar.main(RunJar.java:156) FAILED: Error in metadata: MetaException(message:Got exception: java.io.FileNotFoundException File file:/user/hive/warehouse/nginx_ref does not exist.) 10/02/27 17:18:42 ERROR exec.DDLTask: FAILED: Error in metadata: MetaException(message:Got exception: java.io.FileNotFoundException File file:/user/hive/warehouse/nginx_ref does not exist.) org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:Got exception: java.io.FileNotFoundException File file:/user/hive/warehouse/nginx_ref does not exist.) at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:326) at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:1391) at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:123) at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:107) at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:55) at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:630) at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:504) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:382) at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:138) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:197) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:303) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.hadoop.util.RunJar.main(RunJar.java:156) Caused by: MetaException(message:Got exception: java.io.FileNotFoundException File file:/user/hive/warehouse/nginx_ref does not exist.) at org.apache.hadoop.hive.metastore.MetaStoreUtils.logAndThrowMetaException(MetaStoreUtils.java:746) at org.apache.hadoop.hive.metastore.Warehouse.mkdirs(Warehouse.java:126) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table(HiveMetaStore.java:340) at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:265) at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:320) ... 15 more FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask 10/02/27 17:18:42 ERROR ql.Driver: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask hive> version > ; 10/02/27 17:29:44 INFO parse.ParseDriver: Parsing command: version FAILED: Parse Error: line 1:0 cannot recognize input 'version' 10/02/27 17:29:44 ERROR ql.Driver: FAILED: Parse Error: line 1:0 cannot recognize input 'version' org.apache.hadoop.hive.ql.parse.ParseException: line 1:0 cannot recognize input 'version' at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:401) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:299) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:377) at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:138) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:197) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:303) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.hadoop.util.RunJar.main(RunJar.java:156) kindly help with this i using ubuntu 9.10 (karmic) OS thanks prakash On Sat, Feb 27, 2010 at 6:25 PM, wrote: > Hi! This is the ezmlm program. I'm managing the > hive-user@hadoop.apache.org mailing list. > > Acknowledgment: I have added the address > > prakashsejwani@gmail.com > > to the hive-user mailing list. > > Welcome to hive-user@hadoop.apache.org! > > Please save this message so that you know the address you are > subscribed under, in case you later want to unsubscribe or change your > subscription address. > > > --- Administrative commands for the hive-user list --- > > I can handle administrative requests automatically. Please > do not send them to the list address! Instead, send > your message to the correct command address: > > To subscribe to the list, send a message to: > > > To remove your address from the list, send a message to: > > > Send mail to the following for info and FAQ for this list: > > > > Similar addresses exist for the digest list: > > > > To get messages 123 through 145 (a maximum of 100 per request), mail: > > > To get an index with subject and author for messages 123-456 , mail: > > > They are always returned as sets of 100, max 2000 per request, > so you'll actually get 100-499. > > To receive all messages with the same subject as message 12345, > send a short message to: > > > The messages should contain one line or word of text to avoid being > treated as sp@m, but I will ignore their content. > Only the ADDRESS you send to is important. > > You can start a subscription for an alternate address, > for example "john@host.domain", just add a hyphen and your > address (with '=' instead of '@') after the command word: > > > To stop subscription for this address, mail: > > > In both cases, I'll send a confirmation message to that address. When > you receive it, simply reply to it to complete your subscription. > > If despite following these instructions, you do not get the > desired results, please contact my owner at > hive-user-owner@hadoop.apache.org. Please be patient, my owner is a > lot slower than I am ;-) > > --- Enclosed is a copy of the request I received. > > Return-Path: > Received: (qmail 95349 invoked by uid 99); 27 Feb 2010 12:55:32 -0000 > Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) > by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 27 Feb 2010 12:55:32 > +0000 > X-ASF-Spam-Status: No, hits=2.2 required=10.0 > tests=HTML_MESSAGE,SPF_PASS > X-Spam-Check-By: apache.org > Received-SPF: pass (athena.apache.org: domain of prakashsejwani@gmail.comdesignates 209.85.223.172 as permitted sender) > Received: from [209.85.223.172] (HELO mail-iw0-f172.google.com) > (209.85.223.172) > by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 27 Feb 2010 12:55:26 > +0000 > Received: by iwn2 with SMTP id 2so1107812iwn.29 > for gmail.com@hadoop.apache.org>; Sat, 27 Feb 2010 04:55:05 -0800 (PST) > DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; > d=gmail.com; s=gamma; > h=domainkey-signature:mime-version:received:in-reply-to:references > :date:message-id:subject:from:to:content-type; > bh=L2KoRWZx9n8zV/HxGqKUd9q1pb1oVps0pb35f4NRBe8=; > b=ryg9t6sA4EBdK4C8I1i7z/QKBWV1G32UKszsH/sdBLg16AInmOa6AYPa41Q+C7AfVt > > 2antoC2FbDi6GcWOe7+/nTR5V6qXKWv4XmW1imaM2bslfZH3vXJ+zS1QafNGHR2XrTQo > Vpd1z6jnOv3beMbyPbHMObekaldx1fSgzo88M= > DomainKey-Signature: a=rsa-sha1; c=nofws; > d=gmail.com; s=gamma; > > h=mime-version:in-reply-to:references:date:message-id:subject:from:to > :content-type; > b=RBKD9bp3Ob7F7waSXvVuFf/cbc5BpniItpvvQuJGA97Gbnatv33a0ptzkMA1wz3sUX > > IE2DJrUG3QaSm6OqZce7JOlBpqszhh3zOXAkgwqdT0LAJNimhN4qqw/5dLaTof4nrF/N > 7+345Dx3A9t+8BSFOcs9XRRby9ImdRGZ5NFJE= > MIME-Version: 1.0 > Received: by 10.231.153.205 with SMTP id l13mr278268ibw.64.1267275300129; > Sat, > 27 Feb 2010 04:55:00 -0800 (PST) > In-Reply-To: <1267273308.69164.ezmlm@hadoop.apache.org> > References: <1267273308.69164.ezmlm@hadoop.apache.org> > Date: Sat, 27 Feb 2010 18:25:00 +0530 > Message-ID: <714b94041002270455i4efe393em3e61649a7ff4552b@mail.gmail.com> > Subject: Re: confirm subscribe to hive-user@hadoop.apache.org > From: prakash sejwani > To: hive-user-sc.1267273308.dkponcgifphnohagkoen-prakashsejwani=gmail.com@ > hadoop.apache.org > Content-Type: multipart/alternative; boundary=005045013bff18cb4404809486db > > --005045013bff18cb4404809486db > Content-Type: text/plain; charset=ISO-8859-1 > > ok done > > On Sat, Feb 27, 2010 at 5:51 PM, wrote: > > > Hi! This is the ezmlm program. I'm managing the > > hive-user@hadoop.apache.org mailing list. > > > > To confirm that you would like > > > > prakashsejwani@gmail.com > > > > added to the hive-user mailing list, please send > > a short reply to this address: > > > > hive-user-sc.1267273308.dkponcgifphnohagkoen-prakashsejwani=gmail.com@ > > hadoop.apache.org > > > > Usually, this happens when you just hit the "reply" button. > > If this does not work, simply copy the address and paste it into > > the "To:" field of a new message. > > > > This confirmation serves two purposes. First, it verifies that I am able > > to get mail through to you. Second, it protects you in case someone > > forges a subscription request in your name. > > > > Some mail programs are broken and cannot handle long addresses. If you > > cannot reply to this request, instead send a message to > > and put the > > entire address listed above into the "Subject:" line. > > > > > > --- Administrative commands for the hive-user list --- > > > > I can handle administrative requests automatically. Please > > do not send them to the list address! Instead, send > > your message to the correct command address: > > > > To subscribe to the list, send a message to: > > > > > > To remove your address from the list, send a message to: > > > > > > Send mail to the following for info and FAQ for this list: > > > > > > > > Similar addresses exist for the digest list: > > > > > > > > To get messages 123 through 145 (a maximum of 100 per request), mail: > > > > > > To get an index with subject and author for messages 123-456 , mail: > > > > > > They are always returned as sets of 100, max 2000 per request, > > so you'll actually get 100-499. > > > > To receive all messages with the same subject as message 12345, > > send a short message to: > > > > > > The messages should contain one line or word of text to avoid being > > treated as sp@m, but I will ignore their content. > > Only the ADDRESS you send to is important. > > > > You can start a subscription for an alternate address, > > for example "john@host.domain", just add a hyphen and your > > address (with '=' instead of '@') after the command word: > > > > > > To stop subscription for this address, mail: > > > > > > In both cases, I'll send a confirmation message to that address. When > > you receive it, simply reply to it to complete your subscription. > > > > If despite following these instructions, you do not get the > > desired results, please contact my owner at > > hive-user-owner@hadoop.apache.org. Please be patient, my owner is a > > lot slower than I am ;-) > > > > --- Enclosed is a copy of the request I received. > > > > Return-Path: > > Received: (qmail 69157 invoked by uid 99); 27 Feb 2010 12:21:48 -0000 > > Received: from athena.apache.org (HELO athena.apache.org) > (140.211.11.136) > > by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 27 Feb 2010 12:21:48 > > +0000 > > X-ASF-Spam-Status: No, hits=0.2 required=10.0 > > tests=ASF_LIST_OPS,HTML_MESSAGE,SPF_PASS > > X-Spam-Check-By: apache.org > > Received-SPF: pass (athena.apache.org: domain of > prakashsejwani@gmail.comdesignates 209.85.223.172 as permitted sender) > > Received: from [209.85.223.172] (HELO mail-iw0-f172.google.com) > > (209.85.223.172) > > by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 27 Feb 2010 12:21:41 > > +0000 > > Received: by iwn2 with SMTP id 2so1091863iwn.29 > > for ; Sat, 27 Feb 2010 > > 04:21:21 -0800 (PST) > > DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; > > d=gmail.com; s=gamma; > > > h=domainkey-signature:mime-version:received:date:message-id:subject > > :from:to:content-type; > > bh=EpnHLkIq9khsBWrr/vjvmS8Zp5RvRxsRzavEh5ANi3M=; > > > b=hMfL3ypwU5QODNmh+nywtZ2x97Jj6YF6WrnBe4dM1Mghi1twyyuhX82WvsHLsPhDUs > > > > TbBANuKdLYArXYzSGM/A1YyXz5Ewkq5ZlVTLEAPo6WrnLLs2NVYQ5QngCUtsCXJsDDZ8 > > twPhGNQd6ttiQ4kI0yQPdB4lztVFStR8Wn9Ns= > > DomainKey-Signature: a=rsa-sha1; c=nofws; > > d=gmail.com; s=gamma; > > h=mime-version:date:message-id:subject:from:to:content-type; > > > b=MkRP9pCTS/oRy3KvT0wLUBzeOO1BY8FsDRvO5bbIlqplNzWQN36VsLhWRkSQ7YZsZC > > > > V+X8P3LpbddLBfVqb4BvWlSLb3XbN5aN59e4u74MtsUOxTkkbPwsHX1GQDF7+ryeAdNQ > > PgKG6ELdUmw9gu6DuXSmga53gThDtPrM3FpLI= > > MIME-Version: 1.0 > > Received: by 10.231.146.211 with SMTP id i19mr267587ibv.22.1267273281018; > > Sat, > > 27 Feb 2010 04:21:21 -0800 (PST) > > Date: Sat, 27 Feb 2010 17:51:20 +0530 > > Message-ID: <714b94041002270421y1a7b0392y27bbb7f6cf6698e0@mail.gmail.com > > > > Subject: using hive getting some problems > > From: prakash sejwani > > To: hive-user-subscribe@hadoop.apache.org > > Content-Type: multipart/alternative; > boundary=0016e647eb4abf9c350480940ddd > > > > --0016e647eb4abf9c350480940ddd > > Content-Type: text/plain; charset=ISO-8859-1 > > > > > > > > --0016e647eb4abf9c350480940ddd > > Content-Type: text/html; charset=ISO-8859-1 > > > >
> > > > --0016e647eb4abf9c350480940ddd-- > > > > --005045013bff18cb4404809486db > Content-Type: text/html; charset=ISO-8859-1 > Content-Transfer-Encoding: quoted-printable > > ok done

On Sat, Feb 27, 2010 at 5:51 PM, > = > < ">= > hive-user-help@hadoop.apache.org> wrote:
class= > =3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, 204, 204); > margin= > : 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> > Hi! This is the ezmlm program. I'm managing the
> hive-user@hadoop.apache.org > <= > /a> mailing list.
>
> To confirm that you would like
>
> =A0 prakashsejwani@gmail.com > a>
>
> added to the hive-user mailing list, please send
> a short reply to this address:
>
> =A0 hive-user-sc.1267273308.dkponcgifphnohagkoen-prakashsejwani=3D =3D"http://gmail.com" target=3D"_blank">gmail.com@ http://had= > oop.apache.org" target=3D"_blank">hadoop.apache.org
>
> Usually, this happens when you just hit the "reply" button.
> If this does not work, simply copy the address and paste it into
> the "To:" field of a new message.
>
> This confirmation serves two purposes. First, it verifies that I am > able > > to get mail through to you. Second, it protects you in case someone
> forges a subscription request in your name.
>
> Some mail programs are broken and cannot handle long addresses. If you
> cannot reply to this request, instead send a message to
> < ">hive-user-reques= > t@hadoop.apache.org> and put the
> entire address listed above into the "Subject:" line.
>
>
> --- Administrative commands for the hive-user list ---
>
> I can handle administrative requests automatically. Please
> do not send them to the list address! Instead, send
> your message to the correct command address:
>
> To subscribe to the list, send a message to:
> =A0 < ">hive-user= > -subscribe@hadoop.apache.org>
>
> To remove your address from the list, send a message to:
> =A0 < ">hive-us= > er-unsubscribe@hadoop.apache.org>
>
> Send mail to the following for info and FAQ for this list:
> =A0 < ">hive-user-info= > @hadoop.apache.org>
> =A0 < ">hive-user-faq@h= > adoop.apache.org>
>
> Similar addresses exist for the digest list:
> =A0 < ">hi= > ve-user-digest-subscribe@hadoop.apache.org>
> =A0 < ">= > hive-user-digest-unsubscribe@hadoop.apache.org>
>
> To get messages 123 through 145 (a maximum of 100 per request), mail:
> =A0 < ">hive-us= > er-get.123_145@hadoop.apache.org>
>
> To get an index with subject and author for messages 123-456 , mail:
> =A0 < ">hive-= > user-index.123_456@hadoop.apache.org>
>
> They are always returned as sets of 100, max 2000 per request,
> so you'll actually get 100-499.
>
> To receive all messages with the same subject as message 12345,
> send a short message to:
> =A0 < ">hive-u= > ser-thread.12345@hadoop.apache.org>
>
> The messages should contain one line or word of text to avoid being
> treated as sp@m, but I will ignore their content.
> Only the ADDRESS you send to is important.
>
> You can start a subscription for an alternate address,
> for example "john@host.domain", just add a hyphen and your
> address (with '=3D' instead of '@') after the command > word:= >
> <hive-user-subscribe-john=3D host.domain@hadoop.apache.= > org">host.domain@hadoop.apache.org>
>
> To stop subscription for this address, mail:
> <hive-user-unsubscribe-john=3D host.domain@hadoop.apach= > e.org">host.domain@hadoop.apache.org>
>
> In both cases, I'll send a confirmation message to that address. > When r> > you receive it, simply reply to it to complete your subscription.
>
> If despite following these instructions, you do not get the
> desired results, please contact my owner at
> ">hive-user-owner@hadoop= > .apache.org. Please be patient, my owner is a
> lot slower than I am ;-)
>
> --- Enclosed is a copy of the request I received.
>
> Return-Path: < ">prakashsejwani= > @gmail.com>
> Received: (qmail 69157 invoked by uid 99); 27 Feb 2010 12:21:48 -0000
> Received: from target=3D"_blank">athen= > a.apache.org (HELO target=3D"_blan= > k">athena.apache.org) (140.211.11.136)
> =A0 =A0by apache.org > (= > qpsmtpd/0.29) with ESMTP; Sat, 27 Feb 2010 12:21:48 +0000
> X-ASF-Spam-Status: No, hits=3D0.2 required=3D10.0
> =A0 =A0 =A0 =A0tests=3DASF_LIST_OPS,HTML_MESSAGE,SPF_PASS
> X-Spam-Check-By: > apache.org= >
> Received-SPF: pass ( target=3D"_blank">= > athena.apache.org: domain of prakashsejwani@gmail.com= > ">prakashsejwani@gmail.com designates 209.85.223.172 as permitted > sende= > r)
> > Received: from [209.85.223.172] (HELO = > e.com" target=3D"_blank">mail-iw0-f172.google.com) > (209.85.223.172)
> =A0 =A0by apache.org > (= > qpsmtpd/0.29) with ESMTP; Sat, 27 Feb 2010 12:21:41 +0000
> Received: by iwn2 with SMTP id 2so1091863iwn.29
> =A0 =A0 =A0 =A0for < hive-user-subscribe@hadoop.apache= > .org">hive-user-subscribe@hadoop.apache.org>; Sat, 27 Feb 2010 > 04:21= > :21 -0800 (PST)
> DKIM-Signature: v=3D1; a=3Drsa-sha256; c=3Drelaxed/relaxed;
> =A0 =A0 =A0 =A0d=3D > gmail.co= > m; s=3Dgamma;
> =A0 =A0 =A0 > =A0h=3Ddomainkey-signature:mime-version:received:date:message-= > id:subject
> =A0 =A0 =A0 =A0 :from:to:content-type;
> =A0 =A0 =A0 =A0bh=3DEpnHLkIq9khsBWrr/vjvmS8Zp5RvRxsRzavEh5ANi3M=3D;
> =A0 =A0 =A0 > =A0b=3DhMfL3ypwU5QODNmh+nywtZ2x97Jj6YF6WrnBe4dM1Mghi1twyyuhX82= > WvsHLsPhDUs
> =A0 =A0 =A0 =A0 > TbBANuKdLYArXYzSGM/A1YyXz5Ewkq5ZlVTLEAPo6WrnLLs2NVYQ5QngCU= > tsCXJsDDZ8
> =A0 =A0 =A0 =A0 twPhGNQd6ttiQ4kI0yQPdB4lztVFStR8Wn9Ns=3D
> DomainKey-Signature: a=3Drsa-sha1; c=3Dnofws;
> =A0 =A0 =A0 =A0d=3D > gmail.co= > m; s=3Dgamma;
> =A0 =A0 =A0 > =A0h=3Dmime-version:date:message-id:subject:from:to:content-ty= > pe;
> =A0 =A0 =A0 > =A0b=3DMkRP9pCTS/oRy3KvT0wLUBzeOO1BY8FsDRvO5bbIlqplNzWQN36VsLh= > WRkSQ7YZsZC
> =A0 =A0 =A0 =A0 > V+X8P3LpbddLBfVqb4BvWlSLb3XbN5aN59e4u74MtsUOxTkkbPwsHX1GQD= > F7+ryeAdNQ
> =A0 =A0 =A0 =A0 PgKG6ELdUmw9gu6DuXSmga53gThDtPrM3FpLI=3D
> MIME-Version: 1.0
> Received: by 10.231.146.211 with SMTP id i19mr267587ibv.22.1267273281018; > S= > at,
> =A0 =A0 =A0 =A027 Feb 2010 04:21:21 -0800 (PST)
> Date: Sat, 27 Feb 2010 17:51:20 +0530
> Message-ID: < 714b94041002270421y1a7b0392y27bbb7f6cf669= > 8e0@mail.gmail.com > ">714b94041002270421y1a7b0392y27bbb7f6cf6698e0@mail.gmail= > .com>
> Subject: using hive getting some problems
> From: prakash sejwani < ">praka= > shsejwani@gmail.com>
> To: ">hive-user-subs= > cribe@hadoop.apache.org
> Content-Type: multipart/alternative; > boundary=3D0016e647eb4abf9c350480940dd= > d
>
> --0016e647eb4abf9c350480940ddd
> Content-Type: text/plain; charset=3DISO-8859-1
>
>
>
> --0016e647eb4abf9c350480940ddd
> Content-Type: text/html; charset=3DISO-8859-1
>
> <br>
>
> --0016e647eb4abf9c350480940ddd--
>

> > --005045013bff18cb4404809486db-- > --001636d34a9bb8b00f0480949a99 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable I am using hive and hadoop 0.20.0

When i create the table in hive i = get the following below is the log
$HIVE_HOME/bin/hive -hiveconf hive.ro= ot.logger=3DINFO,console
Hive history file=3D/tmp/prakash/hive_job_log_p= rakash_201002271718_1967794083.txt
10/02/27 17:18:34 INFO exec.HiveHistory: Hive history file=3D/tmp/prakash/h= ive_job_log_prakash_201002271718_1967794083.txt
hive>=A0 CREATE TABLE= nginx_ref (foo INT, bar STRING);
10/02/27 17:18:37 INFO parse.ParseDri= ver: Parsing command:=A0 CREATE TABLE nginx_ref (foo INT, bar STRING)
10/02/27 17:18:37 INFO parse.ParseDriver: Parse Completed
10/02/27 17:18= :37 INFO parse.SemanticAnalyzer: Starting Semantic Analysis
10/02/27 17:= 18:37 INFO parse.SemanticAnalyzer: Creating table nginx_ref position=3D14 10/02/27 17:18:37 INFO ql.Driver: Semantic Analysis Completed
10/02/27 1= 7:18:37 INFO ql.Driver: Returning Hive schema: Schema(fieldSchemas:null, pr= operties:null)
10/02/27 17:18:37 INFO ql.Driver: query plan =3D file:/tm= p/prakash/hive_2010-02-27_17-18-37_564_4339795143228998991/queryplan.xml 10/02/27 17:18:38 INFO ql.Driver: Starting command:=A0 CREATE TABLE nginx_r= ef (foo INT, bar STRING)
10/02/27 17:18:38 INFO exec.DDLTask: Default to= LazySimpleSerDe for table nginx_ref
10/02/27 17:18:38 INFO hive.log: DD= L: struct nginx_ref { i32 foo, string bar}
10/02/27 17:18:38 INFO metastore.HiveMetaStore: 0: Opening raw store with i= mplemenation class:org.apache.hadoop.hive.metastore.ObjectStore
10/02/27= 17:18:38 INFO metastore.ObjectStore: ObjectStore, initialize called
10/02/27 17:18:38 ERROR DataNucleus.Plugin: Bundle "org.eclipse.jdt.co= re" requires "org.eclipse.core.resources" but it cannot be r= esolved.
10/02/27 17:18:38 ERROR DataNucleus.Plugin: Bundle "org.ec= lipse.jdt.core" requires "org.eclipse.core.runtime" but it c= annot be resolved.
10/02/27 17:18:38 ERROR DataNucleus.Plugin: Bundle "org.eclipse.jdt.co= re" requires "org.eclipse.text" but it cannot be resolved.10/02/27 17:18:42 INFO metastore.ObjectStore: Initialized ObjectStore
10/02/27 17:18:42 INFO metastore.HiveMetaStore: 0: create_table: db=3Ddefau= lt tbl=3Dnginx_ref
10/02/27 17:18:42 INFO metastore.HiveMetaStore: 0: ge= t_table : db=3Ddefault tbl=3Dnginx_ref
10/02/27 17:18:42 ERROR hive.log:= Got exception: java.io.FileNotFoundException File file:/user/hive/warehous= e/nginx_ref does not exist.
10/02/27 17:18:42 ERROR hive.log: java.io.FileNotFoundException: File file:= /user/hive/warehouse/nginx_ref does not exist.
=A0=A0=A0 at org.apache.h= adoop.fs.RawLocalFileSystem.getFileStatus(RawLocalFileSystem.java:372)
= =A0=A0=A0 at org.apache.hadoop.fs.FilterFileSystem.getFileStatus(FilterFile= System.java:251)
=A0=A0=A0 at org.apache.hadoop.hive.metastore.Warehouse.mkdirs(Warehouse.ja= va:124)
=A0=A0=A0 at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSH= andler.create_table(HiveMetaStore.java:340)
=A0=A0=A0 at org.apache.hado= op.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:= 265)
=A0=A0=A0 at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:= 320)
=A0=A0=A0 at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDL= Task.java:1391)
=A0=A0=A0 at org.apache.hadoop.hive.ql.exec.DDLTask.exec= ute(DDLTask.java:123)
=A0=A0=A0 at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:107)=
=A0=A0=A0 at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(Ta= skRunner.java:55)
=A0=A0=A0 at org.apache.hadoop.hive.ql.Driver.launchTa= sk(Driver.java:630)
=A0=A0=A0 at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:504)
= =A0=A0=A0 at org.apache.hadoop.hive.ql.Driver.run(Driver.java:382)
=A0= =A0=A0 at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:13= 8)
=A0=A0=A0 at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriv= er.java:197)
=A0=A0=A0 at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:303)<= br>=A0=A0=A0 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)=
=A0=A0=A0 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAc= cessorImpl.java:39)
=A0=A0=A0 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth= odAccessorImpl.java:25)
=A0=A0=A0 at java.lang.reflect.Method.invoke(Met= hod.java:597)
=A0=A0=A0 at org.apache.hadoop.util.RunJar.main(RunJar.jav= a:156)

FAILED: Error in metadata: MetaException(message:Got exception: java.io.Fil= eNotFoundException File file:/user/hive/warehouse/nginx_ref does not exist.= )
10/02/27 17:18:42 ERROR exec.DDLTask: FAILED: Error in metadata: MetaE= xception(message:Got exception: java.io.FileNotFoundException File file:/us= er/hive/warehouse/nginx_ref does not exist.)
org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:Got= exception: java.io.FileNotFoundException File file:/user/hive/warehouse/ng= inx_ref does not exist.)
=A0=A0=A0 at org.apache.hadoop.hive.ql.metadata= .Hive.createTable(Hive.java:326)
=A0=A0=A0 at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.jav= a:1391)
=A0=A0=A0 at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLT= ask.java:123)
=A0=A0=A0 at org.apache.hadoop.hive.ql.exec.Task.executeTa= sk(Task.java:107)
=A0=A0=A0 at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRu= nner.java:55)
=A0=A0=A0 at org.apache.hadoop.hive.ql.Driver.launchTask(D= river.java:630)
=A0=A0=A0 at org.apache.hadoop.hive.ql.Driver.execute(Dr= iver.java:504)
=A0=A0=A0 at org.apache.hadoop.hive.ql.Driver.run(Driver.java:382)
=A0= =A0=A0 at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:13= 8)
=A0=A0=A0 at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriv= er.java:197)
=A0=A0=A0 at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:303)<= br>=A0=A0=A0 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)=
=A0=A0=A0 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAc= cessorImpl.java:39)
=A0=A0=A0 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMeth= odAccessorImpl.java:25)
=A0=A0=A0 at java.lang.reflect.Method.invoke(Met= hod.java:597)
=A0=A0=A0 at org.apache.hadoop.util.RunJar.main(RunJar.jav= a:156)
Caused by: MetaException(message:Got exception: java.io.FileNotFo= undException File file:/user/hive/warehouse/nginx_ref does not exist.)
=A0=A0=A0 at org.apache.hadoop.hive.metastore.MetaStoreUtils.logAndThrowMet= aException(MetaStoreUtils.java:746)
=A0=A0=A0 at org.apache.hadoop.hive.= metastore.Warehouse.mkdirs(Warehouse.java:126)
=A0=A0=A0 at org.apache.h= adoop.hive.metastore.HiveMetaStore$HMSHandler.create_table(HiveMetaStore.ja= va:340)
=A0=A0=A0 at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTab= le(HiveMetaStoreClient.java:265)
=A0=A0=A0 at org.apache.hadoop.hive.ql.= metadata.Hive.createTable(Hive.java:320)
=A0=A0=A0 ... 15 more

FA= ILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DD= LTask
10/02/27 17:18:42 ERROR ql.Driver: FAILED: Execution Error, return code 1 f= rom org.apache.hadoop.hive.ql.exec.DDLTask
hive> version
=A0=A0=A0= > ;
10/02/27 17:29:44 INFO parse.ParseDriver: Parsing command: versi= on

FAILED: Parse Error: line 1:0 cannot recognize input 'version'<= br>
10/02/27 17:29:44 ERROR ql.Driver: FAILED: Parse Error: line 1:0 can= not recognize input 'version'

org.apache.hadoop.hive.ql.pars= e.ParseException: line 1:0 cannot recognize input 'version'

=A0=A0=A0 at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDri= ver.java:401)
=A0=A0=A0 at org.apache.hadoop.hive.ql.Driver.compile(Driv= er.java:299)
=A0=A0=A0 at org.apache.hadoop.hive.ql.Driver.run(Driver.ja= va:377)
=A0=A0=A0 at org.apache.hadoop.hive.cli.CliDriver.processCmd(Cli= Driver.java:138)
=A0=A0=A0 at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.jav= a:197)
=A0=A0=A0 at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.= java:303)
=A0=A0=A0 at sun.reflect.NativeMethodAccessorImpl.invoke0(Nati= ve Method)
=A0=A0=A0 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccess= orImpl.java:39)
=A0=A0=A0 at sun.reflect.DelegatingMethodAccessorImpl.in= voke(DelegatingMethodAccessorImpl.java:25)
=A0=A0=A0 at java.lang.reflec= t.Method.invoke(Method.java:597)
=A0=A0=A0 at org.apache.hadoop.util.RunJar.main(RunJar.java:156)

kindly help with this i using ubuntu 9.10 (karmic) OS

thanks
pra= kash


On Sat, Feb 27, 2010 at 6:25 PM,= <hive-user-help@hadoop.apache.org> wrote:
Hi! This is the e= zmlm program. I'm managing the
hive-user@hadoop.apache.org<= /a> mailing list.

Acknowledgment: I have added the address

=A0 prakashsejwani@gmail.com

to the hive-user mailing list.

Welcome to hive-user@hadoop.= apache.org!

Please save this message so that you know the address you are
subscribed under, in case you later want to unsubscribe or change your
subscription address.


--- Administrative commands for the hive-user list ---

I can handle administrative requests automatically. Please
do not send them to the list address! Instead, send
your message to the correct command address:

To subscribe to the list, send a message to:
=A0 <hive-user= -subscribe@hadoop.apache.org>

To remove your address from the list, send a message to:
=A0 <hive-us= er-unsubscribe@hadoop.apache.org>

Send mail to the following for info and FAQ for this list:
=A0 <hive-user-info= @hadoop.apache.org>
=A0 <hive-user-faq@h= adoop.apache.org>

Similar addresses exist for the digest list:
=A0 <hi= ve-user-digest-subscribe@hadoop.apache.org>
=A0 <= hive-user-digest-unsubscribe@hadoop.apache.org>

To get messages 123 through 145 (a maximum of 100 per request), mail:
=A0 <hive-us= er-get.123_145@hadoop.apache.org>

To get an index with subject and author for messages 123-456 , mail:
=A0 <hive-= user-index.123_456@hadoop.apache.org>

They are always returned as sets of 100, max 2000 per request,
so you'll actually get 100-499.

To receive all messages with the same subject as message 12345,
send a short message to:
=A0 <hive-u= ser-thread.12345@hadoop.apache.org>

The messages should contain one line or word of text to avoid being
treated as sp@m, but I will ignore their content.
Only the ADDRESS you send to is important.

You can start a subscription for an alternate address,
for example "john@host.domain", just add a hyphen and your
address (with '=3D' instead of '@') after the command word:=
<hive-user-subscribe-john=3Dhost.domain@hadoop.apache.org>

To stop subscription for this address, mail:
<hive-user-unsubscribe-john=3Dhost.domain@hadoop.apache.org>

In both cases, I'll send a confirmation message to that address. When you receive it, simply reply to it to complete your subscription.

If despite following these instructions, you do not get the
desired results, please contact my owner at
hive-user-owner@hadoop= .apache.org. Please be patient, my owner is a
lot slower than I am ;-)

--- Enclosed is a copy of the request I received.

Return-Path: <prakashsejwani= @gmail.com>
Received: (qmail 95349 invoked by uid 99); 27 Feb 2010 12:55:32 -0000
Received: from athen= a.apache.org (HELO athena.apache.org) (140.211.11.136)
=A0 =A0by apache.org (= qpsmtpd/0.29) with ESMTP; Sat, 27 Feb 2010 12:55:32 +0000
X-ASF-Spam-Status: No, hits=3D2.2 required=3D10.0
=A0 =A0 =A0 =A0tests=3DHTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org=
Received-SPF: pass (= athena.apache.org: domain of prakashsejwani@gmail.com designates 209.85.223.172 as permitted sende= r)
Received: from [209.85.223.172] (HELO mail-iw0-f172.google.com) (209.85.223.172)
=A0 =A0by apache.org (= qpsmtpd/0.29) with ESMTP; Sat, 27 Feb 2010 12:55:26 +0000
Received: by iwn2 with SMTP id 2so1107812iwn.29
=A0 =A0 =A0 =A0for <hive-user-sc.1267273308.dkponcgifphnohagkoen-prakas= hsejwani=3Dgmail.com@hadoop.apache.org&g= t;; Sat, 27 Feb 2010 04:55:05 -0800 (PST)
DKIM-Signature: v=3D1; a=3Drsa-sha256; c=3Drelaxed/relaxed;
=A0 =A0 =A0 =A0d=3Dgmail.co= m; s=3Dgamma;
=A0 =A0 =A0 =A0h=3Ddomainkey-signature:mime-version:received:in-reply-to:r= eferences
=A0 =A0 =A0 =A0 :date:message-id:subject:from:to:content-type;
=A0 =A0 =A0 =A0bh=3DL2KoRWZx9n8zV/HxGqKUd9q1pb1oVps0pb35f4NRBe8=3D;
=A0 =A0 =A0 =A0b=3Dryg9t6sA4EBdK4C8I1i7z/QKBWV1G32UKszsH/sdBLg16AInmOa6AYP= a41Q+C7AfVt
=A0 =A0 =A0 =A0 2antoC2FbDi6GcWOe7+/nTR5V6qXKWv4XmW1imaM2bslfZH3vXJ+zS1Qaf= NGHR2XrTQo
=A0 =A0 =A0 =A0 Vpd1z6jnOv3beMbyPbHMObekaldx1fSgzo88M=3D
DomainKey-Signature: a=3Drsa-sha1; c=3Dnofws;
=A0 =A0 =A0 =A0d=3Dgmail.co= m; s=3Dgamma;
=A0 =A0 =A0 =A0h=3Dmime-version:in-reply-to:references:date:message-id:sub= ject:from:to
=A0 =A0 =A0 =A0 :content-type;
=A0 =A0 =A0 =A0b=3DRBKD9bp3Ob7F7waSXvVuFf/cbc5BpniItpvvQuJGA97Gbnatv33a0pt= zkMA1wz3sUX
=A0 =A0 =A0 =A0 IE2DJrUG3QaSm6OqZce7JOlBpqszhh3zOXAkgwqdT0LAJNimhN4qqw/5dL= aTof4nrF/N
=A0 =A0 =A0 =A0 7+345Dx3A9t+8BSFOcs9XRRby9ImdRGZ5NFJE=3D
MIME-Version: 1.0
Received: by 10.231.153.205 with SMTP id l13mr278268ibw.64.1267275300129; S= at,
=A0 =A0 =A0 =A027 Feb 2010 04:55:00 -0800 (PST)
In-Reply-To: <1267273308.69164.ezmlm@hadoop.apache.org>
References: <1267273308.69164.ezmlm@hadoop.apache.org>
Date: Sat, 27 Feb 2010 18:25:00 +0530
Message-ID: <714b94041002270455i4efe393em3e61649a7ff4552b@mail.gmail= .com>
Subject: Re: confirm subscribe to hive-user@hadoop.apache.org
From: prakash sejwani <praka= shsejwani@gmail.com>
To: hive-user-sc.1267273308.dkponcgifphnohagkoen-prakashsejwani=3Dgmail.com@hadoop.apache.org
Content-Type: multipart/alternative; boundary=3D005045013bff18cb4404809486d= b

--005045013bff18cb4404809486db
Content-Type: text/plain; charset=3DISO-8859-1

ok done

On Sat, Feb 27, 2010 at 5:51 PM, <hive-user-help@hadoop.apache.org> wrote:

> Hi! This is the ezmlm program. I'm managing the
> hive-user@hadoop.apache= .org mailing list.
>
> To confirm that you would like
>
> =A0 prakashsejwani@gmail.c= om
>
> added to the hive-user mailing list, please send
> a short reply to this address:
>
> =A0 hive-user-sc.1267273308.dkponcgifphnohagkoen-prakashsejwani=3Dgmail.com@
> hadoop.apache.o= rg
>
> Usually, this happens when you just hit the "reply" button.<= br> > If this does not work, simply copy the address and paste it into
> the "To:" field of a new message.
>
> This confirmation serves two purposes. First, it verifies that I am ab= le
> to get mail through to you. Second, it protects you in case someone > forges a subscription request in your name.
>
> Some mail programs are broken and cannot handle long addresses. If you=
> cannot reply to this request, instead send a message to
> <hive-user-r= equest@hadoop.apache.org> and put the
> entire address listed above into the "Subject:" line.
>
>
> --- Administrative commands for the hive-user list ---
>
> I can handle administrative requests automatically. Please
> do not send them to the list address! Instead, send
> your message to the correct command address:
>
> To subscribe to the list, send a message to:
> =A0 <hive-= user-subscribe@hadoop.apache.org>
>
> To remove your address from the list, send a message to:
> =A0 <hiv= e-user-unsubscribe@hadoop.apache.org>
>
> Send mail to the following for info and FAQ for this list:
> =A0 <hive-user-= info@hadoop.apache.org>
> =A0 <hive-user-f= aq@hadoop.apache.org>
>
> Similar addresses exist for the digest list:
> =A0 <hive-user-digest-subscribe@hadoop.apache.org>
> =A0 <hive-user-digest-unsubscribe@hadoop.apache.org>
>
> To get messages 123 through 145 (a maximum of 100 per request), mail:<= br> > =A0 <hiv= e-user-get.123_145@hadoop.apache.org>
>
> To get an index with subject and author for messages 123-456 , mail: > =A0 <h= ive-user-index.123_456@hadoop.apache.org>
>
> They are always returned as sets of 100, max 2000 per request,
> so you'll actually get 100-499.
>
> To receive all messages with the same subject as message 12345,
> send a short message to:
> =A0 <hi= ve-user-thread.12345@hadoop.apache.org>
>
> The messages should contain one line or word of text to avoid being > treated as sp@m, but I will ignore their content.
> Only the ADDRESS you send to is important.
>
> You can start a subscription for an alternate address,
> for example "john@host.domain", just add a hyphen and your > address (with '=3D' instead of '@') after the command = word:
> <hive-user-subscribe-john=3Dhost.domain@hadoop.apache.org>
>
> To stop subscription for this address, mail:
> <hive-user-unsubscribe-john=3Dhost.domain@hadoop.apache.org>
>
> In both cases, I'll send a confirmation message to that address. W= hen
> you receive it, simply reply to it to complete your subscription.
>
> If despite following these instructions, you do not get the
> desired results, please contact my owner at
> hive-user-owner@h= adoop.apache.org. Please be patient, my owner is a
> lot slower than I am ;-)
>
> --- Enclosed is a copy of the request I received.
>
> Return-Path: <prakashse= jwani@gmail.com>
> Received: (qmail 69157 invoked by uid 99); 27 Feb 2010 12:21:48 -0000<= br> > Received: from = athena.apache.org (HELO athena.apache.org) (140.211.11.136)
> =A0 =A0by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 27 Feb 2010 12:21:48
> +0000
> X-ASF-Spam-Status: No, hits=3D0.2 required=3D10.0
> =A0 =A0 =A0 =A0tests=3DASF_LIST_OPS,HTML_MESSAGE,SPF_PASS
> X-Spam-Check-By: apach= e.org
> Received-SPF: pass (athena.apache.org: domain of prakashsejwani@gmail.comdesignates 20= 9.85.223.172 as permitted sender)
> Received: from [209.85.223.172] (HELO mail-iw0-f172.google.com)
> (209.85.223.172)
> =A0 =A0by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 27 Feb 2010 12:21:41
> +0000
> Received: by iwn2 with SMTP id 2so1091863iwn.29
> =A0 =A0 =A0 =A0for <hive-user-subscribe@hadoop.apache.org>; Sat, 27 Feb 2010 > 04:21:21 -0800 (PST)
> DKIM-Signature: v=3D1; a=3Drsa-sha256; c=3Drelaxed/relaxed;
> =A0 =A0 =A0 =A0d=3Dgmai= l.com; s=3Dgamma;
> =A0 =A0 =A0 =A0h=3Ddomainkey-signature:mime-version:received:date:mess= age-id:subject
> =A0 =A0 =A0 =A0 :from:to:content-type;
> =A0 =A0 =A0 =A0bh=3DEpnHLkIq9khsBWrr/vjvmS8Zp5RvRxsRzavEh5ANi3M=3D; > =A0 =A0 =A0 =A0b=3DhMfL3ypwU5QODNmh+nywtZ2x97Jj6YF6WrnBe4dM1Mghi1twyyu= hX82WvsHLsPhDUs
>
> TbBANuKdLYArXYzSGM/A1YyXz5Ewkq5ZlVTLEAPo6WrnLLs2NVYQ5QngCUtsCXJsDDZ8 > =A0 =A0 =A0 =A0 twPhGNQd6ttiQ4kI0yQPdB4lztVFStR8Wn9Ns=3D
> DomainKey-Signature: a=3Drsa-sha1; c=3Dnofws;
> =A0 =A0 =A0 =A0d=3Dgmai= l.com; s=3Dgamma;
> =A0 =A0 =A0 =A0h=3Dmime-version:date:message-id:subject:from:to:conten= t-type;
> =A0 =A0 =A0 =A0b=3DMkRP9pCTS/oRy3KvT0wLUBzeOO1BY8FsDRvO5bbIlqplNzWQN36= VsLhWRkSQ7YZsZC
>
> V+X8P3LpbddLBfVqb4BvWlSLb3XbN5aN59e4u74MtsUOxTkkbPwsHX1GQDF7+ryeAdNQ > =A0 =A0 =A0 =A0 PgKG6ELdUmw9gu6DuXSmga53gThDtPrM3FpLI=3D
> MIME-Version: 1.0
> Received: by 10.231.146.211 with SMTP id i19mr267587ibv.22.12672732810= 18;
> Sat,
> =A0 =A0 =A0 =A027 Feb 2010 04:21:21 -0800 (PST)
> Date: Sat, 27 Feb 2010 17:51:20 +0530
> Message-ID: <714b94041002270421y1a7b0392y27bbb7f6cf6698e0@mail.= gmail.com>
> Subject: using hive getting some problems
> From: prakash sejwani <= prakashsejwani@gmail.com>
> To: hive-user= -subscribe@hadoop.apache.org
> Content-Type: multipart/alternative; boundary=3D0016e647eb4abf9c350480= 940ddd
>
> --0016e647eb4abf9c350480940ddd
> Content-Type: text/plain; charset=3DISO-8859-1
>
>
>
> --0016e647eb4abf9c350480940ddd
> Content-Type: text/html; charset=3DISO-8859-1
>
> <br>
>
> --0016e647eb4abf9c350480940ddd--
>

--005045013bff18cb4404809486db
Content-Type: text/html; charset=3DISO-8859-1
Content-Transfer-Encoding: quoted-printable

ok done<br><br><div class=3D3D"gmail_quote">On = Sat, Feb 27, 2010 at 5:51 PM, =3D
=A0<span dir=3D3D"ltr">&lt;<a href=3D3D"mailto:= hive-user-help@hadoop.a= pache.org">=3D
hive-user-help@hadoop.a= pache.org</a>&gt;</span> wrote:<br><blockquote= class=3D
=3D3D"gmail_quote" style=3D3D"border-left: 1px solid rgb(204= , 204, 204); margin=3D
: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi! This is the ezmlm program. I&#39;m managing the<br>
<a href=3D3D"mailto:= hive-user@hadoop.apache.org">hive-user@hadoop.apache.org<=3D
/a> mailing list.<br>
<br>
To confirm that you would like<br>
<br>
=A0=3DA0 <a href=3D3D"mailto:prakashsejwani@gmail.com">prakashsejwani@gmail.com</=3D
a><br>
<br>
added to the hive-user mailing list, please send<br>
a short reply to this address:<br>
<br>
=A0=3DA0 hive-user-sc.1267273308.dkponcgifphnohagkoen-prakashsejwani=3D3D&l= t;a href=3D
=3D3D"http://gmail.com<= /a>" target=3D3D"_blank">gmail.com</a>@<a href=3D3D"http://had=3D
oop.apache.org"= ; target=3D3D"_blank">hadoop.apache.org</a><br>
<br>
Usually, this happens when you just hit the &quot;reply&quot; butto= n.<br>
If this does not work, simply copy the address and paste it into<br><= br> the &quot;To:&quot; field of a new message.<br>
<br>
This confirmation serves two purposes. First, it verifies that I am able<= ;br=3D
>
to get mail through to you. Second, it protects you in case someone<br&g= t;
forges a subscription request in your name.<br>
<br>
Some mail programs are broken and cannot handle long addresses. If you<b= r>
cannot reply to this request, instead send a message to<br>
&lt;<a href=3D3D"mailto:hive-user-request@hadoop.apache.org">hive-user-= reques=3D
t@hadoop.apache.org</a>&am= p;gt; and put the<br>
entire address listed above into the &quot;Subject:&quot; line.<= br>
<br>
<br>
--- Administrative commands for the hive-user list ---<br>
<br>
I can handle administrative requests automatically. Please<br>
do not send them to the list address! Instead, send<br>
your message to the correct command address:<br>
<br>
To subscribe to the list, send a message to:<br>
=A0=3DA0 &lt;<a href=3D3D"mailto:hive-user-subscribe@hadoop.apache.org"&= gt;hive-user=3D
-subscribe@hadoop.apache.org= </a>&gt;<br>
<br>
To remove your address from the list, send a message to:<br>
=A0=3DA0 &lt;<a href=3D3D"mailto:hive-user-unsubscribe@hadoop.apache.org&qu= ot;>hive-us=3D
er-unsubscribe@hadoop.a= pache.org</a>&gt;<br>
<br>
Send mail to the following for info and FAQ for this list:<br>
=A0=3DA0 &lt;<a href=3D3D"mailto:hive-user-info@hadoop.apache.org">hive-us= er-info=3D
@hadoop.apache.org</a>&gt;<br>
=A0=3DA0 &lt;<a href=3D3D"mailto:hive-user-faq@hadoop.apache.org">hive-user= -faq@h=3D
adoop.apache.org&= lt;/a>&gt;<br>
<br>
Similar addresses exist for the digest list:<br>
=A0=3DA0 &lt;<a href=3D3D"mailto:hive-user-digest-subscribe@hadoop.apache.= org">hi=3D
ve-user-diges= t-subscribe@hadoop.apache.org</a>&gt;<br>
=A0=3DA0 &lt;<a href=3D3D"mailto:hive-user-digest-unsubscribe@hadoop.apa= che.org">=3D
hive-user= -digest-unsubscribe@hadoop.apache.org</a>&gt;<br>
<br>
To get messages 123 through 145 (a maximum of 100 per request), mail:<br= >
=A0=3DA0 &lt;<a href=3D3D"mailto:hive-user-get.123_145@hadoop.apache.org&qu= ot;>hive-us=3D
er-get.123_145@hadoop.a= pache.org</a>&gt;<br>
<br>
To get an index with subject and author for messages 123-456 , mail:<br&= gt;
=A0=3DA0 &lt;<a href=3D3D"mailto:hive-user-index.123_456@hadoop.apache.org">hive-=3D
user-index.123_456@= hadoop.apache.org</a>&gt;<br>
<br>
They are always returned as sets of 100, max 2000 per request,<br> so you&#39;ll actually get 100-499.<br>
<br>
To receive all messages with the same subject as message 12345,<br> send a short message to:<br>
=A0=3DA0 &lt;<a href=3D3D"mailto:hive-user-thread.12345@hadoop.apache.org&= quot;>hive-u=3D
ser-thread.12345@hado= op.apache.org</a>&gt;<br>
<br>
The messages should contain one line or word of text to avoid being<br&g= t;
treated as sp@m, but I will ignore their content.<br>
Only the ADDRESS you send to is important.<br>
<br>
You can start a subscription for an alternate address,<br>
for example &quot;john@host.domain&quot;, just add a hyphen and you= r<br>
address (with &#39;=3D3D&#39; instead of &#39;@&#39;) after= the command word:=3D
<br>
&lt;hive-user-subscribe-john=3D3D<a href=3D3D"mailto:host.domain@hadoop.apache.=3D
org">host.domain@h= adoop.apache.org</a>&gt;<br>
<br>
To stop subscription for this address, mail:<br>
&lt;hive-user-unsubscribe-john=3D3D<a href=3D3D"mailto:host.domain@hadoop.apach=3D
e.org">host.domain@hadoop.apache.org</a= >&gt;<br>
<br>
In both cases, I&#39;ll send a confirmation message to that address. Wh= en<b=3D
r>
you receive it, simply reply to it to complete your subscription.<br>=
<br>
If despite following these instructions, you do not get the<br>
desired results, please contact my owner at<br>
<a href=3D3D"mailto:hive-user-owner@hadoop.apache.org">hive-user-owner@hadoop= =3D
.apache.org</a>. = Please be patient, my owner is a<br>
lot slower than I am ;-)<br>
<br>
--- Enclosed is a copy of the request I received.<br>
<br>
Return-Path: &lt;<a href=3D3D"mailto:prakashsejwani@gmail.com">prakashsejwani=3D @gmail.com</a>&= ;gt;<br>
Received: (qmail 69157 invoked by uid 99); 27 Feb 2010 12:21:48 -0000<br= >
Received: from <a href=3D3D"http://athena.apache.org" target=3D3D"_blank&= quot;>athen=3D
a.apache.org</a>= ; (HELO <a href=3D3D"http://athena.apache.org" target=3D3D"_blan=3D
k">athena.ap= ache.org</a>) (140.211.11.136)<br>
=A0=3DA0 =3DA0by <a href=3D3D"http://apache.org" target=3D3D"_blank">apache.org</a> (=3D=
qpsmtpd/0.29) with ESMTP; Sat, 27 Feb 2010 12:21:48 +0000<br>
X-ASF-Spam-Status: No, hits=3D3D0.2 required=3D3D10.0<br>
=A0=3DA0 =3DA0 =3DA0 =3DA0tests=3D3DASF_LIST_OPS,HTML_MESSAGE,SPF_PASS<b= r>
X-Spam-Check-By: <a href=3D3D"http://apache.org" target=3D3D"_blank">apache.org=3D
</a><br>
Received-SPF: pass (<a href=3D3D"http://athena.apache.org" target=3D3D"_b= lank">=3D
athena.apache.org</a>: domain of <a href=3D3D"mailto:prakashsejwani@gmail.com=3D
">prakashsejwani@gmail.= com</a> designates 209.85.223.172 as permitted sende=3D
r)<br>

Received: from [209.85.223.172] (HELO <a href=3D3D"http://mail-iw0-= f172.googl=3D
e.com" target=3D3D"= ;_blank">mail-iw0-f172.google.com</a>) (209.85.223.172)<br>
=A0=3DA0 =3DA0by <a href=3D3D"http://apache.org" target=3D3D"_blank">apache.org</a> (=3D=
qpsmtpd/0.29) with ESMTP; Sat, 27 Feb 2010 12:21:41 +0000<br>
Received: by iwn2 with SMTP id 2so1091863iwn.29<br>
=A0=3DA0 =3DA0 =3DA0 =3DA0for &lt;<a href=3D3D"mailto:hive-user-subscribe@hadoop.ap= ache=3D
.org">hive= -user-subscribe@hadoop.apache.org</a>&gt;; Sat, 27 Feb 2010 0= 4:21=3D
:21 -0800 (PST)<br>
DKIM-Signature: v=3D3D1; a=3D3Drsa-sha256; c=3D3Drelaxed/relaxed;<br>=
=A0=3DA0 =3DA0 =3DA0 =3DA0d=3D3D<a href=3D3D"http://gmail.com" target=3D3D"_blank= ">gmail.co=3D
m</a>; s=3D3Dgamma;<br>
=A0=3DA0 =3DA0 =3DA0 =3DA0h=3D3Ddomainkey-signature:mime-version:received:d= ate:message-=3D
id:subject<br>
=A0=3DA0 =3DA0 =3DA0 =3DA0 :from:to:content-type;<br>
=A0=3DA0 =3DA0 =3DA0 =3DA0bh=3D3DEpnHLkIq9khsBWrr/vjvmS8Zp5RvRxsRzavEh5ANi3= M=3D3D;<br>
=A0=3DA0 =3DA0 =3DA0 =3DA0b=3D3DhMfL3ypwU5QODNmh+nywtZ2x97Jj6YF6WrnBe4dM1Mg= hi1twyyuhX82=3D
WvsHLsPhDUs<br>
=A0=3DA0 =3DA0 =3DA0 =3DA0 TbBANuKdLYArXYzSGM/A1YyXz5Ewkq5ZlVTLEAPo6WrnLLs2= NVYQ5QngCU=3D
tsCXJsDDZ8<br>
=A0=3DA0 =3DA0 =3DA0 =3DA0 twPhGNQd6ttiQ4kI0yQPdB4lztVFStR8Wn9Ns=3D3D<br= >
DomainKey-Signature: a=3D3Drsa-sha1; c=3D3Dnofws;<br>
=A0=3DA0 =3DA0 =3DA0 =3DA0d=3D3D<a href=3D3D"http://gmail.com" target=3D3D"_blank= ">gmail.co=3D
m</a>; s=3D3Dgamma;<br>
=A0=3DA0 =3DA0 =3DA0 =3DA0h=3D3Dmime-version:date:message-id:subject:from:t= o:content-ty=3D
pe;<br>
=A0=3DA0 =3DA0 =3DA0 =3DA0b=3D3DMkRP9pCTS/oRy3KvT0wLUBzeOO1BY8FsDRvO5bbIlqp= lNzWQN36VsLh=3D
WRkSQ7YZsZC<br>
=A0=3DA0 =3DA0 =3DA0 =3DA0 V+X8P3LpbddLBfVqb4BvWlSLb3XbN5aN59e4u74MtsUOxTkk= bPwsHX1GQD=3D
F7+ryeAdNQ<br>
=A0=3DA0 =3DA0 =3DA0 =3DA0 PgKG6ELdUmw9gu6DuXSmga53gThDtPrM3FpLI=3D3D<br= >
MIME-Version: 1.0<br>
Received: by 10.231.146.211 with SMTP id i19mr267587ibv.22.1267273281018; S= =3D
at,<br>
=A0=3DA0 =3DA0 =3DA0 =3DA027 Feb 2010 04:21:21 -0800 (PST)<br>
Date: Sat, 27 Feb 2010 17:51:20 +0530<br>
Message-ID: &lt;<a href=3D3D"mailto:714b94041002270421y1a7b0392y27bbb7f6cf669= =3D
8e0@mail.gmail.com">714b9= 4041002270421y1a7b0392y27bbb7f6cf6698e0@mail.gmail=3D
.com</a>&gt;<br>
Subject: using hive getting some problems<br>
From: prakash sejwani &lt;<a href=3D3D"mailto:prakashsejwani@gmail.com">praka=3D shsejwani@gmail.com</a>&am= p;gt;<br>
To: <a href=3D3D"mailto:hive-user-subscribe@hadoop.apache.org">hive-user-= subs=3D
cribe@hadoop.apache.org</= a><br>
Content-Type: multipart/alternative; boundary=3D3D0016e647eb4abf9c350480940= dd=3D
d<br>
<br>
--0016e647eb4abf9c350480940ddd<br>
Content-Type: text/plain; charset=3D3DISO-8859-1<br>
<br>
<br>
<br>
--0016e647eb4abf9c350480940ddd<br>
Content-Type: text/html; charset=3D3DISO-8859-1<br>
<br>
&lt;br&gt;<br>
<br>
--0016e647eb4abf9c350480940ddd--<br>
</blockquote></div><br>

--005045013bff18cb4404809486db--

--001636d34a9bb8b00f0480949a99--