Re: create table exception

2010-09-03 Thread Edward Capriolo
On Mon, Apr 5, 2010 at 7:23 PM, Sagar Naik wrote: > Thanks for responses, > I am still not able to get it running > Comments inline, Just to make sure, I did all u suggested > Pl  advise > -Sagr > On Apr 5, 2010, at 1:51 PM, Arvind Prabhakar wrote: > > Hi Sagar, >> As a trial, I  am trying to setu

Re: create table exception

2010-04-05 Thread Sagar Naik
Thanks for responses, I am still not able to get it running Comments inline, Just to make sure, I did all u suggested Pl advise -Sagr On Apr 5, 2010, at 1:51 PM, Arvind Prabhakar wrote: > Hi Sagar, > > > As a trial, I am trying to setup hive for local DFS,MR mode > > You can do this as fol

Re: create table exception

2010-04-05 Thread Arvind Prabhakar
Hi Sagar, > As a trial, I am trying to setup hive for local DFS,MR mode You can do this as follows: 1. Set your HADOOP_HOME to the local hadoop installation. The configuration files - core-site.xml, mapred-site.xml, and hdfs-site.xml in $HADOOP_HOME/conf should be empty configurations with no p

Re: create table exception

2010-04-05 Thread Ted Yu
I referred to http://www.mazsoft.com/blog/post/2010/02/01/Setting-up-HadoopHive-to-use-MySQL-as-metastore.aspxwhen I setup metastore. You can try that approach as well. On Mon, Apr 5, 2010 at 11:55 AM, Sagar Naik wrote: > Hi > I tried to setup in embedded mode, the easiest one :) > Still no luc

Re: create table exception

2010-04-05 Thread John Sichi
On Apr 5, 2010, at 10:30 AM, Sagar Naik wrote: > > Correct me if I m wrong. > Does this mean we need a traditional DB instance running for Hive to work ? At a recent Hive user meeting, someone in the audience pointed out that HBase can now be used as a JDO datastore, so if you are incredibly

Re: create table exception

2010-04-05 Thread Sagar Naik
Hi I tried to setup in embedded mode, the easiest one :) Still no luck mapred.reduce.tasks local The default number of reduce tasks per job. Typically set to a prime close to the number of available hosts. Ignored when mapred.job.tracker is "local". Hadoop set this to 1 by default,

Re: create table exception

2010-04-05 Thread Sagar Naik
HI Zeng, Thanks for response Correct me if I m wrong. Does this mean we need a traditional DB instance running for Hive to work ? -Sagar On Apr 5, 2010, at 1:02 AM, Zheng Shao wrote: > See http://wiki.apache.org/hadoop/Hive/AdminManual/MetastoreAdmin for details. > > Zheng > > On Mon, Apr 5

Re: create table exception

2010-04-05 Thread Zheng Shao
See http://wiki.apache.org/hadoop/Hive/AdminManual/MetastoreAdmin for details. Zheng On Mon, Apr 5, 2010 at 12:01 AM, Sagar Naik wrote: > Hi > As a trial, I  am trying to setup hive for local DFS,MR mode > I have set > >  hive.metastore.uris >  file:///data/hive/metastore/metadb >  The location

create table exception

2010-04-05 Thread Sagar Naik
Hi As a trial, I am trying to setup hive for local DFS,MR mode I have set hive.metastore.uris file:///data/hive/metastore/metadb The location of filestore metadata base dir in hive-site.xml But I m still getting the following error Pl help me in getting hive up and running CREATE