Mailing-List: contact user-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hadoop.apache.org
Received-SPF: pass (nike.apache.org: local policy)
Message-ID: 
 <2043070230-1368848540-cardhu_decombobulator_blackberry.rim.net-1479863117-@b4.c16.bise7.blackberry>
Reply-To: bejoy_ks@yahoo.com
References: <1368835807.17419.YahooMailNeo@web162203.mail.bf1.yahoo.com>
In-Reply-To: <1368835807.17419.YahooMailNeo@web162203.mail.bf1.yahoo.com>
Sensitivity: Normal
Importance: Normal
Subject: Re: Hive on Oracle
To: user@hive.apache.org,"Raj Hadoop" <hadoopraj@yahoo.com>,"User"
 <user@hadoop.apache.org>
From: bejoy_ks@yahoo.com
Date: Sat, 18 May 2013 03:42:26 +0000
Content-Type: multipart/alternative;
 boundary="part1978-boundary-1691714310-1974419729"
MIME-Version: 1.0


--part1978-boundary-1691714310-1974419729
Content-Type: text/plain; charset="Windows-1252"

Hi

The procedure is same as setting up mysql metastore. You need to use the jdbc driver/jar corresponding to the oracle version/release you are intending to use.

Regards 
Bejoy KS

Sent from remote device, Please excuse typos

-----Original Message-----
From: Raj Hadoop <hadoopraj@yahoo.com>
Date: Fri, 17 May 2013 17:10:07 
To: Hive<user@hive.apache.org>; User<user@hadoop.apache.org>
Reply-To: user@hive.apache.org
Subject: Hive on Oracle

Hi,

I am planning to install Hive and want to set up Meta store on Oracle. What is the procedure? Which driver (JDBC) do I need to use it?


Thanks,
Raj


--part1978-boundary-1691714310-1974419729
Content-Transfer-Encoding: base64
Content-Type: text/html; charset="Windows-1252"

PGh0bWw+PGJvZHk+SGk8YnIvPjxici8+VGhlIHByb2NlZHVyZSBpcyBzYW1lIGFzIHNldHRpbmcg
dXAgbXlzcWwgbWV0YXN0b3JlLiBZb3UgbmVlZCB0byB1c2UgdGhlIGpkYmMgZHJpdmVyL2phciBj
b3JyZXNwb25kaW5nIHRvIHRoZSBvcmFjbGUgdmVyc2lvbi9yZWxlYXNlIHlvdSBhcmUgaW50ZW5k
aW5nIHRvIHVzZS48YnIvPjxkaXY+UmVnYXJkcyA8YnIvPkJlam95IEtTPGJyLz48YnIvPlNlbnQg
ZnJvbSByZW1vdGUgZGV2aWNlLCBQbGVhc2UgZXhjdXNlIHR5cG9zPC9kaXY+PGhyLz48ZGl2Pjxi
PkZyb206IDwvYj4gUmFqIEhhZG9vcCAmbHQ7aGFkb29wcmFqQHlhaG9vLmNvbSZndDsNCjwvZGl2
PjxkaXY+PGI+RGF0ZTogPC9iPkZyaSwgMTcgTWF5IDIwMTMgMTc6MTA6MDcgLTA3MDAgKFBEVCk8
L2Rpdj48ZGl2PjxiPlRvOiA8L2I+SGl2ZSZsdDt1c2VyQGhpdmUuYXBhY2hlLm9yZyZndDs7IFVz
ZXImbHQ7dXNlckBoYWRvb3AuYXBhY2hlLm9yZyZndDs8L2Rpdj48ZGl2PjxiPlJlcGx5VG86IDwv
Yj4gdXNlckBoaXZlLmFwYWNoZS5vcmcNCjwvZGl2PjxkaXY+PGI+U3ViamVjdDogPC9iPkhpdmUg
b24gT3JhY2xlPC9kaXY+PGRpdj48YnIvPjwvZGl2PjxkaXYgc3R5bGU9ImNvbG9yOiMwMDA7IGJh
Y2tncm91bmQtY29sb3I6I2ZmZjsgZm9udC1mYW1pbHk6dGltZXMgbmV3IHJvbWFuLCBuZXcgeW9y
aywgdGltZXMsIHNlcmlmO2ZvbnQtc2l6ZToxMnB0Ij48ZGl2PkhpLDwvZGl2PjxkaXY+PGJyPjwv
ZGl2PjxkaXYgc3R5bGU9ImNvbG9yOiByZ2IoMCwgMCwgMCk7IGZvbnQtc2l6ZTogMTZweDsgZm9u
dC1mYW1pbHk6IHRpbWVzIG5ldyByb21hbixuZXcgeW9yayx0aW1lcyxzZXJpZjsgYmFja2dyb3Vu
ZC1jb2xvcjogdHJhbnNwYXJlbnQ7IGZvbnQtc3R5bGU6IG5vcm1hbDsiPkkgYW0gcGxhbm5pbmcg
dG8gaW5zdGFsbCBIaXZlIGFuZCB3YW50IHRvIHNldCB1cCBNZXRhIHN0b3JlIG9uIE9yYWNsZS4g
V2hhdCBpcyB0aGUgcHJvY2VkdXJlPyBXaGljaCBkcml2ZXIgKEpEQkMpIGRvIEkgbmVlZCB0byB1
c2UgaXQ/PGJyPjwvZGl2PjxkaXYgc3R5bGU9ImNvbG9yOiByZ2IoMCwgMCwgMCk7IGZvbnQtc2l6
ZTogMTZweDsgZm9udC1mYW1pbHk6IHRpbWVzIG5ldyByb21hbixuZXcgeW9yayx0aW1lcyxzZXJp
ZjsgYmFja2dyb3VuZC1jb2xvcjogdHJhbnNwYXJlbnQ7IGZvbnQtc3R5bGU6IG5vcm1hbDsiPjxi
cj48L2Rpdj48ZGl2IHN0eWxlPSJjb2xvcjogcmdiKDAsIDAsIDApOyBmb250LXNpemU6IDE2cHg7
IGZvbnQtZmFtaWx5OiB0aW1lcyBuZXcgcm9tYW4sbmV3IHlvcmssdGltZXMsc2VyaWY7IGJhY2tn
cm91bmQtY29sb3I6IHRyYW5zcGFyZW50OyBmb250LXN0eWxlOiBub3JtYWw7Ij5UaGFua3MsPC9k
aXY+PGRpdiBzdHlsZT0iY29sb3I6IHJnYigwLCAwLCAwKTsgZm9udC1zaXplOiAxNnB4OyBmb250
LWZhbWlseTogdGltZXMgbmV3IHJvbWFuLG5ldyB5b3JrLHRpbWVzLHNlcmlmOyBiYWNrZ3JvdW5k
LWNvbG9yOiB0cmFuc3BhcmVudDsgZm9udC1zdHlsZTogbm9ybWFsOyI+UmFqPC9kaXY+PC9kaXY+
PC9ib2R5PjwvaHRtbD4NCg==

--part1978-boundary-1691714310-1974419729--