[jira] [Commented] (IMPALA-3268) Add command "SHOW VIEWS"

["Brian Hansen (Jira)" <ji...@apache.org>]

    [ 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-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org