Delete "Dangling" Materializations

#1

Guys,

I’m using those sys tables to track my reflections update via API, but some of the materializations records are without no connections between reflections or refreshes. There is some way to delete these materializations?

0 Likes

#2

Hey @allan.sene, those “dangling” materializations are unexpected. A few questions:

  1. What version of Dremio is this?
  2. Did you upgrade recently and thus run the upgrade script on your Dremio db dir?
  3. If you go to your acceleration store (on whatever distributed filesystem you’re using with Dremio) do you find directories or files with those materialization ids?
0 Likes

#3

Actually, I’ve noticed something: the reflection_id exists, but only on the sys.materializations table, look:

  1. Version 3.1.6
  2. I didn’t upgrade, but I’d migrated my single node to a cluster deployment (performing the backup/restore operation)
  3. Yes, they are there.
0 Likes