- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-09-2023 09:28 AM
In Data Science & Engineering -> Data -> Data Explorer, if I expand the hive_metastore, then expand a schema and choose a table, and then view the "Sample Data", I receive this error:
[DEFAULT_FILE_NOT_FOUND] It is possible the underlying files have been updated. You can explicitly invalidate the cache in Spark by running 'REFRESH TABLE tableName' command in SQL or by recreating the Dataset/DataFrame involved.
In the old UI, I would click the "Refresh" button to clear the error. That button does not seem to exist anymore. Is there a new method to REFRESH a table within the Data Explorer?
- Labels:
-
Data Explorer
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-10-2023 06:34 AM
Thanks....I have tried that many times, and it does not help. It's like the Sample Data view in Databricks is cached in some way, and there is no longer a mechanism refresh it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-10-2023 05:27 AM
Try refreshing all cached entries that are associated with the table that might help
REFRESH TABLE [db_name.]table_name
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-10-2023 06:34 AM
Thanks....I have tried that many times, and it does not help. It's like the Sample Data view in Databricks is cached in some way, and there is no longer a mechanism refresh it.

