Return-Path: X-Original-To: apmail-hadoop-mapreduce-user-archive@minotaur.apache.org Delivered-To: apmail-hadoop-mapreduce-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id A03E6DF53 for ; Tue, 21 May 2013 19:19:57 +0000 (UTC) Received: (qmail 75372 invoked by uid 500); 21 May 2013 19:19:52 -0000 Delivered-To: apmail-hadoop-mapreduce-user-archive@hadoop.apache.org Received: (qmail 73457 invoked by uid 500); 21 May 2013 19:19:50 -0000 Mailing-List: contact user-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hadoop.apache.org Delivered-To: mailing list user@hadoop.apache.org Received: (qmail 73012 invoked by uid 99); 21 May 2013 19:19:49 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 21 May 2013 19:19:49 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [98.139.212.163] (HELO nm4.bullet.mail.bf1.yahoo.com) (98.139.212.163) by apache.org (qpsmtpd/0.29) with SMTP; Tue, 21 May 2013 19:19:41 +0000 Received: from [98.139.214.32] by nm4.bullet.mail.bf1.yahoo.com with NNFMP; 21 May 2013 19:19:20 -0000 Received: from [98.139.212.197] by tm15.bullet.mail.bf1.yahoo.com with NNFMP; 21 May 2013 19:19:20 -0000 Received: from [127.0.0.1] by omp1006.mail.bf1.yahoo.com with NNFMP; 21 May 2013 19:19:20 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 222142.29095.bm@omp1006.mail.bf1.yahoo.com Received: (qmail 14664 invoked by uid 60001); 21 May 2013 19:19:20 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1369163960; bh=V03sB/NdFzWXKS+VoZX2GKlDVV2pCGN0eGCaC5tfIC8=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=aUn5ic/DPtR8UasuVVG02vKMcftSraWiQ0JqCXCMWhyv4p/oGGkYWTU1vDIGAxnc+rVsWCjlO57pi/qFgWg0ZXycP8uQ6ABjPalyIt5072A1p6rpg2h2ngwOZ7Jd0Dktw5OJ7g/noE6Qgzfej0t/cw61ZbPmlDmfPs/GzCCBwG8= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=YtSNVZnTYGm9wvkwgNU9kkEAaadSRej/6SkPxv9cr6+O2GbsXuC9AqsMU1yV+7AU/Z7oVLrimT0TgsX4yqQsPMc2vMkvLDfq00S5V5Xr47doeJzgR65z7Xx3gQb+278VyYQMrxFcHdZeV7F5AxP3XcAMCGcuwdHjODl9BI/zVpI=; X-YMail-OSG: 6RYnQBUVM1kmiqfQt4xEIBXDpYhdpWdI4CsMZp7TnIq1_cl QdNlZ7c.70MmCZMUUeG3UAANH1mVeYt2qhyRTAf5Y5bwle4J191KbyB3uNNh uMDzsqz9rrLVk1IXcHo5oKeGqbICZog7.jUNoeIydOZlNkn74B9kJcRCqU6p 7imtHFWMd2xYqlnMGUlP5gQ_uBFt3KW8UZ9llksraxX0t6E42KL4iNTABCK3 FvNKsUzch5r8KwCziJY_UwOZFgue1PR6qxFgnmAuxPXvhMIS2ofp5dYAWUn6 3UrTO4IAaPz.nqthJBh.Teh0IaO0D_puiyXXQFbghJG_O89MZej_f5GqAFME brPlTpHWkLQp6XF6p_L6aJmK50LnYz0FwdyRLpPMLocl.vcl5hqP3TJ1CRw8 CpSjtQZfGq3rvAq7cJmZrpy.ZLm8ED34qggw8axBJX0k5MRFntCRltIEqSSg pGoPmffsQN7XBIGHIM1_yb6yfTSY8bgw- Received: from [151.124.247.200] by web162204.mail.bf1.yahoo.com via HTTP; Tue, 21 May 2013 12:19:19 PDT X-Rocket-MIMEInfo: 002.001,U2FuamF5IC0KwqAKVGhpcyBpcyB0aGUgZmlyc3QgbG9jYXRpb24gSSB0cmllZC4gQnV0IEFwYWNoZSBIaXZlIDAuOS4wIGRvZXNudCBoYXZlIGFuIG9yYWNsZSBmb2xkZXIuIEl0IG9ubHkgaGFkIG15c3FsIGFuZCBkZXJieS4KwqAKVGhhbmtzLApSYWoKCgpfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXwpGcm9tOiBTYW5qYXkgU3VicmFtYW5pYW4gPFNhbmpheS5TdWJyYW1hbmlhbkB3aXplY29tbWVyY2UuY29tPgpUbzogInVzZXJAaGFkb29wLmFwYWNoZS5vcmciIDx1c2VyQGhhZG9vcC5hcGFjaGUBMAEBAQE- X-Mailer: YahooMailWebService/0.8.142.542 References: <1369163285.70373.YahooMailNeo@web162201.mail.bf1.yahoo.com> Message-ID: <1369163959.12981.YahooMailNeo@web162204.mail.bf1.yahoo.com> Date: Tue, 21 May 2013 12:19:19 -0700 (PDT) From: Raj Hadoop Reply-To: Raj Hadoop Subject: Re: Where to get Oracle scripts for Hive Metastore To: Sanjay Subramanian , "user@hadoop.apache.org" , Hive In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="15747-2020412420-1369163959=:12981" X-Virus-Checked: Checked by ClamAV on apache.org --15747-2020412420-1369163959=:12981 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Sanjay -=0A=A0=0AThis is the first location I tried. But Apache Hive 0.9.0 = doesnt have an oracle folder. It only had mysql and derby.=0A=A0=0AThanks,= =0ARaj=0A=0A=0A________________________________=0AFrom: Sanjay Subramanian = =0ATo: "user@hadoop.apache.org" ; Raj Hadoop ; Hive =0ASent: Tuesday, May 21, 2013 3:12 PM=0ASubject: Re: Where to get O= racle scripts for Hive Metastore=0A=0A=0A=0ARaj=0A=0AThe correct location o= f the script is where u deflated the hive tar=A0=0A=0AFor example=A0=0A/usr= /lib/hive/scripts/metastore/upgrade/oracle=0A=0AYou will find a file in thi= s directory called=A0hive-schema-0.9.0.oracle.sql=0A=0AUse this=0A=0Asanjay= =0AFrom: Raj Hadoop =0AReply-To: "user@hadoop.apache.o= rg" , Raj Hadoop =0ADate: Tues= day, May 21, 2013 12:08 PM=0ATo: Hive , User =0ASubject: Where to get Oracle scripts for Hive Metastore= =0A=0A=0AI am trying to get Oracle scripts for Hive Metastore.=0A=0Ahttp://= mail-archives.apache.org/mod_mbox/hive-commits/201204.mbox/%3C2012042320130= 3.9742B2388860@eris.apache.org%3E=0A=0AThe scripts in the above link has a= =A0 + at the begining of each line. How should I supposed to execute script= s like this through Oracle sqlplus.=0A=0A+CREATE TABLE PART_COL_PRIVS=0A+(= =0A+=A0=A0=A0 PART_COLUMN_GRANT_ID NUMBER NOT NULL,=0A+=A0=A0=A0 "COLUMN_NA= ME" VARCHAR2(128) NULL,=0A+=A0=A0=A0 CREATE_TIME NUMBER (10) NOT NULL,=0A+= =A0=A0=A0 GRANT_OPTION NUMBER (5) NOT NULL,=0A+=A0=A0=A0 GRANTOR VARCHAR2(1= 28) NULL,=0A+=A0=A0=A0 GRANTOR_TYPE VARCHAR2(128) NULL,=0A+=A0=A0=A0 PART_I= D NUMBER NULL,=0A+=A0=A0=A0 PRINCIPAL_NAME VARCHAR2(128) NULL,=0A+=A0=A0=A0= PRINCIPAL_TYPE VARCHAR2(128) NULL,=0A+=A0=A0=A0 PART_COL_PRIV VARCHAR2(128= ) NULL=0A+);=0A+=0A=0A=0A=0A=0ACONFIDENTIALITY NOTICE=0A=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=0AThis email message and a= ny attachments are for the exclusive use of the intended recipient(s) and m= ay contain confidential and privileged information. Any unauthorized review= , use, disclosure or distribution is prohibited. If you are not the intende= d recipient, please contact the sender by reply email and destroy all copie= s of the original message along with any attachments, from your computer sy= stem. 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. --15747-2020412420-1369163959=:12981 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Sanjay -
 
This is the first location I = tried. But Apache Hive 0.9.0 doesnt have an oracle folder. It only had mysq= l and derby.
 
Thanks,
Raj

From: Sanjay Subramanian <Sanjay.Subra= manian@wizecommerce.com>
To: "user@hadoop.apache.org" <user@hadoop.apache.org>; Raj Hadoop= <hadoopraj@yahoo.com>; Hive <user@hive.apache.org>
Sent: Tuesday, May 21, 2013 3:12 P= M
Subject: Re: Where to = get Oracle scripts for Hive Metastore

Raj

The correct location of the script is where u deflated the hive tar&nb= sp;

For example 
/usr/lib/hive/scripts/metastore/upgrade/oracle

You will find a file in this directory called hive-schema-0.9.0.o= racle.sql

Use this

sanjay

From: Raj Hadoop <hado= opraj@yahoo.com>
Reply-To: "user@hadoop.apache.org" <= ;user@hadoop.apache.org>, Ra= j Hadoop <hadoopraj@yahoo.com>= ;
Date: Tuesday, May 21, 2013 12:08 PM
To: Hive <user@h= ive.apache.org>, User <us= er@hadoop.apache.org>
Subject: = Where to get Oracle scripts for Hive Metastore

I am trying to get Oracle scripts for Hive Metastore.
 
 
The scripts in the above link has a  + at the begining of each li= ne. How should I supposed to execute scripts like this through Oracle sqlpl= us.
 
+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,
+    GRANT= OR VARCHAR2(128) NULL,
+    GRANTOR_TYPE VARCHAR2(128) NU= LL,
+    PART_ID NUMBER NULL,
+    PRIN= CIPAL_NAME VARCHAR2(128) NULL,
+    PRINCIPAL_TYPE VARCHA= R2(128) NULL,
+    PART_COL_PRIV VARCHAR2(128) NULL
+)= ;
+
 
 

CONFIDENTIALITY NOTICE
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D
This email message and any attachments are f= or the exclusive use of the intended recipient(s) and may contain confident= ial 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 me= ssage 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 Admin= istrator.


--15747-2020412420-1369163959=:12981--