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" <[email protected]>
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 <[email protected]> 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.