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 8C5E6984D for ; Tue, 5 Jun 2012 17:34:17 +0000 (UTC) Received: (qmail 73659 invoked by uid 500); 5 Jun 2012 17:34:16 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 73609 invoked by uid 500); 5 Jun 2012 17:34:16 -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 73601 invoked by uid 99); 5 Jun 2012 17:34:16 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 05 Jun 2012 17:34:16 +0000 X-ASF-Spam-Status: No, hits=4.7 required=5.0 tests=FREEMAIL_FORGED_REPLYTO,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [98.138.90.69] (HELO nm6.bullet.mail.ne1.yahoo.com) (98.138.90.69) by apache.org (qpsmtpd/0.29) with SMTP; Tue, 05 Jun 2012 17:34:08 +0000 Received: from [98.138.90.56] by nm6.bullet.mail.ne1.yahoo.com with NNFMP; 05 Jun 2012 17:33:47 -0000 Received: from [98.138.89.193] by tm9.bullet.mail.ne1.yahoo.com with NNFMP; 05 Jun 2012 17:33:47 -0000 Received: from [127.0.0.1] by omp1051.mail.ne1.yahoo.com with NNFMP; 05 Jun 2012 17:33:47 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 962283.64707.bm@omp1051.mail.ne1.yahoo.com Received: (qmail 77805 invoked by uid 60001); 5 Jun 2012 17:33:47 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1338917627; bh=Ym1vW7zjt6tY/w92N+E8+X8D7ZrEWhEC0GQ+FvR54+Y=; h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=FN8uShiKVKILQwMygi0MhrJCo5mz55mbEPAPqXQHJJTKzsimQENg1UpX1UzSMulrJYplyoJdHM3uNT/Bbnl4iS2LGajF/0O0D5gfeDhw5H0klfvqgZxbh/7Q93VSKEefn+IY/ID9szaX2uoiwKn/5Z1x4Gf5N3Yzc66kdXvvLUY= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=fbu5YZCrjDQN+fizrYGLc7yX7FzKGR1W3uzXZFmb4XOFAfumDGh7wClLExurjji8oxVkYfYuCnYOpxfEGJhT512N6hrkZbmHhhnlQs/X43gdiM9GuvjVcVDe1ElhwMgyK0LqofUDFSa9pfyzcMe7RIDQK3akpOYaXe3ZcAfEHXE=; X-YMail-OSG: A4U7kLwVM1k5VAycED_XKpK5qzUYS6hAdu6LbvRWEonMStc SFbCeMxj8t50QUn42vwrsk751eqjlC3W.2wvJhLTxjWekd6IQOlFlviO2sge B60X0xJZjYohKObSD5XWaatU1kR.pKwxAnLIM8mHT7CglyXg7oMGxKWZUnff 8BaQ2_afjOKDXARTTmTDoSg9K3eGL7fxIttUeZMsWLwjcGHvU0sTuhHZHtW. rqfQYmp.70qNzcLhPPqI0VHN.hW4KotDgQ2mKabDGERTAsO4QS77dMePWc96 kpJzcBnx4k5em0uy.wsTJmXj2jWGA2t7VtVoJOX_OUBIkmx1OIfn8y3AfdhU cQbgnyw.ntc0gncnkcIJ9NDDmrqC5lLdHk7pzlcKs0P7hUwmiKLkr.4rhD_1 FTSAA2PPSeFcxVn.u97iMrdNJncsyLmuoNb.UWXY8mJNjOltYZ79p90sGyeU UBnJP.KVJG7h62mt9HFU71XT9IiaQk6kT3b9nBIwgNfTAztJQKkZ1Kz0oW0K M63hdqrMnBVVWoljz6sdSdwOpK4Xe Received: from [122.164.162.201] by web121205.mail.ne1.yahoo.com via HTTP; Tue, 05 Jun 2012 10:33:47 PDT X-Mailer: YahooMailWebService/0.8.118.349524 References: Message-ID: <1338917627.72412.YahooMailNeo@web121205.mail.ne1.yahoo.com> Date: Tue, 5 Jun 2012 10:33:47 -0700 (PDT) From: Bejoy Ks Reply-To: Bejoy Ks Subject: Re: Error while Creating Table in Hive To: "user@hive.apache.org" In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="1078491548-2128546202-1338917627=:72412" X-Virus-Checked: Checked by ClamAV on apache.org --1078491548-2128546202-1338917627=:72412 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable HI Babak=0A=0AIt looks like a hadoop configuration problem for me. Have you= configured your 'fs.default.name'=A0 in core-site.xl to point to hdfs:// i= nstead of file:/// ? If not that is likely to be the issue. Also if you are= usinh hdfs for first time there are other steps like formatting namenode a= nd all to be performed.=0A=0Ahttp://hadoop.apache.org/common/docs/r0.20.2/q= uickstart.html=0A=0AEnsure your hadoop installation is fully working before= you get on to hive.=0A=0A=0A=0ARegards=0ABejoy KS=0A=0A=0A=0A=0A=0A_______= _________________________=0A From: Babak Bastan =0ATo: = user@hive.apache.org =0ASent: Tuesday, June 5, 2012 10:43 PM=0ASubject: Err= or while Creating Table in Hive=0A =0A=0AHello Experts ,=0A=0AI'm new in Hi= ve .When try to create a test Table in Hive I get an error.I want to run th= is command:=0ACREATE TABLE Test (DateT STRING, Url STRING, Content STRING);= =0Abut this error occured:=0AFAILED: Error in metadata: MetaException(messa= ge:Got exception: java.io.FileNotFoundException File file:/user/hive/wareho= use/test does not exist.)=0AFAILED: Execution Error, return code 1 from org= .apache.hadoop.hive.ql.exec.DDLTask=0AHow can I solve this Problem?=0AThank= you so much --1078491548-2128546202-1338917627=:72412 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
HI Babak

It looks like a hadoop configurati= on problem for me. Have you configured your 'fs.= default.name'  in core-site.xl to point to hdfs:// instead of file:/// ? If not that is likely to be the issue. Also if you are usinh h= dfs for first time there are other steps like formatting namenode and all t= o be performed.

<= font size=3D"2">http://hadoop.apache.org/common/docs/r0.20.2/quickstart.htm= l

Ensure your hadoop installation is fully working before you get on to hive.
=


<= span>Regards
Bejoy KS



Fr= om: Babak Bastan <babakbsn@gmail.com>
To: user@hive.apache.org
Sent: Tuesday, June 5, 2012 10:43 PM=
Subject: Error while = Creating Table in Hive

=0A
Hello Experts ,<= div>
I'm new in Hive .When try to create a test Table in Hive= I get an error.I want to run this command:
CREATE TABLE Test = (DateT STRING, Url STRING, Content STRING);
=0A
but this error= occured:
FAILED: Error in metad= ata: MetaException(message:Got exception: java.io.FileNotFoundException File file:/user/hive/wareh= ouse/test does not exist.)
=0A
FAILED:= Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask=
How can I solve this Problem?
Thank you so much<= /div>=0A

--1078491548-2128546202-1338917627=:72412--