Fwd: Hadoop In Seoul 2013 Conference Calls For Speakers

Begin forwarded message: > From: "Edward J. Yoon" > Date: May 21, 2013 1:29:06 AM PDT > To: gene...@hadoop.apache.org > Subject: Hadoop In Seoul 2013 Conference Calls For Speakers > Reply-To: gene...@hadoop.apache.org > > Hi, > > I'm planning the Hadoop In Seoul 2013 Open Conference with some

Re: ORA-01950: no privileges on tablespace

See the CDH notes here…scroll down to where the Oracle section is http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH4/latest/CDH4-Installation-Guide/cdh4ig_topic_18_4.html From: Raj Hadoop mailto:hadoop...@yahoo.com>> Reply-To: "user@hive.apache.org"

ORA-01950: no privileges on tablespace

  I am setting up a metastore on Oracle for Hive. I executed the script hive-schema-0.9.0-sql file too succesfully.   When i ran this hive > show tables;   I am getting the following error.   ORA-01950: no privileges on tablespace   What kind of Oracle privileges are required (Quota wise for Hive)

Re: Where to get Oracle scripts for Hive Metastore

I think it should be this link because this refers to the /branches/branch-0.9 http://svn.apache.org/viewvc/hive/branches/branch-0.9/metastore/scripts/upgrade/oracle/ Can one of the Hive committers please verify…thanks sanjay From: Raj Hadoop mailto:hadoop...@yahoo.com>> Reply-To: "user@hive

Re: Where to get Oracle scripts for Hive Metastore

Sanjay -   This is the first location I tried. But Apache Hive 0.9.0 doesnt have an oracle folder. It only had mysql and derby.   Thanks, Raj From: Sanjay Subramanian To: "u...@hadoop.apache.org" ; Raj Hadoop ; Hive Sent: Tuesday, May 21, 2013 3:12 PM Subject

Re: Where to get Oracle scripts for Hive Metastore

Raj The correct location of the script is where u deflated the hive tar For example /usr/lib/hive/scripts/metastore/upgrade/oracle You will find a file in this directory called hive-schema-0.9.0.oracle.sql Use this sanjay From: Raj Hadoop mailto:hadoop...@yahoo.com>> Reply-To: "u...@hadoop.ap

Re: Where to get Oracle scripts for Hive Metastore

I got it. This is the link.   http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/oracle/hive-schema-0.9.0.oracle.sql?revision=1329416&view=co&pathrev=1329416 From: Raj Hadoop To: Hive ; User Sent: Tuesday, May 21, 2013 3:08 PM Subject: Where to g

Where to get Oracle scripts for Hive Metastore

I am trying to get Oracle scripts for Hive Metastore.   http://mail-archives.apache.org/mod_mbox/hive-commits/201204.mbox/%3c20120423201303.9742b2388...@eris.apache.org%3E   The scripts in the above link has a  + at the begining of each line. How should I supposed to execute scripts like this thro

Re: hive.metastore.warehouse.dir - Should it point to a physical directory

Thanks Sanjay From: Sanjay Subramanian To: bharath vissapragada ; "user@hive.apache.org" ; Raj Hadoop Cc: User Sent: Tuesday, May 21, 2013 2:27 PM Subject: Re: hive.metastore.warehouse.dir - Should it point to a physical directory Hi Raj http://www.clo

Re: hive.metastore.warehouse.dir - Should it point to a physical directory

Hi Raj http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH4/latest/CDH4-Quick-Start/cdh4qs_topic_3.html Installing CDH4 on a Single Linux Node in Pseudo-distributed Mode On the left panel of the page u will find info on Hive installation etc. I suggest CHD4 distribution only beca

Re: hive.metastore.warehouse.dir - Should it point to a physical directory

Yes ! On Tue, May 21, 2013 at 11:41 PM, Raj Hadoop wrote: > So that means I need to create a HDFS ( Not an OS physical directory ) > directory under Hadoop that need to be used in the Hive config file for > this property. Right? > > *From:* Dean Wampler > *To:* Raj Hadoop > *Cc:* Sanjay Subr

Re: hive.metastore.warehouse.dir - Should it point to a physical directory

So that means I need to create a HDFS ( Not an OS physical directory ) directory under Hadoop that need to be used in the Hive config file for this property. Right? From: Dean Wampler To: Raj Hadoop Cc: Sanjay Subramanian ; "user@hive.apache.org" ; User S

Re: hive.metastore.warehouse.dir - Should it point to a physical directory

No, you only need a directory in HDFS, which will be "virtually located" somewhere in your cluster automatically by HDFS. Also there's a typo in your hive.xml: Should be /correct/path/in/hdfs/to/your/warehouse/directory On Tue, May 21, 2013 at 1:04 PM, Raj Hadoop wrote: > Thanks Sanjay.

Re: hive.metastore.warehouse.dir - Should it point to a physical directory

yes thats what i meant. local physical directory. thanks. From: bharath vissapragada To: user@hive.apache.org; Raj Hadoop Cc: User Sent: Tuesday, May 21, 2013 1:59 PM Subject: Re: hive.metastore.warehouse.dir - Should it point to a physical directory Hi,

Re: hive.metastore.warehouse.dir - Should it point to a physical directory

Thanks Sanjay.   My environment is  like this.   $ echo $HADOOP_HOME /software/home/hadoop/hadoop/hadoop-1.1.2   $ echo $HIVE_HOME /software/home/hadoop/hive/hive-0.9.0 $ id uid=50052(hadoop) gid=600(apps) groups=600(apps)   So can i do like this:   $pwd /software/home/hadoop/hive/hive-0.9.0   $m

Re: hive.metastore.warehouse.dir - Should it point to a physical directory

Hi, If by "local physical directory" you mean a directory in the underlying OS file system, then No. You just need to create a directory in HDFS and ad it to that xml config file. Thanks, On Tue, May 21, 2013 at 11:19 PM, Raj Hadoop wrote: > Ok.I got it. My questions - > > 1) Should a local p

Re: hive.metastore.warehouse.dir - Should it point to a physical directory

Notes below From: Raj Hadoop mailto:hadoop...@yahoo.com>> Reply-To: "user@hive.apache.org" mailto:user@hive.apache.org>>, Raj Hadoop mailto:hadoop...@yahoo.com>> Date: Tuesday, May 21, 2013 10:49 AM To: Dean Wampler mailto:deanwamp...@gmail.com>>, "user@hive.apache.

Re: hive.metastore.warehouse.dir - Should it point to a physical directory

Ok.I got it. My questions -   1) Should a local physical directory be created before using this property? 2) Should a HDFS file directory be created from Hadoop before using this property?     From: Dean Wampler To: user@hive.apache.org; Raj Hadoop Cc: User

Re: hive.metastore.warehouse.dir - Should it point to a physical directory

The name is misleading; this is the directory within HDFS where Hive stores the data, by default. (External tables can go elsewhere). It doesn't really have anything to do with the metastore. dean On Tue, May 21, 2013 at 12:42 PM, Raj Hadoop wrote: > Can some one help me on this ? I am stuck in

Re: hive.metastore.warehouse.dir - Should it point to a physical directory

Can some one help me on this ? I am stuck installing and configuring Hive with Oracle. Your timely help is really aprreciated. From: Raj Hadoop To: Hive ; User Sent: Tuesday, May 21, 2013 1:08 PM Subject: hive.metastore.warehouse.dir - Should it point to a ph

hive.metastore.warehouse.dir - Should it point to a physical directory

Hi,   I am configurinig Hive. I ahve a question on the property hive.metastore.warehouse.dir.   Should this point to a physical directory. I am guessing it is a logical directory under Hadoop fs.default.name. Please advise whether I need to create any directory for the variable hive.metastore.wa

Re: Hive views

The views should not be lost every time, you might want to try a permanent metastore backed by mysql so you do not lose your table definitions. On Tue, May 21, 2013 at 8:14 AM, Clay McDonald < stuart.mcdon...@bateswhite.com> wrote: > Maybe you could modify the Hive startup script to recreate you

RE: Hive views

Maybe you could modify the Hive startup script to recreate your views. I would try creating a script that has the create views the call that from the startup script. Clay -Original Message- From: abhishek [mailto:abhishek.dod...@gmail.com] Sent: Thursday, May 16, 2013 6:45 PM To: cdh