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:
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
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 hadoop...@yahoo.com
To: Hive user@hive.apache.org; User u...@hadoop.apache.org
Sent: Tuesday, May 21, 2013 1:08 PM
Notes below
From: Raj Hadoop hadoop...@yahoo.commailto:hadoop...@yahoo.com
Reply-To: user@hive.apache.orgmailto:user@hive.apache.org
user@hive.apache.orgmailto:user@hive.apache.org, Raj Hadoop
hadoop...@yahoo.commailto:hadoop...@yahoo.com
Date: Tuesday, May 21, 2013 10:49 AM
To: Dean Wampler
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 hadoop...@yahoo.com wrote:
Ok.I got it. My questions -
1)
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
yes thats what i meant. local physical directory. thanks.
From: bharath vissapragada bharathvissapragada1...@gmail.com
To: user@hive.apache.org; Raj Hadoop hadoop...@yahoo.com
Cc: User u...@hadoop.apache.org
Sent: Tuesday, May 21, 2013 1:59 PM
Subject: Re:
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:
value/software/home/hadoop/hive/hive-0.9.0/warehouse/value
Should be
value/correct/path/in/hdfs/to/your/warehouse/directory/value
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 deanwamp...@gmail.com
To: Raj Hadoop hadoop...@yahoo.com
Cc: Sanjay
Yes !
On Tue, May 21, 2013 at 11:41 PM, Raj Hadoop hadoop...@yahoo.com 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 deanwamp...@gmail.com
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
Thanks Sanjay
From: Sanjay Subramanian sanjay.subraman...@wizecommerce.com
To: bharath vissapragada bharathvissapragada1...@gmail.com;
user@hive.apache.org user@hive.apache.org; Raj Hadoop hadoop...@yahoo.com
Cc: User u...@hadoop.apache.org
Sent: Tuesday, May
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
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=1329416view=copathrev=1329416
From: Raj Hadoop hadoop...@yahoo.com
To: Hive user@hive.apache.org; User
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 hadoop...@yahoo.commailto:hadoop...@yahoo.com
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 sanjay.subraman...@wizecommerce.com
To: u...@hadoop.apache.org u...@hadoop.apache.org; Raj
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 hadoop...@yahoo.commailto:hadoop...@yahoo.com
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)
Begin forwarded message:
From: Edward J. Yoon edwardy...@apache.org
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
19 matches
Mail list logo