Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 233362009D9 for ; Thu, 19 May 2016 11:01:40 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 21D05160A04; Thu, 19 May 2016 09:01:40 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 43DAF160A00 for ; Thu, 19 May 2016 11:01:39 +0200 (CEST) Received: (qmail 28838 invoked by uid 500); 19 May 2016 09:01: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 28828 invoked by uid 99); 19 May 2016 09:01:38 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 19 May 2016 09:01:37 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 8EDFE1A5412 for ; Thu, 19 May 2016 09:01:37 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.179 X-Spam-Level: * X-Spam-Status: No, score=1.179 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx2-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id rfYGtqwpYDPj for ; Thu, 19 May 2016 09:01:33 +0000 (UTC) Received: from mail-qk0-f177.google.com (mail-qk0-f177.google.com [209.85.220.177]) by mx2-lw-eu.apache.org (ASF Mail Server at mx2-lw-eu.apache.org) with ESMTPS id 9687360CEF for ; Thu, 19 May 2016 09:01:32 +0000 (UTC) Received: by mail-qk0-f177.google.com with SMTP id n63so44207936qkf.0 for ; Thu, 19 May 2016 02:01:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to; bh=Ivpu25VaTPEHXZKDrukbcjzrSjiVlLQmbyLUwRpagug=; b=vm0OJGTWfoM2p95gnlL2303bKKM0/dzeBIcvhFw6a22yFmkNPPUAVxXldkVAVGbBGA hLkJus94NI3ZENnZRWu6eygoc/LiFlgAX0wseQhYqfV1nxlh4Xsvg0zVAI6DLf7ZZMOr 8+aZRO/8jywz3LOFtV//lbxbG1ZW9avgSraI5I1Y3E8CULJa7rU4PEWRV0z07EN+NhE8 fRlFXbP9fmGYYYPWbbvCG9dlBhRVhlPgi0E5JaKwoiJLE80NY6yIQp97GVf/QytHyEgy nAZMUGxSJtzGdd2T/IqFFl43+zzlImIe3iUG7ko/kd/M+YEsbA6HSPeBOgWCY9o/a6J3 POsw== 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; bh=Ivpu25VaTPEHXZKDrukbcjzrSjiVlLQmbyLUwRpagug=; b=Fquyes0W7X/AYShuOyogImxzR5KGWli9jAorhxDnRRcJ/DCR/cMw17UrrDObUPGIrx n4DdzOZDGgeDdzuPzXA9k4fuTCJfWRwG9waN6QeGXvKRsCJ57om4iaJt9qxU3TEj1azk Wuyj3z+P+fGVZRo7Ih+rxjnOJcCeXXHzbCABG7s4CRJJeYbeZnFBDxqmdvsIdNseboDo rYZMmRAErMFFV5KzPSZvi9+G7sKf8uqjEl53TwnfH8C3LWJV1G5DyDZQZEkYqs2/wsRx IrSghmZBFrk0gl+nWNEkUmvl1/XNuRDuLTwOGL81LYjai7TSYar5mKxm2kyY60NFx3uS a91g== X-Gm-Message-State: AOPr4FUQfVYsIrxTvwDqsFXgXjQARNDoS9WuubUndzJAZgKPa8f1Ff3QGNi8gQl63luiDThHYYx4P5ADo52o3g== MIME-Version: 1.0 X-Received: by 10.55.212.71 with SMTP id l68mr13279381qki.123.1463648491743; Thu, 19 May 2016 02:01:31 -0700 (PDT) Received: by 10.55.126.131 with HTTP; Thu, 19 May 2016 02:01:31 -0700 (PDT) In-Reply-To: References: Date: Thu, 19 May 2016 10:01:31 +0100 Message-ID: Subject: Re: Hive system catalog From: Mich Talebzadeh To: user Content-Type: multipart/alternative; boundary=001a1149d2be6d32e105332e38b6 archived-at: Thu, 19 May 2016 09:01:40 -0000 --001a1149d2be6d32e105332e38b6 Content-Type: text/plain; charset=UTF-8 The Hive 2 metastore with concurrency capability has 194 tables, 127 views and 38 relationships for a metastore created on Oracle 12c I have created an Entity-Relationship diagram but need to decide in what format to post it Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw * http://talebzadehmich.wordpress.com On 19 May 2016 at 04:51, Mich Talebzadeh wrote: > Hi Braj, > > Any tool GUI or OS level can log in and see the schema created for Hive. > > For example my metadata for Hive is on Oracle and I can use SQL Developer > Data Model to create a logical model from the physical model > > HTH > > Dr Mich Talebzadeh > > > > LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw > * > > > > http://talebzadehmich.wordpress.com > > > > On 19 May 2016 at 03:34, brajmohan saxena > wrote: > >> Hi, >> >> Could any body please help me to know how to get the Hive system catalog >> tables. >> Also I am looking for a catalog table which can show me all the built in >> functions list of Hive. >> >> Thanks in advance. >> >> Regards >> Braj >> > > --001a1149d2be6d32e105332e38b6 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
The Hive 2 metastore with concurrency capability has = 194 tables, 127 views and 38 relationships for a metastore created on Oracl= e 12c

I have created an Entity-Relationship diagr= am but need to decide in what format to post it


On 19 May 2016 at 04:51, Mich Talebzadeh <mich.talebzadeh@gmail.com> wrote:
Hi Braj,

Any t= ool GUI or OS level can log in and see the schema=C2=A0=C2=A0created for Hi= ve.

For example my metadata for Hive is on Oracle = and I can use SQL Developer Data Model to create a logical model from the p= hysical model

HTH


On 19 May 2016 at 03:34, brajmohan saxena <braj.saxena.13@gmail.com> wrote:
=
Hi,

Could any body please help me to kn= ow how to get the Hive system catalog tables.
Also I am looking f= or a catalog table which can show me all the built in functions list of Hiv= e.

Thanks in advance.

Reg= ards
Braj


--001a1149d2be6d32e105332e38b6--