Hi Everyone, I'm currently looking to understand the caching mechanism in Apache Flink in general. As part of this exploration, I have a few questions related to how Flink handles data caching, both in the context of SQL queries and more broadly.
When I send a SQL query for example to PostgreSQL through Flink, does Flink cache the data? If the same SQL query is executed again, does Flink retrieve the results faster, indicating potential caching mechanisms? If caching does occur, where does Flink store the cached data? I'm using RocksDB as a StateBackend. Is there any documentation or information on how Flink caches data during SQL queries when RocksDB is used as a StateBackend? After executing a SQL query, I couldn't find any cached data in local files. Additionally, could you please provide an overview of how the caching mechanism works in Flink in general? I appreciate any insights or references you can provide on this matter. Thank you!
