[IMPALA-8738] Add a column representing the type（table or view） in the show tables output

• Type: Improvement
• Status: In Progress
• Priority: Minor
• Resolution: Unresolved
• Component/s: Catalog, Frontend
• Labels: features
• Epic Color: ghx-label-7
• Assignee: baotuquan
• Reporter: baotuquan
• Created: 03/Jul/19 08:14
• Updated: 16/Oct/19 01:21

Description

Now the output of the show tables command in the system is as follows：

default> show tables;
Query: show tables
+----------+
| name |
+----------+
| table1 |
| view1 |
+----------+

I think we should add a column for the representation type，The output should be like this

default> show tables;
Query: show tables
+---------------+
| name | type |
+----------------+
| table1 |  table   |
| view1 |   view   |
+----------------+

 

Issue Links

• relates to: HIVE-21301 Show tables statement to include views and materialized views

Sub-Tasks

• Impala Doc: Document the new SHOW EXTENDED TABLE statement: Open