[IMPALA-3268] Add command "SHOW VIEWS"

• Type: New Feature
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: Impala 2.2.4, Impala 2.3.0, Impala 2.5.0
• Fix Version/s: Impala 4.4.0
• Component/s: Catalog
• Labels: usability
• Target Version: Product Backlog
• Assignee: Fang-Yu Rao
• Reporter: Eric Lin
• Created: 30/Mar/16 03:47
• Updated: 06/Dec/23 18:18
• Resolved: 06/Dec/23 18:18

Description

Currently to get a list of views, user has to:

• SHOW TABLES
• scan through the output list
• SHOW CREATE TABLE view_name to confirm view_name is a view

which is tedious.

So I would like to request the following:

• SHOW TABLES should only return tables
• SHOW VIEWS should only return views
• add a flag to either above commands to return all tables and views

This will help lots of end users.

Edit: Moved the first item and the third item out of the scope of this JIRA to IMPALA-12574 since more discussion may be required.

Issue Links

• relates to: IMPALA-1697 SHOW TABLES should also show type of table: table or view
• split to: IMPALA-12574 Consider extending SHOW TABLES statement so it only display tables