Impala: Show tables like query

hive cloudera hiveql cloudera-cdh impala
Manindar picture Manindar · Mar 24, 2017 · Viewed 24.4k times · Source

I am working with Impala and fetching the list of tables from the database with some pattern like below.

Assume i have a Database bank, and tables under this database are like below.

cust_profile
cust_quarter1_transaction
cust_quarter2_transaction
product_cust_xyz
....
....
etc

Now i am filtering like

show tables in bank like '*cust*'

It is returning the expected results like, which are the tables has a word cust in its name.

Now my requirement is i want all the tables which will have cust in its name and table should not have quarter2.

Can someone please help me how to solve this issue.

Answer

David דודו Markovitz picture David דודו Markovitz · Mar 24, 2017

Execute from the shell and then filter

impala-shell -q "show tables in bank like '*cust*'" | grep -v 'quarter2'

Related questions

No partition predicate found for Alias even when the partition predicate in present in the query

I have a table pos.pos_inv in hdfs which is partitioned by yyyymm. Below is the query: select DATE_ADD(to_date(from_unixtime(unix_timestamp(Inv.actvydt, 'MM/dd/yyyy'))),5), to_date(from_unixtime(unix_timestamp(Inv.actvydt, …

Read More
Hive External Table Skip First Row

I am using Cloudera's version of Hive and trying to create an external table over a csv file that contains the column names in the first column. Here is the code that I am using to do that. CREATE EXTERNAL …

Read More
beeline not able to connect to hiveserver2

I have a CDH 5.3 instance. I start the hive-server2 by first starting the hive-metastore and then the hive-server from command line. After this I use beeline to connect to my hive-server2 but apparently it is not able to so. Could …

Read More