Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id BE16410EE4 for ; Wed, 26 Aug 2015 17:07:41 +0000 (UTC) Received: (qmail 43144 invoked by uid 500); 26 Aug 2015 17:07:38 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 43065 invoked by uid 500); 26 Aug 2015 17:07:38 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 43055 invoked by uid 99); 26 Aug 2015 17:07:38 -0000 Received: from Unknown (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 26 Aug 2015 17:07:38 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 5D44C181BC3 for ; Wed, 26 Aug 2015 17:07:38 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 3 X-Spam-Level: *** X-Spam-Status: No, score=3 tagged_above=-999 required=6.31 tests=[HTML_MESSAGE=3, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Received: from mx1-us-west.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id JY0UVekkoEum for ; Wed, 26 Aug 2015 17:07:29 +0000 (UTC) Received: from mail-ig0-f177.google.com (mail-ig0-f177.google.com [209.85.213.177]) by mx1-us-west.apache.org (ASF Mail Server at mx1-us-west.apache.org) with ESMTPS id F3CE420383 for ; Wed, 26 Aug 2015 17:07:28 +0000 (UTC) Received: by igcse8 with SMTP id se8so45898350igc.1 for ; Wed, 26 Aug 2015 10:07:28 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:content-type; bh=wYjY+koaFDEziPGkJe01xPdRCJ8/kr6p4XBlS7cvm+o=; b=OXxW84XJdt5E8+gbxD57hVgs/6xiUgonjT/YV7mfJ5PiwyJXIXSmznPbj4Kh5+5ddF Dxzo4jKLCGYnk5ceVuDqh/OrnYcbejzrWPMwM+9HImzFgbUlXDbnpnOmIu07Ptqlgyi/ 4II+0qGFt5RivzhpnBPNxUMfaCE2S12zjPEUJLvDRxLOhpHmALL7TUz+ORq3A3enzH4V wMzn7/lYchaCpaSApCQckbm5YlCX9EdOHpSsb70Oayz3jTpdTxf6ASOztHE7fgLETF0r WgKM1YfpM+lukA5B0+0mNrI138l4ffHtzbOZRaP4RIHt3VjZtr93cc9+opNZm9zWQSOI yUVA== X-Gm-Message-State: ALoCoQk3gkBkgv9unAXDUV5MnL1qPCG5P677mESY154wORG2SIN7wNcomGr+LHK18dZeNrim1Att MIME-Version: 1.0 X-Received: by 10.50.26.66 with SMTP id j2mr5194949igg.42.1440608847941; Wed, 26 Aug 2015 10:07:27 -0700 (PDT) Received: by 10.50.73.167 with HTTP; Wed, 26 Aug 2015 10:07:27 -0700 (PDT) In-Reply-To: References: <55DDDC40.9090609@gmail.com> Date: Wed, 26 Aug 2015 19:07:27 +0200 Message-ID: Subject: Re: HiveMetaStoreClient From: Subroto Sanyal To: user@hive.apache.org Content-Type: multipart/related; boundary=047d7bd75bb2a4b757051e39e297 --047d7bd75bb2a4b757051e39e297 Content-Type: multipart/alternative; boundary=047d7bd75bb2a4b753051e39e296 --047d7bd75bb2a4b753051e39e296 Content-Type: text/plain; charset=UTF-8 Hi Jerrick, HiveMetastoreClient will be using thrift communication internally via the connection. IMO It is no different from using thrift api. Cheers, Subroto Sanyal On Wed, Aug 26, 2015 at 6:44 PM, Jerrick Hoang wrote: > Ok, I'm super confused now. The hive metastore is a RDBMS database. I > totally agree that I shouldn't access it directly via jdbc. So what about > using this class > http://hive.apache.org/javadocs/r0.13.1/api/metastore/org/apache/hadoop/hive/metastore/HiveMetaStoreClient.html > ? Is it something that can only be used > > If not I can definitely use the thrift api. Just wanted to ask this before > going the thrift route because this class seems like the perfect tool for > me, > > Thanks > > On Wed, Aug 26, 2015 at 8:33 AM, Alan Gates wrote: > >> Accessing the RDBMS directly isn't recommended. We don't view the table >> layout as part of the public API and sometimes change things between >> releases. With the thrift API we at least try to keep it backwards >> compatible. >> >> Alan. >> >> Dr Mich Talebzadeh >> August 26, 2015 at 0:07 >> What is your hive metastore is on? >> >> If it is on an RDBMS, then you can simply use client/JDBC tools to access >> the metastore. Pretty simple. >> >> HTH, >> >> Jerrick Hoang >> August 25, 2015 at 23:27 >> Hi all, >> >> I want to interact with HiveMetaStore table from code and was looking at >> http://hive.apache.org/javadocs/r0.13.1/api/metastore/org/apache/hadoop/hive/metastore/HiveMetaStoreClient.html >> , was wondering if this is the correct way to do this or should I use a >> jdbc client. If HiveMetaStoreClient is the right way then how do I create a >> client given a hive-site.xml, >> >> Thanks, >> J >> >> > --047d7bd75bb2a4b753051e39e296 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Jerrick,
HiveMetastoreClient will be using thrift=C2=A0communicati= on=C2=A0internally via the connection. IMO It is no different from using th= rift api.

Cheers,
Subroto Sanyal
<= div class=3D"gmail_extra">
On Wed, Aug 26, 20= 15 at 6:44 PM, Jerrick Hoang <jerrickhoang@gmail.com> w= rote:
Ok, I'm super = confused now. The hive metastore is a RDBMS database. I totally agree that = I shouldn't access it directly via jdbc. So what about using this class= =C2=A0ht= tp://hive.apache.org/javadocs/r0.13.1/api/metastore/org/apache/hadoop/hive/= metastore/HiveMetaStoreClient.html ? Is it something that can only be u= sed=C2=A0

If not I can definitely use the thrift api. Ju= st wanted to ask this before going the thrift route because this class seem= s like the perfect tool for me,

Thanks=C2=A0
=
On Wed, Aug 26, 2015 at 8:33 AM, Alan Gates <alanfgates@gmail.com> wrote:
Accessing the RDBMS=20 directly isn't recommended.=C2=A0 We don't view the table layout as= part of=20 the public API and sometimes change things between releases.=C2=A0 With the= =20 thrift API we at least try to keep it backwards compatible.=C2=A0

Alan.

=20 August 26, 2015= =20 at 0:07
What= is your hive=20 metastore is on?

If it is on an RDBMS, then you can simply use=20 client/JDBC tools to access
the metastore. Pretty simple.

HTH,
=
=20 August 25, 2015= =20 at 23:27
Hi all,

I want to interact with HiveMetaStore table from code and was looking at=C2= =A0http:= //hive.apache.org/javadocs/r0.13.1/api/metastore/org/apache/hadoop/hive/met= astore/HiveMetaStoreClient.html , was wondering if this is the correct way to do this or should I use a jdbc client. If HiveMetaStoreClient is the right way then how do I=20 create a client given a hive-site.xml,

Thanks,
J


--047d7bd75bb2a4b753051e39e296-- --047d7bd75bb2a4b757051e39e297 Content-Type: image/jpeg; x-apple-mail-type=stationery; name="compose-unknown-contact.jpg" Content-Disposition: inline; filename="compose-unknown-contact.jpg" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: 6511cefe4e8269b0_0.1.1 /9j/4AAQSkZJRgABAQEARwBHAAD/2wBDAAEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQECAQEB AQEBAgICAgICAgICAgICAgICAgICAgICAgICAgICAgL/2wBDAQEBAQEBAQICAgICAgICAgICAgIC AgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgL/wAARCAAZABkDAREA AhEBAxEB/8QAGAAAAwEBAAAAAAAAAAAAAAAABgcICQr/xAA0EAABAwMCAgUKBwAAAAAAAAACAQME BQYRABITIQcUMUF2CBUXIjI2N0JRtVRWkZOV0dL/xAAYAQEAAwEAAAAAAAAAAAAAAAADAAEEAv/E ACQRAAICAAQGAwAAAAAAAAAAAAABAhEDMrHREyExM0FxgfDx/9oADAMBAAIRAxEAPwDuEt+gW/UL et6oVC3rfqNQqFv0OfPn1GhUqfOmzZtKZlS5UqZMaNwzNwiJVIl7eXLCaZIGwBl3TY8epPx2+jy2 ZNPjvkwc9uhW8j7nCPhvOsQliYIeS7cvCpp8o50qwrC4v3lsNSDbdmTEhvs2tahxpfV3WnmbbozJ Ew/gwdadbYExVRXKEKoSdvJcaOSqxE7/AAiX0gXx+a69/JSf9alIlste0VzaNpeFrcT9KKymotyi aZ0KRCnzacoE7Kjzn4gi2KqUh3jqDHDHv4mRUfruTWlMzlVUKIVNp9GguEJnAh0+IZjyAiisgyRD nu5azS8miKqjOTVkKqS/psG37fo1Fbabeg25b8eZPeFJBBJSjMG5HjMeyihnaauZwe4OGiju13GA cpOwBeN+U8/IkGbsiS8b7ryogmbzhbyc9REROfZhERO5ETShjPtvpGqTUyLErytS4siSwx5x2tRH 4hPOI0DkjZtaJtFxuVEbIUUiyeNujlBUJGbJN6nM/Cyf2Hf60YgjvKA+NPSP4gT7axpcPtr51YWJ nYn9dnAQWl722p4ot37yzqnlfp6FrqbwawG8/9k= --047d7bd75bb2a4b757051e39e297--