Vertica Access Policy Limitations with Merge Query
I'm trying to run a merge Query on Table with access Policy on Certain columns.
ALTER ACCESS POLICY ON T1 FOR column SSN
CASE WHEN ENABLED_ROLE('dbadmin') then SSN
WHEN ENABLED_ROLE('ADMIN') then SSN
WHEN ENABLED_ROLE('ADMIN2') then SSN
WHEN ENABLED_ROLE('ADMIN3') then SSN
ELSE NULL END ENABLE;
If I run a update statement- It runs successfully .
Merge Operations on this table Fails with Error -
ERROR 6538: Unable to MERGE: "Access denied due to active access policy on table "T1" for column "SSN""
has very vague statement -
-If the query cannot be folded (or compressed) by the Vertica optimizer, all functions other than SELECT are blocked. The following error message appears:
=> ERROR 0: Unable to INSERT: "Access denied due to active access policy on table <tablename> for column (columnname>
Is there any fix for it ????
I saw an old ticket for same issue -https://community.dev.hpe.com/t5/Vertica-Forum/ACCESS-POLICY-Load-Issue/td-p/232372
Is it a known Bug??