You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Raj Hadoop <ha...@yahoo.com> on 2013/05/21 21:08:05 UTC
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
+);
+
Re: Where to get Oracle scripts for Hive Metastore
Posted by Sanjay Subramanian <Sa...@wizecommerce.com>.
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 <ha...@yahoo.com>>
Reply-To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>, Raj Hadoop <ha...@yahoo.com>>
Date: Tuesday, May 21, 2013 12:12 PM
To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>, User <us...@hadoop.apache.org>>, Raj Hadoop <ha...@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 <ha...@yahoo.com>>
To: Hive <us...@hive.apache.org>>; User <us...@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.
Re: Where to get Oracle scripts for Hive Metastore
Posted by Sanjay Subramanian <Sa...@wizecommerce.com>.
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 <ha...@yahoo.com>>
Reply-To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>, Raj Hadoop <ha...@yahoo.com>>
Date: Tuesday, May 21, 2013 12:12 PM
To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>, User <us...@hadoop.apache.org>>, Raj Hadoop <ha...@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 <ha...@yahoo.com>>
To: Hive <us...@hive.apache.org>>; User <us...@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.
Re: Where to get Oracle scripts for Hive Metastore
Posted by Sanjay Subramanian <Sa...@wizecommerce.com>.
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 <ha...@yahoo.com>>
Reply-To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>, Raj Hadoop <ha...@yahoo.com>>
Date: Tuesday, May 21, 2013 12:12 PM
To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>, User <us...@hadoop.apache.org>>, Raj Hadoop <ha...@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 <ha...@yahoo.com>>
To: Hive <us...@hive.apache.org>>; User <us...@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.
Re: Where to get Oracle scripts for Hive Metastore
Posted by Sanjay Subramanian <Sa...@wizecommerce.com>.
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 <ha...@yahoo.com>>
Reply-To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>, Raj Hadoop <ha...@yahoo.com>>
Date: Tuesday, May 21, 2013 12:12 PM
To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>, User <us...@hadoop.apache.org>>, Raj Hadoop <ha...@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 <ha...@yahoo.com>>
To: Hive <us...@hive.apache.org>>; User <us...@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.
Re: Where to get Oracle scripts for Hive Metastore
Posted by Sanjay Subramanian <Sa...@wizecommerce.com>.
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 <ha...@yahoo.com>>
Reply-To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>, Raj Hadoop <ha...@yahoo.com>>
Date: Tuesday, May 21, 2013 12:12 PM
To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>, User <us...@hadoop.apache.org>>, Raj Hadoop <ha...@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 <ha...@yahoo.com>>
To: Hive <us...@hive.apache.org>>; User <us...@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.
Re: Where to get Oracle scripts for Hive Metastore
Posted by Raj Hadoop <ha...@yahoo.com>.
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 <ha...@yahoo.com>
To: Hive <us...@hive.apache.org>; User <us...@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
+);
+
Re: Where to get Oracle scripts for Hive Metastore
Posted by Raj Hadoop <ha...@yahoo.com>.
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 <ha...@yahoo.com>
To: Hive <us...@hive.apache.org>; User <us...@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
+);
+
Re: Where to get Oracle scripts for Hive Metastore
Posted by Raj Hadoop <ha...@yahoo.com>.
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 <ha...@yahoo.com>
To: Hive <us...@hive.apache.org>; User <us...@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
+);
+
Re: Where to get Oracle scripts for Hive Metastore
Posted by Raj Hadoop <ha...@yahoo.com>.
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 <ha...@yahoo.com>
To: Hive <us...@hive.apache.org>; User <us...@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
+);
+
Re: Where to get Oracle scripts for Hive Metastore
Posted by Raj Hadoop <ha...@yahoo.com>.
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 <ha...@yahoo.com>
To: Hive <us...@hive.apache.org>; User <us...@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
+);
+
Re: Snappy with HIve
Posted by Sanjay Subramanian <Sa...@wizecommerce.com>.
Thanks Bejoy…I tracked down the issue..there was an earlier table (with leo definition) that I had not dropped and recreated - hence giving input snappy to that was giving issues
Regards
sanjay
From: "bejoy_ks@yahoo.com<ma...@yahoo.com>" <be...@yahoo.com>>
Reply-To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>, "bejoy_ks@yahoo.com<ma...@yahoo.com>" <be...@yahoo.com>>
Date: Thursday, May 23, 2013 7:31 AM
To: "user@hive.apache.org<ma...@hive.apache.org>" <us...@hive.apache.org>>
Subject: Re: Snappy with HIve
Hi
Please find responses below.
Do I have to give some INPUTFORMAT directive to make the Hive Table read Snappy Codec files ?
For example for LZO its
STORED AS INPUTFORMAT "com.hadoop.mapred.DeprecatedLzoTextInputFormat"
Bejoy : No custom input format required. Add the snappy codec in io.compression.codecs.
QUESTION 2
For Hive scripts that will READ Snappy files and Output Snappy Files to Hive Tables are the following settings enough ?
SET hive.exec.compress.output=true;
SET mapred.output.compression.codec=org.apache.hadoop.io.compress.SnappyCodec;
SET mapred.output.compression.type=BLOCK;
Bejoy: It should be fine. If it shows any issues add mapred.output.compress=true as well
Regards
Bejoy KS
Sent from remote device, Please excuse typos
________________________________
From: Sanjay Subramanian <Sa...@wizecommerce.com>>
Date: Tue, 21 May 2013 23:30:09 +0000
To: user@hive.apache.org<ma...@hive.apache.org>>
ReplyTo: user@hive.apache.org<ma...@hive.apache.org>
Subject: Snappy with HIve
Hi guys
QUESTION 1
I have an MR job that creates Snappy Codec Output files.
My table definition is as follows
CREATE EXTERNAL TABLE IF NOT EXISTS outpdir_header_hive_only(hbase_pk STRING,header_servername_donotquerySTRING,header_date_donotquery STRING, header_id STRING, header_hbpk STRING,header_channelId INT,header_searchAnnotation STRING,header_continuedSearchFlag INT,header_prodLow INT,header_prodTotal INT,header_sort INT,header_view INT,header_adNodes INT,header_spellingSuggestion STRING,header_queryType INT,header_nodeId INT,header_pinpointPtitleId INT,header_firedSearchRulesSTRING,header_rbAbsentSellers INT,header_shuffled INT,header_searchSessionId STRING,header_normalizationFlag STRING,header_relatedItemResultCount INT,header_unrankedSelectedPtitleIds INT,header_normKeyword STRING,header_kplEntry INT,header_isSaved STRING,header_rawProfileScore DOUBLE,header_normalizedProfileScore INT,header_scorerInfo STRING,header_contextNode INT,header_fbId STRING,norm_stem_keyword STRING, attrs_origNodeId INT,attrs_mfrId INT,attrs_sellerId INT,attrs_otherAttrs STRING,attrs_ptitleId INT,cached_date STRING,cached_recordId STRING,cached_visitorId STRING,cached_visit_id STRING,cached_appStyle STRING,cached_publisherId INT,cached_IP STRING,cached_source STRING,cached_refkw STRING,cached_pixeled INT,cached_searchRefineAttrImps STRING,cached_pageType STRING,cached_zipCode STRING,cached_zipType STRING,cached_perpage INT) PARTITIONED BY (header_date STRING, header_servername STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
Do I have to give some INPUTFORMAT directive to make the Hive Table read Snappy Codec files ?
For example for LZO its
STORED AS INPUTFORMAT "com.hadoop.mapred.DeprecatedLzoTextInputFormat"
QUESTION 2
For Hive scripts that will READ Snappy files and Output Snappy Files to Hive Tables are the following settings enough ?
SET hive.exec.compress.output=true;
SET mapred.output.compression.codec=org.apache.hadoop.io.compress.SnappyCodec;
SET mapred.output.compression.type=BLOCK;
Thanks
sanjay
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.
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.
Re: Snappy with HIve
Posted by be...@yahoo.com.
Hi
Please find responses below.
Do I have to give some INPUTFORMAT directive to make the Hive Table read Snappy Codec files ?
For example for LZO its
STORED AS INPUTFORMAT "com.hadoop.mapred.DeprecatedLzoTextInputFormat"
Bejoy : No custom input format required. Add the snappy codec in io.compression.codecs.
QUESTION 2
For Hive scripts that will READ Snappy files and Output Snappy Files to Hive Tables are the following settings enough ?
SET hive.exec.compress.output=true;
SET mapred.output.compression.codec=org.apache.hadoop.io.compress.SnappyCodec;
SET mapred.output.compression.type=BLOCK;
Bejoy: It should be fine. If it shows any issues add mapred.output.compress=true as well
Regards
Bejoy KS
Sent from remote device, Please excuse typos
-----Original Message-----
From: Sanjay Subramanian <Sa...@wizecommerce.com>
Date: Tue, 21 May 2013 23:30:09
To: user@hive.apache.org<us...@hive.apache.org>
Reply-To: user@hive.apache.org
Subject: Snappy with HIve
Hi guys
QUESTION 1
I have an MR job that creates Snappy Codec Output files.
My table definition is as follows
CREATE EXTERNAL TABLE IF NOT EXISTS outpdir_header_hive_only(hbase_pk STRING,header_servername_donotquerySTRING,header_date_donotquery STRING, header_id STRING, header_hbpk STRING,header_channelId INT,header_searchAnnotation STRING,header_continuedSearchFlag INT,header_prodLow INT,header_prodTotal INT,header_sort INT,header_view INT,header_adNodes INT,header_spellingSuggestion STRING,header_queryType INT,header_nodeId INT,header_pinpointPtitleId INT,header_firedSearchRulesSTRING,header_rbAbsentSellers INT,header_shuffled INT,header_searchSessionId STRING,header_normalizationFlag STRING,header_relatedItemResultCount INT,header_unrankedSelectedPtitleIds INT,header_normKeyword STRING,header_kplEntry INT,header_isSaved STRING,header_rawProfileScore DOUBLE,header_normalizedProfileScore INT,header_scorerInfo STRING,header_contextNode INT,header_fbId STRING,norm_stem_keyword STRING, attrs_origNodeId INT,attrs_mfrId INT,attrs_sellerId INT,attrs_otherAttrs STRING,attrs_ptitleId INT,cached_date STRING,cached_recordId STRING,cached_visitorId STRING,cached_visit_id STRING,cached_appStyle STRING,cached_publisherId INT,cached_IP STRING,cached_source STRING,cached_refkw STRING,cached_pixeled INT,cached_searchRefineAttrImps STRING,cached_pageType STRING,cached_zipCode STRING,cached_zipType STRING,cached_perpage INT) PARTITIONED BY (header_date STRING, header_servername STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
Do I have to give some INPUTFORMAT directive to make the Hive Table read Snappy Codec files ?
For example for LZO its
STORED AS INPUTFORMAT "com.hadoop.mapred.DeprecatedLzoTextInputFormat"
QUESTION 2
For Hive scripts that will READ Snappy files and Output Snappy Files to Hive Tables are the following settings enough ?
SET hive.exec.compress.output=true;
SET mapred.output.compression.codec=org.apache.hadoop.io.compress.SnappyCodec;
SET mapred.output.compression.type=BLOCK;
Thanks
sanjay
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.
Snappy with HIve
Posted by Sanjay Subramanian <Sa...@wizecommerce.com>.
Hi guys
QUESTION 1
I have an MR job that creates Snappy Codec Output files.
My table definition is as follows
CREATE EXTERNAL TABLE IF NOT EXISTS outpdir_header_hive_only(hbase_pk STRING,header_servername_donotquerySTRING,header_date_donotquery STRING, header_id STRING, header_hbpk STRING,header_channelId INT,header_searchAnnotation STRING,header_continuedSearchFlag INT,header_prodLow INT,header_prodTotal INT,header_sort INT,header_view INT,header_adNodes INT,header_spellingSuggestion STRING,header_queryType INT,header_nodeId INT,header_pinpointPtitleId INT,header_firedSearchRulesSTRING,header_rbAbsentSellers INT,header_shuffled INT,header_searchSessionId STRING,header_normalizationFlag STRING,header_relatedItemResultCount INT,header_unrankedSelectedPtitleIds INT,header_normKeyword STRING,header_kplEntry INT,header_isSaved STRING,header_rawProfileScore DOUBLE,header_normalizedProfileScore INT,header_scorerInfo STRING,header_contextNode INT,header_fbId STRING,norm_stem_keyword STRING, attrs_origNodeId INT,attrs_mfrId INT,attrs_sellerId INT,attrs_otherAttrs STRING,attrs_ptitleId INT,cached_date STRING,cached_recordId STRING,cached_visitorId STRING,cached_visit_id STRING,cached_appStyle STRING,cached_publisherId INT,cached_IP STRING,cached_source STRING,cached_refkw STRING,cached_pixeled INT,cached_searchRefineAttrImps STRING,cached_pageType STRING,cached_zipCode STRING,cached_zipType STRING,cached_perpage INT) PARTITIONED BY (header_date STRING, header_servername STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
Do I have to give some INPUTFORMAT directive to make the Hive Table read Snappy Codec files ?
For example for LZO its
STORED AS INPUTFORMAT "com.hadoop.mapred.DeprecatedLzoTextInputFormat"
QUESTION 2
For Hive scripts that will READ Snappy files and Output Snappy Files to Hive Tables are the following settings enough ?
SET hive.exec.compress.output=true;
SET mapred.output.compression.codec=org.apache.hadoop.io.compress.SnappyCodec;
SET mapred.output.compression.type=BLOCK;
Thanks
sanjay
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.
Re: Where to get Oracle scripts for Hive Metastore
Posted by Raj Hadoop <ha...@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 <Sa...@wizecommerce.com>
To: "user@hadoop.apache.org" <us...@hadoop.apache.org>; Raj Hadoop <ha...@yahoo.com>; Hive <us...@hive.apache.org>
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 <ha...@yahoo.com>
Reply-To: "user@hadoop.apache.org" <us...@hadoop.apache.org>, Raj Hadoop <ha...@yahoo.com>
Date: Tuesday, May 21, 2013 12:08 PM
To: Hive <us...@hive.apache.org>, User <us...@hadoop.apache.org>
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.
Re: Where to get Oracle scripts for Hive Metastore
Posted by Raj Hadoop <ha...@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 <Sa...@wizecommerce.com>
To: "user@hadoop.apache.org" <us...@hadoop.apache.org>; Raj Hadoop <ha...@yahoo.com>; Hive <us...@hive.apache.org>
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 <ha...@yahoo.com>
Reply-To: "user@hadoop.apache.org" <us...@hadoop.apache.org>, Raj Hadoop <ha...@yahoo.com>
Date: Tuesday, May 21, 2013 12:08 PM
To: Hive <us...@hive.apache.org>, User <us...@hadoop.apache.org>
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.
Re: Where to get Oracle scripts for Hive Metastore
Posted by Raj Hadoop <ha...@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 <Sa...@wizecommerce.com>
To: "user@hadoop.apache.org" <us...@hadoop.apache.org>; Raj Hadoop <ha...@yahoo.com>; Hive <us...@hive.apache.org>
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 <ha...@yahoo.com>
Reply-To: "user@hadoop.apache.org" <us...@hadoop.apache.org>, Raj Hadoop <ha...@yahoo.com>
Date: Tuesday, May 21, 2013 12:08 PM
To: Hive <us...@hive.apache.org>, User <us...@hadoop.apache.org>
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.
Re: Where to get Oracle scripts for Hive Metastore
Posted by Raj Hadoop <ha...@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 <Sa...@wizecommerce.com>
To: "user@hadoop.apache.org" <us...@hadoop.apache.org>; Raj Hadoop <ha...@yahoo.com>; Hive <us...@hive.apache.org>
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 <ha...@yahoo.com>
Reply-To: "user@hadoop.apache.org" <us...@hadoop.apache.org>, Raj Hadoop <ha...@yahoo.com>
Date: Tuesday, May 21, 2013 12:08 PM
To: Hive <us...@hive.apache.org>, User <us...@hadoop.apache.org>
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.
Re: Where to get Oracle scripts for Hive Metastore
Posted by Raj Hadoop <ha...@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 <Sa...@wizecommerce.com>
To: "user@hadoop.apache.org" <us...@hadoop.apache.org>; Raj Hadoop <ha...@yahoo.com>; Hive <us...@hive.apache.org>
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 <ha...@yahoo.com>
Reply-To: "user@hadoop.apache.org" <us...@hadoop.apache.org>, Raj Hadoop <ha...@yahoo.com>
Date: Tuesday, May 21, 2013 12:08 PM
To: Hive <us...@hive.apache.org>, User <us...@hadoop.apache.org>
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.
Re: Where to get Oracle scripts for Hive Metastore
Posted by Sanjay Subramanian <Sa...@wizecommerce.com>.
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 <ha...@yahoo.com>>
Reply-To: "user@hadoop.apache.org<ma...@hadoop.apache.org>" <us...@hadoop.apache.org>>, Raj Hadoop <ha...@yahoo.com>>
Date: Tuesday, May 21, 2013 12:08 PM
To: Hive <us...@hive.apache.org>>, User <us...@hadoop.apache.org>>
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.
Re: Where to get Oracle scripts for Hive Metastore
Posted by Sanjay Subramanian <Sa...@wizecommerce.com>.
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 <ha...@yahoo.com>>
Reply-To: "user@hadoop.apache.org<ma...@hadoop.apache.org>" <us...@hadoop.apache.org>>, Raj Hadoop <ha...@yahoo.com>>
Date: Tuesday, May 21, 2013 12:08 PM
To: Hive <us...@hive.apache.org>>, User <us...@hadoop.apache.org>>
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.
Re: Where to get Oracle scripts for Hive Metastore
Posted by Sanjay Subramanian <Sa...@wizecommerce.com>.
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 <ha...@yahoo.com>>
Reply-To: "user@hadoop.apache.org<ma...@hadoop.apache.org>" <us...@hadoop.apache.org>>, Raj Hadoop <ha...@yahoo.com>>
Date: Tuesday, May 21, 2013 12:08 PM
To: Hive <us...@hive.apache.org>>, User <us...@hadoop.apache.org>>
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.
Re: Where to get Oracle scripts for Hive Metastore
Posted by Sanjay Subramanian <Sa...@wizecommerce.com>.
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 <ha...@yahoo.com>>
Reply-To: "user@hadoop.apache.org<ma...@hadoop.apache.org>" <us...@hadoop.apache.org>>, Raj Hadoop <ha...@yahoo.com>>
Date: Tuesday, May 21, 2013 12:08 PM
To: Hive <us...@hive.apache.org>>, User <us...@hadoop.apache.org>>
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.
Re: Where to get Oracle scripts for Hive Metastore
Posted by Sanjay Subramanian <Sa...@wizecommerce.com>.
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 <ha...@yahoo.com>>
Reply-To: "user@hadoop.apache.org<ma...@hadoop.apache.org>" <us...@hadoop.apache.org>>, Raj Hadoop <ha...@yahoo.com>>
Date: Tuesday, May 21, 2013 12:08 PM
To: Hive <us...@hive.apache.org>>, User <us...@hadoop.apache.org>>
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.