[ https://issues.apache.org/jira/browse/HIVE-21301?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Work on HIVE-21301 started by Jesus Camacho Rodriguez. ------------------------------------------------------ > Show tables statement to include views and materialized views > ------------------------------------------------------------- > > Key: HIVE-21301 > URL: https://issues.apache.org/jira/browse/HIVE-21301 > Project: Hive > Issue Type: Bug > Affects Versions: 4.0.0, 3.2.0 > Reporter: Jesus Camacho Rodriguez > Assignee: Jesus Camacho Rodriguez > Priority: Major > > HIVE-19974 introduced backwards incompatible change, with {{SHOW TABLES}} > statement showing only managed/external tables in the system. > This issue will restore old behavior, with {{SHOW TABLES}} showing all > queryable entities, including views and materialized views. > Instead, to provide information about table types, {{SHOW EXTENDED TABLES}} > statement is introduced, which includes an additional column with the table > type for each of the tables listed. > Besides, the possibility to filter the show tables statements with a {{WHERE > `table_type` = 'ANY_TYPE'}} clause is introduced. -- This message was sent by Atlassian JIRA (v7.6.3#76005)