[jira] [Created] (HIVE-16605) Enforce NOT NULL constraints

["Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org>]

Jesus Camacho Rodriguez created HIVE-16605:
----------------------------------------------

             Summary: Enforce NOT NULL constraints
                 Key: HIVE-16605
                 URL: https://issues.apache.org/jira/browse/HIVE-16605
             Project: Hive
          Issue Type: New Feature
    Affects Versions: 3.0.0
            Reporter: Carter Shanklin


Since NOT NULL is so common it would be great to have tables start to enforce that.

[~ekoifman] described a possible approach in HIVE-16575:
{quote}
One way to enforce not null constraint is to have the optimizer add enforce_not_null UDF which throws if it sees a NULL, otherwise it's pass through.
So if 'b' has not null constraint,
Insert into T select a,b,c... would become
Insert into T select a, enforce_not_null(b), c.....
This would work for any table type.
{quote}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)