Details
-
New Feature
-
Status: In Progress
-
Major
-
Resolution: Unresolved
-
3.1.0
-
None
-
None
Description
Intention is to support show tables with a additional column 'type' where type can be MANAGED,EXTERNAL,VIEW using which user can query only tables of required types, like listing only views or only external tables (using a 'where' clause over 'type' column).
Usecase example:
Currently its not possible to list all the VIEWS, but other technologies like hive support it using 'SHOW VIEWS', mysql supports it using a more complex query 'SHOW FULL TABLES WHERE table_type = 'VIEW';'
Decide to take mysql approach as it provides more flexibility for querying.
Attachments
Issue Links
- links to