Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Where to get Oracle scripts for Hive Metastore


Copy link to this message
-
Re: Where to get Oracle scripts for Hive Metastore
Raj Hadoop 2013-05-21, 19:19
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 <[EMAIL PROTECTED]>
To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>; Raj Hadoop <[EMAIL PROTECTED]>; Hive <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>
Reply-To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>, Raj Hadoop <[EMAIL PROTECTED]>
Date: Tuesday, May 21, 2013 12:08 PM
To: Hive <[EMAIL PROTECTED]>, User <[EMAIL PROTECTED]>
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/%[EMAIL PROTECTED]%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.