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