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
-
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
+);
+