NOT NULL constraint violated for column during OPTIMIZE
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 hours ago - last edited 4 hours ago
We're running an optimize on a delta table with a VARIANT column that has a NOT NULL constraint.
Now, there are no NULL entries in this column. And yet, OPTIMIZE gives this error:
[DELTA_NOT_NULL_CONSTRAINT_VIOLATED] NOT NULL constraint violated for column: body.
What gives? There is in fact also no is_variant_null matches either. Could it be that the NOT NULL constraint is violated in some earlier transaction?
I am not able to drop the constraint because this is a streaming table.
Labels:
- Labels:
-
Delta Lake