Re: Re: Impala Show Tables

[Dimitris Tsirogiannis]

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  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" <
> dtsirogian...@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  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.
>

Re: Impala Show Tables

[Dimitris Tsirogiannis]

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  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.