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 06610C976 for ; Wed, 6 Jun 2012 17:45:24 +0000 (UTC) Received: (qmail 92571 invoked by uid 500); 6 Jun 2012 17:45:22 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 92523 invoked by uid 500); 6 Jun 2012 17:45:22 -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 92513 invoked by uid 99); 6 Jun 2012 17:45:22 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Jun 2012 17:45:22 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=FSL_RCVD_USER,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of dontariq@gmail.com designates 209.85.216.53 as permitted sender) Received: from [209.85.216.53] (HELO mail-qa0-f53.google.com) (209.85.216.53) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Jun 2012 17:45:16 +0000 Received: by qadz32 with SMTP id z32so3473794qad.5 for ; Wed, 06 Jun 2012 10:44:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type:content-transfer-encoding; bh=XP5F6bSn19rv6oesl7Ggijm08ae9cpn/RlHnKBxM+Sg=; b=IOWj5/3BxJiDCjsUCuCK97tMTvzT/CEEjVJG5frHFiXH79uYYTA/kxlFt2Eko2NR76 q0KEXGLVhztFps2rZJYb58Y2NUJtxXbIZFui1JKSdFelCVWlHvqZm7jgxuaDO74NChzd mZYK3+GA9AJcp2E0KuS/eqTHi+JO+/bp4/lW++9NfViiOnUDNgtpOk0YbAxpq9p4ncDq ofuMwYMgS24Lth8+Istj7bNKv4tys4KOpZhQd8rxafoDum3lnFT4zjUamOjVLiChQZXS w0lv7jJ4isIF5fuNutduNN8YyOb5f/8kfBuP/YZEcCt3Y38pxl5j5SnbBXgNtHsqBleX La5Q== Received: by 10.224.58.75 with SMTP id f11mr2880416qah.98.1339004695719; Wed, 06 Jun 2012 10:44:55 -0700 (PDT) MIME-Version: 1.0 Received: by 10.229.126.75 with HTTP; Wed, 6 Jun 2012 10:44:15 -0700 (PDT) In-Reply-To: References: <437664521-1338926129-cardhu_decombobulator_blackberry.rim.net-2052866632-@b17.c15.bise7.blackberry> From: Mohammad Tariq Date: Wed, 6 Jun 2012 23:14:15 +0530 Message-ID: Subject: Re: Error while Creating Table in Hive To: user@hive.apache.org Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable you can also use "jps" command at your shell to see whether Hadoop processes are running or not. Regards, =C2=A0=C2=A0 =C2=A0Mohammad Tariq On Wed, Jun 6, 2012 at 11:12 PM, Mohammad Tariq wrote: > Hi Babak, > > =C2=A0You have to type it in you web browser..Hadoop provides us a web GU= I > that not only allows us to browse through the file system, but to > download the files as well..Apart from that it also provides a web GUI > that can be used to see the status of Jobtracker and Tasktracker..When > you run a Hive or Pig job or a Mapreduce job, you can point your > browser to http://localhost:50030 to see the status and logs of your > job. > > Regards, > =C2=A0=C2=A0 =C2=A0Mohammad Tariq > > > On Wed, Jun 6, 2012 at 8:28 PM, Babak Bastan wrote: >> Thank you shashwat for the answer, >> where should I type=C2=A0http://localhost:50070? >> I typed here: hive>http://localhost:50070=C2=A0but nothing as result >> >> >> On Wed, Jun 6, 2012 at 3:32 PM, shashwat shriparv >> wrote: >>> >>> first type http://localhost:50070 whether this is opening or not and ch= eck >>> how many nodes are available, check some of the hadoop shell commands >>> from=C2=A0http://hadoop.apache.org/common/docs/r0.18.3/hdfs_shell.html= =C2=A0 run >>> example mapreduce task on hadoop take example from here >>> :=C2=A0http://www.michael-noll.com/blog/2011/04/09/benchmarking-and-str= ess-testing-an-hadoop-cluster-with-terasort-testdfsio-nnbench-mrbench/ >>> >>> if all the above you can do sucessfully means hadoop is configured >>> correctly >>> >>> Regards >>> Shashwat >>> >>> >>> On Wed, Jun 6, 2012 at 1:30 AM, Babak Bastan wrote= : >>>> >>>> no I'm not working on CDH.Is there a way to test if my Hadoop works fi= ne >>>> or not? >>>> >>>> >>>> On Tue, Jun 5, 2012 at 9:55 PM, Bejoy KS wrote: >>>>> >>>>> Hi Babak >>>>> >>>>> You gotta follow those instructions in the apace site to set up hadoo= p >>>>> from scratch and ensure that hdfs is working first. You should be abl= e to >>>>> read and write files to hdfs before you do your next steps. >>>>> >>>>> Are you on CDH or apache distribution of hadoop? If it is CDH there a= re >>>>> detailed instructions on Cloudera web site. >>>>> >>>>> Regards >>>>> Bejoy KS >>>>> >>>>> Sent from handheld, please excuse typos. >>>>> ________________________________ >>>>> From: Babak Bastan >>>>> Date: Tue, 5 Jun 2012 21:30:22 +0200 >>>>> To: >>>>> ReplyTo: user@hive.apache.org >>>>> Subject: Re: Error while Creating Table in Hive >>>>> >>>>> @Bejoy: I set the=C2=A0fs.default.name in the core-site.xml and I did= all of >>>>> thing that was mentioned in the reference but no effect >>>>> >>>>> On Tue, Jun 5, 2012 at 8:43 PM, Babak Bastan wro= te: >>>>>> >>>>>> Ok sorry but that was my Mistake .I thought it works but no. >>>>>> I wrote the command without ; and then I think It works but with ; a= t >>>>>> the end of command >>>>>> >>>>>> CREATE TABLE pokes (foo INT, bar STRING); >>>>>> >>>>>> does'nt work >>>>>> >>>>>> >>>>>> On Tue, Jun 5, 2012 at 8:34 PM, shashwat shriparv >>>>>> wrote: >>>>>>> >>>>>>> inside configuration. all properties will be inside the configurati= on >>>>>>> tags >>>>>>> >>>>>>> >>>>>>> On Tue, Jun 5, 2012 at 11:53 PM, Babak Bastan >>>>>>> wrote: >>>>>>>> >>>>>>>> Thank you so much my friend your idee works fine(no error) you are >>>>>>>> the best :) >>>>>>>> >>>>>>>> >>>>>>>> On Tue, Jun 5, 2012 at 8:20 PM, Babak Bastan >>>>>>>> wrote: >>>>>>>>> >>>>>>>>> It must be inside the or outside >>>>>>>>> this? >>>>>>>>> >>>>>>>>> >>>>>>>>> On Tue, Jun 5, 2012 at 8:15 PM, shashwat shriparv >>>>>>>>> wrote: >>>>>>>>>> >>>>>>>>>> It will be inside hive/conf >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On Tue, Jun 5, 2012 at 11:43 PM, Babak Bastan >>>>>>>>>> wrote: >>>>>>>>>>> >>>>>>>>>>> Thanks sShashwat, and where is this hive-site.xml >>>>>>>>>>> >>>>>>>>>>> On Tue, Jun 5, 2012 at 8:02 PM, shashwat shriparv >>>>>>>>>>> wrote: >>>>>>>>>>>> >>>>>>>>>>>> set >>>>>>>>>>>> >>>>>>>>>>>> hive.metastore.warehouse.dir in hive-site.xml >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> =C2=A0 hive.metastore.local >>>>>>>>>>>> =C2=A0 true >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> hive.metastore.warehouse.dir >>>>>>>>>>>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= /home//hivefolder >>>>>>>>>>>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0location of default database for the >>>>>>>>>>>> warehouse >>>>>>>>>>>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> On Tue, Jun 5, 2012 at 10:43 PM, Babak Bastan >>>>>>>>>>>> wrote: >>>>>>>>>>>>> >>>>>>>>>>>>> Hello Experts , >>>>>>>>>>>>> >>>>>>>>>>>>> I'm new in Hive .When try to create a test Table in Hive I ge= t >>>>>>>>>>>>> an error.I want to run this command: >>>>>>>>>>>>> CREATE TABLE Test (DateT STRING, Url STRING, Content STRING); >>>>>>>>>>>>> but this error occured: >>>>>>>>>>>>> FAILED: Error in metadata: MetaException(message:Got exceptio= n: >>>>>>>>>>>>> java.io.FileNotFoundException File file:/user/hive/warehouse/= test does not >>>>>>>>>>>>> exist.) >>>>>>>>>>>>> FAILED: Execution Error, return code 1 from >>>>>>>>>>>>> org.apache.hadoop.hive.ql.exec.DDLTask >>>>>>>>>>>>> How can I solve this Problem? >>>>>>>>>>>>> Thank you so much >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> -- >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> =E2=88=9E >>>>>>>>>>>> >>>>>>>>>>>> Shashwat Shriparv >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> =E2=88=9E >>>>>>>>>> >>>>>>>>>> Shashwat Shriparv >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> >>>>>>> >>>>>>> =E2=88=9E >>>>>>> >>>>>>> Shashwat Shriparv >>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >>> >>> >>> -- >>> >>> >>> =E2=88=9E >>> >>> Shashwat Shriparv >>> >>> >>