francis-du opened a new issue, #3842: URL: https://github.com/apache/arrow-datafusion/issues/3842
**Is your feature request related to a problem or challenge? Please describe what you are trying to do.** Currently, DataFrame can cache tables in memory, but cannot cache DataFusion tables or views through SQL. **Describe the solution you'd like** I want to cache views and tables via `CACHE TABLE <table_name>` syntax like Spark SQL.At the same time, it is also necessary to support the `UNCACHE TABLE <table_name>` syntax to allow users to delete tables and views that do not require caching in memory. Here are some docs about`CACHE TABLE` and `UNCACHE TABLE` in Spark SQL: 1.`CACHE TABLE`: https://docs.databricks.com/spark/latest/spark-sql/language-manual/sql-ref-syntax-aux-cache-cache-table.html 2.`UNCACHE TABLE`: https://docs.databricks.com/spark/latest/spark-sql/language-manual/sql-ref-syntax-aux-cache-uncache-table.html **Describe alternatives you've considered** I has been implemented the syntax in https://github.com/sqlparser-rs/sqlparser-rs/pull/670, I will support it in DataFusion next, if anyone is interested, welcome to discuss here. -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
