We frequently use the SHOW TABLES command to display a list of all the tables in the current database. If the list is too long, however, we choose to search the table we need.
We may use the LIKE operator in conjunction with the show tables command to filter the list, as seen below.
SHOW TABLES LIKE pattern.
Example:
SHOW TABLES LIKE ‘test*’;
We used the percentage symbol (%) to filter the tables in most RDBMSs, however we use asterisk (*) in Impala.
Hope you find this article helpful.
Please subscribe for more interesting updates.
Big Data and SQL 