AnalysisException: [ROW_LEVEL_SECURITY_FEATURE_NOT_SUPPORTED.CHECK_CONSTRAINT]
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-12-2024 07:07 AM
I just tried to setup a row filter via the following two sql snippets:
create function if not exists foo.my_test.row_filter (batch_id bigint) return TRUE;
alter table foo.my_test.some_table set row filter foo.my_test.row_filter on (batch_id);
This resulted in ROW_LEVEL_SECURITY_FEATURE_NOT_SUPPORTED.CHECK_CONSTRAINT. I assume this is because the table has some constraints (e.g. delta.constraints.valid_year=year > 2020).
I checked the documentation of row filters here - especially the limitations. It doesn't mention anything about check constraints.
Is this not supported, or am I doing something wrong here?
If this is not supported, then the limitations section should be updated...
If this is not supported, then the limitations section should be updated...
BTW: This seems to be a recurring issue I have with databricks (and azure tbf), you start using a feature A just to find out a couple of weeks later, that using feature A prevents you from using feature B.... Not a very nice user experience 😞
Labels:
- Labels:
-
Delta Lake
-
Spark
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-12-2024 07:19 AM - edited 03-12-2024 07:25 AM
To be fair, row filters and the check constraints feature are in Public Preview, so I apologize for the slightly harsh words above!