viirya commented on issue #27090: [SPARK-27545][SQL] Temporary view is not 
removed while uncaching the table
URL: https://github.com/apache/spark/pull/27090#issuecomment-570761486
 
 
   > maybe we should clearly document that `CACHE TABLE t1 as SELECT * FROM 
some_table;` means create a temp view and cache it. cc @viirya @dongjoon-hyun
   
   As shown above, `UNCACHE TABLE t`  where `t` could be created by `CACHE 
TABLE AS query` or a temp view created separately. I think it is hard to make 
`UNCACHE TABLE` command know which one is its target.
   
   Although `UNCACHE TABLE` cannot remove temp view if it is created by `CACHE 
TABLE AS query`, it seems not a serious issue. When trying to create another 
temp view with the same name, an error will be seen.
   
   Documenting it is a good idea.

----------------------------------------------------------------
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

Reply via email to