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 036A717494 for ; Wed, 26 Aug 2015 07:37:11 +0000 (UTC) Received: (qmail 75855 invoked by uid 500); 26 Aug 2015 07:37:09 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 75781 invoked by uid 500); 26 Aug 2015 07:37:09 -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 75771 invoked by uid 99); 26 Aug 2015 07:37:09 -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 07:37:09 +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 B623BC028F for ; Wed, 26 Aug 2015 07:37:08 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.98 X-Spam-Level: ** X-Spam-Status: No, score=2.98 tagged_above=-999 required=6.31 tests=[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 Received: from mx1-us-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 HH53m7YV-Z86 for ; Wed, 26 Aug 2015 07:37:02 +0000 (UTC) Received: from mail-ig0-f180.google.com (mail-ig0-f180.google.com [209.85.213.180]) by mx1-us-west.apache.org (ASF Mail Server at mx1-us-west.apache.org) with ESMTPS id 1D29B20382 for ; Wed, 26 Aug 2015 07:37:01 +0000 (UTC) Received: by igbjg10 with SMTP id jg10so33250741igb.0 for ; Wed, 26 Aug 2015 00:37:01 -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=NM6+dE3u4td/cEKM5BqCYtY4WAmTCR52WlTXQPwCgps=; b=F5fgxSGeTBSXUkwXa7vhAOdGFQdIDX/SVPy1c0MZvtjxcb30jtpGthWzjN1c84kps9 r+zTxYCAAxY2h9xoQu93atZWMG/ljqBkKEsX/L/t9xIRoGRMC3aU0BEpblUGXH/mRF/N SMpqsj3nldV+8kghynyyzkN2/yBDUhkeBlUKRKqzbdJbL9pnQlIsgmzRxxyWS3Lo8WV9 acaRzCP0lBrABwxbss8beI0jkK7kzjbvjUrTpo1qYuI5sL6UFEdvjcH3xrSuYhoEQhDG 9fVz7eKHUk69N/9vetGwBZDgl4v2e63PBiLjHbbofCBoTZwzqh7yczKPUj4AjTi5l9lW 0Kag== X-Gm-Message-State: ALoCoQkcsC8JZXLraWA6gYR6LvJpJeYVL+B0CX7o7kNQEDVbdAn/XfEv44tl2tUmNw/VmHjNNifN MIME-Version: 1.0 X-Received: by 10.50.26.66 with SMTP id j2mr1637391igg.42.1440574621174; Wed, 26 Aug 2015 00:37:01 -0700 (PDT) Received: by 10.50.73.167 with HTTP; Wed, 26 Aug 2015 00:37:01 -0700 (PDT) In-Reply-To: References: Date: Wed, 26 Aug 2015 09:37:01 +0200 Message-ID: Subject: Re: HiveMetaStoreClient From: Subroto Sanyal To: user@hive.apache.org Content-Type: multipart/alternative; boundary=047d7bd75bb2916e0a051e31ea71 --047d7bd75bb2916e0a051e31ea71 Content-Type: text/plain; charset=UTF-8 hi Jerrick Yes, thats the correct way to interact with HiveMetastore(provided you are only interested to play around metadata and Hive Metastore Service is accessible from the java client). Further, you can try the Hive JDBC driver or Hive Server2 thrift API (couldn't find the documentation for this but, it works for me) to access the metadata and physical data. On Wed, Aug 26, 2015 at 9:07 AM, Dr Mich Talebzadeh wrote: > > 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, > > On 26/8/2015, "Jerrick Hoang" wrote: > > >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 > > > > > --047d7bd75bb2916e0a051e31ea71 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
hi Jerrick

Yes, thats the correct way t= o interact with HiveMetastore(provided you are only interested to play arou= nd metadata and Hive Metastore Service is accessible from the java client).=
Further, you can try the Hive JDBC driver or Hive Server2 thrift= API (couldn't find the documentation for this but, it works for me) to= access the metadata and physical data.=C2=A0

On Wed, Aug 26, 2015 at 9:07 AM, Dr= Mich Talebzadeh <mich@peridale.co.uk> wrote:

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,

On 26/8/2015, "Jerrick Hoang" <jerrickhoang@gmail.com> wrote:

>Hi all,
>
>I want to interact with HiveMetaStore table from code and was looking a= t
>http://hive.apache.org/javadocs/r0.13.1/api/metastore/org/ap= ache/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 crea= te a
>client given a hive-site.xml,
>
>Thanks,
>J
>
>

--047d7bd75bb2916e0a051e31ea71--