Andres de la Peña created CASSANDRA-18068:
---------------------------------------------
Summary: Allow to attach native masking functions to table columns
Key: CASSANDRA-18068
URL: https://issues.apache.org/jira/browse/CASSANDRA-18068
Project: Cassandra
Issue Type: New Feature
Components: Feature/Dynamic Data Masking
Reporter: Andres de la Peña
Assignee: Andres de la Peña
Allow to attach the native masking functions added by CASSANDRA-17941 to table
columns, as defined by
[CEP-20|https://cwiki.apache.org/confluence/display/CASSANDRA/CEP-20%3A+Dynamic+Data+Masking].
{{CREATE TABLE}} statements would look like:
{code}
> CREATE TABLE patients (
id timeuuid PRIMARY KEY,
name text MASKED WITH partial(2, 1),
birth date MASKED WITH default()
);
> INSERT INTO patients(id, name, birth) VALUES (now(), 'alice', '1982-12-21);
> SELECT name, birth FROM patients;
name | birth
---------+------------
alXXXXe | 1900-01-01
{code}
{{ALTER TABLE}} statements would look like:
{code}
> ALTER TABLE patients ALTER name MASKED WITH partial(2, 1);
> ALTER TABLE patients ALTER name WITHOUT MASK;
{code}
It won't be possible to use masked columns in the WHERE and IF clauses of
SELECT and UPDATE statements.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
