impala-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dimitris Tsirogiannis <dtsirogian...@cloudera.com>
Subject Re: Re: Impala Show Tables
Date Thu, 31 Aug 2017 07:52:05 GMT
Hi Sky,

You don't have many options if you really need SQL to access the tables
because Impala doesn't have an information schema (see
https://issues.apache.org/jira/browse/IMPALA-1761). What I was talking
about is a programmatic way to get that same information.

Dimitris

On Wed, Aug 30, 2017 at 7:09 PM, sky <x_hsky@163.com> wrote:

> Hi Dimitris,
> What you mean is to query the database that stores the impala metadata ?
> hive(mysql,pg,derby and so on) ?
>
>
>
>
>
>
>
>
> At 2017-08-30 16:41:40, "Dimitris Tsirogiannis" <
> dtsirogiannis@cloudera.com> wrote:
> >Hi sky,
> >
> >You could use HiveServer2 API (
> >https://github.com/apache/hive/blob/master/service-rpc/
> if/TCLIService.thrift)
> >to list the tables (see GetTables). Depending on your preference on
> >programming language, a number of clients exist that use this API (e.g.
> >https://github.com/cloudera/impyla).
> >
> >Dimitris
> >
> >On Wed, Aug 30, 2017 at 12:03 AM, sky <x_hsky@163.com> wrote:
> >
> >> Hi all,
> >>     In addition to "show tables" command, is there any other ways to
> show
> >> all the tables in impala ?
> >>     I need a way to handle collection of all tables through SQL, but
> "show
> >> tables"  can not be combined with SQL.
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message