[GitHub] [spark] dilipbiswal commented on pull request #29034: [SPARK-32219][SQL] Add SHOW CACHED TABLES Command

[GitBox <gi...@apache.org>]

dilipbiswal commented on pull request #29034:
URL: https://github.com/apache/spark/pull/29034#issuecomment-655968115


   @maropu @viirya Also, i was thinking, if we want to make this information available from one of the `SHOW` commands, can we not extend show tables to show another attribute `isCached` ? Do we need a special syntax for it ? I guess, the one advantage of this command is that it acts as a filter and only shows the cached tables. But having this in one command give a complete view of all the tables, regular, temporary and cached tables.
   
   And we could apply filter to only see individual table types.
   
   ```
   spark.sql("show tables").where("isCached= true").show
   spark.sql("show tables").where("isTemporary= true").show
   ```
   
   What do you guys think ?


----------------------------------------------------------------
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:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org