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)
