[ https://issues.apache.org/jira/browse/IMPALA-3268?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16928505#comment-16928505 ]
Brian Hansen commented on IMPALA-3268: -------------------------------------- The lack of SHOW VIEW impacts other software that is expecting this to function like Toad Data Point. > Add command "SHOW VIEWS" > ------------------------ > > Key: IMPALA-3268 > URL: https://issues.apache.org/jira/browse/IMPALA-3268 > Project: IMPALA > Issue Type: New Feature > Components: Catalog > Affects Versions: Impala 2.2.4, Impala 2.3.0, Impala 2.5.0 > Reporter: Eric Lin > Priority: Minor > Labels: usability > > 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. -- This message was sent by Atlassian Jira (v8.3.2#803003) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org