You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Fang-Yu Rao (Jira)" <ji...@apache.org> on 2023/11/23 05:23:00 UTC
[jira] [Updated] (IMPALA-3268) Add command "SHOW VIEWS"
[ https://issues.apache.org/jira/browse/IMPALA-3268?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Fang-Yu Rao updated IMPALA-3268:
--------------------------------
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.
was:
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.
> 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
> Assignee: Fang-Yu Rao
> 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.
> 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.
--
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