[GitHub] [iceberg] zhangdove commented on issue #2289: data is not updated in spark-shell

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

zhangdove commented on issue #2289:
URL: https://github.com/apache/iceberg/issues/2289#issuecomment-789408931


   1.The `CachingCatalog` cache is used by default for SQL queries, which can be turned off by adding the following parameter when launching Spark-shell
   ```
   --conf "spark.sql.catalog.hadoop_prod.cache-enabled=false"
   ```
   
   2.The other way is to refresh the current table before querying the Iceberg table:
   ```
   spark.sql("refresh table prod.db.tb")
   spark.sql("select * from prod.db.tb")
   ```


----------------------------------------------------------------
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: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org