hadoop-mapreduce-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sanjay Subramanian <Sanjay.Subraman...@wizecommerce.com>
Subject Re: Where to get Oracle scripts for Hive Metastore
Date Tue, 21 May 2013 19:25:44 GMT
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 <hadoopraj@yahoo.com<mailto:hadoopraj@yahoo.com>>
Reply-To: "user@hive.apache.org<mailto:user@hive.apache.org>" <user@hive.apache.org<mailto:user@hive.apache.org>>,
Raj Hadoop <hadoopraj@yahoo.com<mailto:hadoopraj@yahoo.com>>
Date: Tuesday, May 21, 2013 12:12 PM
To: "user@hive.apache.org<mailto:user@hive.apache.org>" <user@hive.apache.org<mailto:user@hive.apache.org>>,
User <user@hadoop.apache.org<mailto:user@hadoop.apache.org>>, Raj Hadoop <hadoopraj@yahoo.com<mailto:hadoopraj@yahoo.com>>
Subject: 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 <hadoopraj@yahoo.com<mailto:hadoopraj@yahoo.com>>
To: Hive <user@hive.apache.org<mailto:user@hive.apache.org>>; User <user@hadoop.apache.org<mailto:user@hadoop.apache.org>>
Sent: Tuesday, May 21, 2013 3:08 PM
Subject: 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.9742B2388860@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 through Oracle sqlplus.

+CREATE TABLE PART_COL_PRIVS
+(
+    PART_COLUMN_GRANT_ID NUMBER NOT NULL,
+    "COLUMN_NAME" VARCHAR2(128) NULL,
+    CREATE_TIME NUMBER (10) NOT NULL,
+    GRANT_OPTION NUMBER (5) NOT NULL,
+    GRANTOR VARCHAR2(128) NULL,
+    GRANTOR_TYPE VARCHAR2(128) NULL,
+    PART_ID NUMBER NULL,
+    PRINCIPAL_NAME VARCHAR2(128) NULL,
+    PRINCIPAL_TYPE VARCHAR2(128) NULL,
+    PART_COL_PRIV VARCHAR2(128) NULL
+);
+





CONFIDENTIALITY NOTICE
======================
This email message and any attachments are for the exclusive use of the intended recipient(s)
and may contain confidential and privileged information. Any unauthorized review, use, disclosure
or distribution is prohibited. If you are not the intended recipient, please contact the sender
by reply email and destroy all copies of the original message along with any attachments,
from your computer system. If you are the intended recipient, please be advised that the content
of this message is subject to access, review and disclosure by the sender's Email System Administrator.

Mime
View raw message