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 <hadoop...@yahoo.com> To: Hive <user@hive.apache.org>; User <u...@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.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 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 +); +
