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

["Nitesh Yadav (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IMPALA-3268?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17773848#comment-17773848 ] 

Nitesh Yadav commented on IMPALA-3268:
--------------------------------------

The lack of `show view` impacts the performance of the [dbt-impala|https://github.com/cloudera/dbt-impala] adapter.  

> 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.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org