You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by prakash sejwani <pr...@gmail.com> on 2010/02/27 14:00:46 UTC
Re: WELCOME to hive-user@hadoop.apache.org
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, <hi...@hadoop.apache.org> 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:
> <hi...@hadoop.apache.org>
>
> To remove your address from the list, send a message to:
> <hi...@hadoop.apache.org>
>
> Send mail to the following for info and FAQ for this list:
> <hi...@hadoop.apache.org>
> <hi...@hadoop.apache.org>
>
> Similar addresses exist for the digest list:
> <hi...@hadoop.apache.org>
> <hi...@hadoop.apache.org>
>
> To get messages 123 through 145 (a maximum of 100 per request), mail:
> <hi...@hadoop.apache.org>
>
> To get an index with subject and author for messages 123-456 , mail:
> <hi...@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:
> <hi...@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 '=' instead of '@') after the command word:
> <hi...@hadoop.apache.org>
>
> To stop subscription for this address, mail:
> <hi...@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: <pr...@gmail.com>
> 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 <hive-user-sc.1267273308.dkponcgifphnohagkoen-prakashsejwani=
> 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: <12...@hadoop.apache.org>
> References: <12...@hadoop.apache.org>
> Date: Sat, 27 Feb 2010 18:25:00 +0530
> Message-ID: <71...@mail.gmail.com>
> Subject: Re: confirm subscribe to hive-user@hadoop.apache.org
> From: prakash sejwani <pr...@gmail.com>
> 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, <hi...@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
> >
> > 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
> > <hi...@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:
> > <hi...@hadoop.apache.org>
> >
> > To remove your address from the list, send a message to:
> > <hi...@hadoop.apache.org>
> >
> > Send mail to the following for info and FAQ for this list:
> > <hi...@hadoop.apache.org>
> > <hi...@hadoop.apache.org>
> >
> > Similar addresses exist for the digest list:
> > <hi...@hadoop.apache.org>
> > <hi...@hadoop.apache.org>
> >
> > To get messages 123 through 145 (a maximum of 100 per request), mail:
> > <hi...@hadoop.apache.org>
> >
> > To get an index with subject and author for messages 123-456 , mail:
> > <hi...@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:
> > <hi...@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 '=' instead of '@') after the command word:
> > <hi...@hadoop.apache.org>
> >
> > To stop subscription for this address, mail:
> > <hi...@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: <pr...@gmail.com>
> > 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 <hi...@hadoop.apache.org>; 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 <pr...@gmail.com>
> > 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
> >
> > <br>
> >
> > --0016e647eb4abf9c350480940ddd--
> >
>
> --005045013bff18cb4404809486db
> Content-Type: text/html; charset=ISO-8859-1
> Content-Transfer-Encoding: quoted-printable
>
> ok done<br><br><div class=3D"gmail_quote">On Sat, Feb 27, 2010 at 5:51 PM,
> =
> <span dir=3D"ltr"><<a href=3D"mailto:hive-user-help@hadoop.apache.org
> ">=
> hive-user-help@hadoop.apache.org</a>></span> wrote:<br><blockquote
> 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<br>
> <a href=3D"mailto:hive-user@hadoop.apache.org">hive-user@hadoop.apache.org
> <=
> /a> mailing list.<br>
> <br>
> To confirm that you would like<br>
> <br>
> =A0 <a href=3D"mailto:prakashsejwani@gmail.com">prakashsejwani@gmail.com
> </=
> a><br>
> <br>
> added to the hive-user mailing list, please send<br>
> a short reply to this address:<br>
> <br>
> =A0 hive-user-sc.1267273308.dkponcgifphnohagkoen-prakashsejwani=3D<a href=
> =3D"http://gmail.com" target=3D"_blank">gmail.com</a>@<a href=3D"
> http://had=
> oop.apache.org" target=3D"_blank">hadoop.apache.org</a><br>
> <br>
> Usually, this happens when you just hit the "reply" button.<br>
> If this does not work, simply copy the address and paste it into<br>
> the "To:" field of a new message.<br>
> <br>
> This confirmation serves two purposes. First, it verifies that I am
> able<br=
> >
> to get mail through to you. Second, it protects you in case someone<br>
> forges a subscription request in your name.<br>
> <br>
> Some mail programs are broken and cannot handle long addresses. If you<br>
> cannot reply to this request, instead send a message to<br>
> <<a href=3D"mailto:hive-user-request@hadoop.apache.org
> ">hive-user-reques=
> t@hadoop.apache.org</a>> and put the<br>
> entire address listed above into the "Subject:" 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 <<a href=3D"mailto:hive-user-subscribe@hadoop.apache.org
> ">hive-user=
> -subscribe@hadoop.apache.org</a>><br>
> <br>
> To remove your address from the list, send a message to:<br>
> =A0 <<a href=3D"mailto:hive-user-unsubscribe@hadoop.apache.org
> ">hive-us=
> er-unsubscribe@hadoop.apache.org</a>><br>
> <br>
> Send mail to the following for info and FAQ for this list:<br>
> =A0 <<a href=3D"mailto:hive-user-info@hadoop.apache.org
> ">hive-user-info=
> @hadoop.apache.org</a>><br>
> =A0 <<a href=3D"mailto:hive-user-faq@hadoop.apache.org
> ">hive-user-faq@h=
> adoop.apache.org</a>><br>
> <br>
> Similar addresses exist for the digest list:<br>
> =A0 <<a href=3D"mailto:hive-user-digest-subscribe@hadoop.apache.org
> ">hi=
> ve-user-digest-subscribe@hadoop.apache.org</a>><br>
> =A0 <<a href=3D"mailto:hive-user-digest-unsubscribe@hadoop.apache.org
> ">=
> hive-user-digest-unsubscribe@hadoop.apache.org</a>><br>
> <br>
> To get messages 123 through 145 (a maximum of 100 per request), mail:<br>
> =A0 <<a href=3D"mailto:hive-user-get.123_145@hadoop.apache.org
> ">hive-us=
> er-get.123_145@hadoop.apache.org</a>><br>
> <br>
> To get an index with subject and author for messages 123-456 , mail:<br>
> =A0 <<a href=3D"mailto:hive-user-index.123_456@hadoop.apache.org
> ">hive-=
> user-index.123_456@hadoop.apache.org</a>><br>
> <br>
> They are always returned as sets of 100, max 2000 per request,<br>
> so you'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 <<a href=3D"mailto:hive-user-thread.12345@hadoop.apache.org
> ">hive-u=
> ser-thread.12345@hadoop.apache.org</a>><br>
> <br>
> The messages should contain one line or word of text to avoid being<br>
> 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 "john@host.domain", just add a hyphen and your<br>
> address (with '=3D' instead of '@') after the command
> word:=
> <br>
> <hive-user-subscribe-john=3D<a href=3D"mailto:
> host.domain@hadoop.apache.=
> org">host.domain@hadoop.apache.org</a>><br>
> <br>
> To stop subscription for this address, mail:<br>
> <hive-user-unsubscribe-john=3D<a href=3D"mailto:
> host.domain@hadoop.apach=
> e.org">host.domain@hadoop.apache.org</a>><br>
> <br>
> In both cases, I'll send a confirmation message to that address.
> When<b=
> 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=3D"mailto:hive-user-owner@hadoop.apache.org
> ">hive-user-owner@hadoop=
> .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: <<a href=3D"mailto:prakashsejwani@gmail.com
> ">prakashsejwani=
> @gmail.com</a>><br>
> Received: (qmail 69157 invoked by uid 99); 27 Feb 2010 12:21:48 -0000<br>
> Received: from <a href=3D"http://athena.apache.org"
> target=3D"_blank">athen=
> a.apache.org</a> (HELO <a href=3D"http://athena.apache.org"
> target=3D"_blan=
> k">athena.apache.org</a>) (140.211.11.136)<br>
> =A0 =A0by <a href=3D"http://apache.org" target=3D"_blank">apache.org</a>
> (=
> qpsmtpd/0.29) with ESMTP; Sat, 27 Feb 2010 12:21:48 +0000<br>
> X-ASF-Spam-Status: No, hits=3D0.2 required=3D10.0<br>
> =A0 =A0 =A0 =A0tests=3DASF_LIST_OPS,HTML_MESSAGE,SPF_PASS<br>
> X-Spam-Check-By: <a href=3D"http://apache.org" target=3D"_blank">
> apache.org=
> </a><br>
> Received-SPF: pass (<a href=3D"http://athena.apache.org"
> target=3D"_blank">=
> athena.apache.org</a>: domain of <a href=3D"mailto:
> prakashsejwani@gmail.com=
> ">prakashsejwani@gmail.com</a> designates 209.85.223.172 as permitted
> sende=
> r)<br>
>
> Received: from [209.85.223.172] (HELO <a href=3D"http://mail-iw0-f172.googl
> =
> e.com" target=3D"_blank">mail-iw0-f172.google.com</a>)
> (209.85.223.172)<br>
> =A0 =A0by <a href=3D"http://apache.org" target=3D"_blank">apache.org</a>
> (=
> qpsmtpd/0.29) with ESMTP; Sat, 27 Feb 2010 12:21:41 +0000<br>
> Received: by iwn2 with SMTP id 2so1091863iwn.29<br>
> =A0 =A0 =A0 =A0for <<a href=3D"mailto:
> hive-user-subscribe@hadoop.apache=
> .org">hive-user-subscribe@hadoop.apache.org</a>>; Sat, 27 Feb 2010
> 04:21=
> :21 -0800 (PST)<br>
> DKIM-Signature: v=3D1; a=3Drsa-sha256; c=3Drelaxed/relaxed;<br>
> =A0 =A0 =A0 =A0d=3D<a href=3D"http://gmail.com" target=3D"_blank">
> gmail.co=
> m</a>; s=3Dgamma;<br>
> =A0 =A0 =A0
> =A0h=3Ddomainkey-signature:mime-version:received:date:message-=
> id:subject<br>
> =A0 =A0 =A0 =A0 :from:to:content-type;<br>
> =A0 =A0 =A0 =A0bh=3DEpnHLkIq9khsBWrr/vjvmS8Zp5RvRxsRzavEh5ANi3M=3D;<br>
> =A0 =A0 =A0
> =A0b=3DhMfL3ypwU5QODNmh+nywtZ2x97Jj6YF6WrnBe4dM1Mghi1twyyuhX82=
> WvsHLsPhDUs<br>
> =A0 =A0 =A0 =A0
> TbBANuKdLYArXYzSGM/A1YyXz5Ewkq5ZlVTLEAPo6WrnLLs2NVYQ5QngCU=
> tsCXJsDDZ8<br>
> =A0 =A0 =A0 =A0 twPhGNQd6ttiQ4kI0yQPdB4lztVFStR8Wn9Ns=3D<br>
> DomainKey-Signature: a=3Drsa-sha1; c=3Dnofws;<br>
> =A0 =A0 =A0 =A0d=3D<a href=3D"http://gmail.com" target=3D"_blank">
> gmail.co=
> m</a>; s=3Dgamma;<br>
> =A0 =A0 =A0
> =A0h=3Dmime-version:date:message-id:subject:from:to:content-ty=
> pe;<br>
> =A0 =A0 =A0
> =A0b=3DMkRP9pCTS/oRy3KvT0wLUBzeOO1BY8FsDRvO5bbIlqplNzWQN36VsLh=
> WRkSQ7YZsZC<br>
> =A0 =A0 =A0 =A0
> V+X8P3LpbddLBfVqb4BvWlSLb3XbN5aN59e4u74MtsUOxTkkbPwsHX1GQD=
> F7+ryeAdNQ<br>
> =A0 =A0 =A0 =A0 PgKG6ELdUmw9gu6DuXSmga53gThDtPrM3FpLI=3D<br>
> MIME-Version: 1.0<br>
> Received: by 10.231.146.211 with SMTP id i19mr267587ibv.22.1267273281018;
> S=
> at,<br>
> =A0 =A0 =A0 =A027 Feb 2010 04:21:21 -0800 (PST)<br>
> Date: Sat, 27 Feb 2010 17:51:20 +0530<br>
> Message-ID: <<a href=3D"mailto:
> 714b94041002270421y1a7b0392y27bbb7f6cf669=
> 8e0@mail.gmail.com
> ">714b94041002270421y1a7b0392y27bbb7f6cf6698e0@mail.gmail=
> .com</a>><br>
> Subject: using hive getting some problems<br>
> From: prakash sejwani <<a href=3D"mailto:prakashsejwani@gmail.com
> ">praka=
> shsejwani@gmail.com</a>><br>
> To: <a href=3D"mailto:hive-user-subscribe@hadoop.apache.org
> ">hive-user-subs=
> cribe@hadoop.apache.org</a><br>
> Content-Type: multipart/alternative;
> boundary=3D0016e647eb4abf9c350480940dd=
> d<br>
> <br>
> --0016e647eb4abf9c350480940ddd<br>
> Content-Type: text/plain; charset=3DISO-8859-1<br>
> <br>
> <br>
> <br>
> --0016e647eb4abf9c350480940ddd<br>
> Content-Type: text/html; charset=3DISO-8859-1<br>
> <br>
> <br><br>
> <br>
> --0016e647eb4abf9c350480940ddd--<br>
> </blockquote></div><br>
>
> --005045013bff18cb4404809486db--
>