[
https://issues.apache.org/jira/browse/IMPALA-8738?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16894317#comment-16894317
]
baotuquan commented on IMPALA-8738:
-----------------------------------
{{> describe extended <table/view name>}}
{{There is a "Table Type" in the return value, the value can be
"VIRTUAL_VIEW","MANAGED_TABLE" or "EXTERNL_TABLE"}}
{{So I need to first get the table name through "show tables", and then recycle
the type corresponding to each table name.The function can be implemented, but
it is not efficient if there are many tables.}}
{{What do you think of making an extension to the command "show table"?}}{{
The return value are fields those are in both the properties of table and
view.}}
For example "show extended tables".
>show extended tables;
+-------------------------------+
| name | table type |
+-------------------------------+
| table1 | MANAGED_TABLE |
| table2 | EXTERNAL_TABLE |
| view1 | VIRTUAL_VIEW |
+-------------------------------+
> Add a column representing the type（table or view） in the show tables output
> ---------------------------------------------------------------------------
>
> Key: IMPALA-8738
> URL: https://issues.apache.org/jira/browse/IMPALA-8738
> Project: IMPALA
> Issue Type: Improvement
> Components: Catalog, Frontend
> Reporter: baotuquan
> Assignee: baotuquan
> Priority: Minor
> Labels: features
>
> Now the output of the +*show tables*+ command in the system is as follows：
> {code:java}
> default> show tables;
> Query: show tables
> +----------+
> | name |
> +----------+
> | table1 |
> | view1 |
> +----------+
> {code}
> I think we should add a column for the representation type，The output should
> be like this
> {code:java}
> default> show tables;
> Query: show tables
> +---------------+
> | name | type |
> +----------------+
> | table1 | table |
> | view1 | view |
> +----------------+
> {code}
>
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org
For additional commands, e-mail: issues-all-h...@impala.apache.org
