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 68B1F200C4E for ; Fri, 7 Apr 2017 06:14:54 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 6745A160B91; Fri, 7 Apr 2017 04:14:54 +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 B86C8160B9F for ; Fri, 7 Apr 2017 06:14:53 +0200 (CEST) Received: (qmail 90823 invoked by uid 500); 7 Apr 2017 04:14:52 -0000 Mailing-List: contact dev-help@impala.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@impala.incubator.apache.org Delivered-To: mailing list dev@impala.incubator.apache.org Received: (qmail 90685 invoked by uid 99); 7 Apr 2017 04:14:52 -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; Fri, 07 Apr 2017 04:14:52 +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 E3E2D1A0103; Fri, 7 Apr 2017 04:14:51 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.93 X-Spam-Level: * X-Spam-Status: No, score=1.93 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_ENVFROM_END_DIGIT=0.25, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RCVD_IN_SORBS_SPAM=0.5, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-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 nQLQ5Co5x5Px; Fri, 7 Apr 2017 04:14:48 +0000 (UTC) Received: from mail-it0-f54.google.com (mail-it0-f54.google.com [209.85.214.54]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 9EA855F1E9; Fri, 7 Apr 2017 04:14:47 +0000 (UTC) Received: by mail-it0-f54.google.com with SMTP id y18so113121537itc.0; Thu, 06 Apr 2017 21:14:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=vHq7SQWWWoh+2B1TJ/id8Mu4F4UKVM5sGypLn9F6t3I=; b=rbLL4kWgMuTx3NLKI6N3tft0Dgl1YjYedJMB/Pxs88S/dnaAmyS527JqZBGi6S1DHi W2gvlEOnPspCN/Pmur0m5iU1g21WiKislRNKvGrgI1Q4gF/2/6ZYPTsppbwfgqliHXzp hUTmYwFQWlLUc7RuAnKcWh0EeGTqIQ5DwFMChk0bA+l4d1NTekgCtKx/E0pjIu3MYa04 cPpXebLAS7dsT2uFE0pnnP4aXqreyR8f1JZUR/XY5BzpUFLT4TV7ZXKRQpejz1lB9wgP ET0fL+zWRhlyW1uPmdzJwOuv1Yq1BglT0rNgctkxgS6iBGnpvPWDBzp1xcR35OKJu56y rInw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=vHq7SQWWWoh+2B1TJ/id8Mu4F4UKVM5sGypLn9F6t3I=; b=uGYOM3t5vT19faeU6KN5Q/SkejhkXvcIqHIK5DS4Bu2IN5w9uJb6RcTEai4/PeNymo EwGAmuJEZ4lmmAXWjhUaWNFw0EihkEDwqB0QxgyLsnppDm7FkmUZnJuUAks09ppDesBj eKLHREfZ4Qb9qHXtOJC308CTBSbEAVYZFeuc8Dm5iJ1wQbhlTYY5hv9zZABvRWcQsXwD /t4JF7Ng+qsW9UkS7zIcf4J1LcUdpXKC/ugezUubi6Gih0ChR21w2JqORCj+Gn1FSPy3 sVVb8Ran6IJQ3nTQ6qL8Jgohp1jLufyqhd7Zu1V+73WEEcviTCm89+R5DgTU9Wzmrhj+ OuLA== X-Gm-Message-State: AFeK/H0zsZIRkru6PQ50pjt5VGlOHn1cQhY3WdsMSnjvU1RxSVab+Zeu BSw/1mh+YSLlRE1nFDUem+770sfRpA== X-Received: by 10.36.134.65 with SMTP id u62mr28996920itd.34.1491538480065; Thu, 06 Apr 2017 21:14:40 -0700 (PDT) MIME-Version: 1.0 Received: by 10.107.27.10 with HTTP; Thu, 6 Apr 2017 21:14:39 -0700 (PDT) In-Reply-To: References: From: =?UTF-8?B?5ZC05pyx5Y2O?= Date: Fri, 7 Apr 2017 12:14:39 +0800 Message-ID: Subject: Re: Is there any way to retrieve table metadata using select rather than show? To: Lars Volker Cc: user@impala.incubator.apache.org, user@impala.apache.org, "dev@impala" Content-Type: multipart/alternative; boundary=94eb2c088fb8461587054c8bdde2 archived-at: Fri, 07 Apr 2017 04:14:54 -0000 --94eb2c088fb8461587054c8bdde2 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Lars=EF=BC=9A I have checked the code, the feature may involve some changes on optimizer or analyzer side. It's a big change. I am looking forward to make more minor contribution, just to experience whole process^_^ 2017-04-06 21:20 GMT+08:00 Lars Volker : > Adding support to expose the metadata as tables is tracked in IMPALA-1761 > . We would welcome > your contribution to this. > > On Thu, Apr 6, 2017 at 3:16 PM, Jeszy wrote: > >> Hey, >> >> that's not possible from within impala. If you go directly to the >> HMS's backing DB, you can query that. >> What information are you looking for? >> >> Thanks. >> >> On Thu, Apr 6, 2017 at 3:02 PM, =E5=90=B4=E6=9C=B1=E5=8D=8E wrote: >> > Hi guys: >> > >> > Currently, we are using "show databases","show tables" or "Describe >> table" >> > to retrieve table metadata, but we use such as "select * from metadata= " >> to >> > retrieve, just like RDBMS did^_^ >> > > --94eb2c088fb8461587054c8bdde2--