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 7071C10EDC for ; Wed, 26 Aug 2015 17:06:22 +0000 (UTC) Received: (qmail 38424 invoked by uid 500); 26 Aug 2015 17:06:20 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 38350 invoked by uid 500); 26 Aug 2015 17:06:20 -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 38329 invoked by uid 99); 26 Aug 2015 17:06:20 -0000 Received: from Unknown (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 26 Aug 2015 17:06:20 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 0B548C0250 for ; Wed, 26 Aug 2015 17:06:20 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.88 X-Spam-Level: ** X-Spam-Status: No, score=2.88 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=3, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-eu-west.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id IDx_w4pu9viV for ; Wed, 26 Aug 2015 17:06:09 +0000 (UTC) Received: from mail-la0-f67.google.com (mail-la0-f67.google.com [209.85.215.67]) by mx1-eu-west.apache.org (ASF Mail Server at mx1-eu-west.apache.org) with ESMTPS id 81AB7334FA for ; Wed, 26 Aug 2015 17:06:08 +0000 (UTC) Received: by labqb2 with SMTP id qb2so4466450lab.1 for ; Wed, 26 Aug 2015 10:06:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :content-type; bh=cDirI8x1CZB7ZkKFKUa+u8KHLP2LMrMvLSoyA7PV8MY=; b=RPKCf97MgdPPXtwS41jm1+03+L3DuyPa7uqAp952Fm1YkuXCD2HjAumVNTEcHECxX4 5tYaon5gBukwhhxAluzdM9DrxgaB+iy/3iszvkBuacbqPg2dQQEw4g4QKW1jOsC5iaZl 6puiWROOykZZDtSItgkSrc/k8ZgSEpSD7wUDUqOJidxi/UH2w65hcdDnIJ2rbWn+BZfy O7u/wZll3VM2zBQv2uN1LfeIdRWeRf1HFNsLkq0bdyqJZWTz4xzKAPuwJTTb6PJevVp3 7ZAqvLrPrS/NzE/qx48qDb9iE0OdAj38Xg32z2iPRKgtVcrSRdLrTmVdedrv6Fbstd8y lrTQ== X-Received: by 10.152.243.9 with SMTP id wu9mr28873062lac.41.1440608762675; Wed, 26 Aug 2015 10:06:02 -0700 (PDT) MIME-Version: 1.0 References: <55DDDC40.9090609@gmail.com> In-Reply-To: From: =?UTF-8?B?SsO2cm4gRnJhbmtl?= Date: Wed, 26 Aug 2015 17:05:52 +0000 Message-ID: Subject: Re: HiveMetaStoreClient To: user@hive.apache.org Content-Type: multipart/related; boundary=001a11342c2c8f6302051e39dd37 --001a11342c2c8f6302051e39dd37 Content-Type: multipart/alternative; boundary=001a11342c2c8f6300051e39dd36 --001a11342c2c8f6300051e39dd36 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Why not use hcatalog web service api? Le mer. 26 ao=C3=BBt 2015 =C3=A0 18:44, Jerrick Hoang a =C3=A9crit : > 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/h= ive/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 befor= e > 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 acces= s >> 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 creat= e a >> client given a hive-site.xml, >> >> Thanks, >> J >> >> > --001a11342c2c8f6300051e39dd36 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Why not use hcatalog web service api?


Le=C2=A0mer. 26 ao=C3=BBt 2= 015 =C3=A0 18:44,=C2=A0Jerrick Hoang <jerrickhoang@gmail.com> a =C3=A9crit=C2=A0:
Ok, I'm super confused now. Th= e 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=A0http://hive.apache= .org/javadocs/r0.13.1/api/metastore/org/apache/hadoop/hive/metastore/HiveMe= taStoreClient.html ? Is it something that can only be used=C2=A0
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 perfe= ct tool for me,

Thanks=C2=A0

On Wed, Aug 26, 2015 at 8:3= 3 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

--001a11342c2c8f6300051e39dd36-- --001a11342c2c8f6302051e39dd37 Content-Type: image/jpeg; name="compose-unknown-contact.jpg" Content-Disposition: inline; filename="compose-unknown-contact.jpg" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: part1.07050003.08090809@gmail.com /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= --001a11342c2c8f6302051e39dd37--