ajithme opened a new pull request #27214: [SPARK-30517] Support SHOW TABLES EXTENDED URL: https://github.com/apache/spark/pull/27214 WIP : Proposal ### What changes were proposed in this pull request? Added a syntax for `SHOW TABLES EXTENDED` which can output a additional column compared to `SHOW TABLES` which prints the table type with possible values `MANAGED,EXTERNAL,VIEW` ### Why are the changes needed? 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. ### Does this PR introduce any user-facing change? Yes. New option `EXTENDED` for `SHOW TABLES` command ### How was this patch tested? TODO: 1. Add UTs 2. `where` clause support 3. V2 catalog support
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org
