Support NOT NULL constraint of Hive 3 tables

trinodb / trino

Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)

https://trino.io

Apache License 2.0

10.21k stars 2.94k forks source link

Support NOT NULL constraint of Hive 3 tables #2923

Open findepi opened 4 years ago

findepi commented 4 years ago

enforce data is not NULL when inserting into a NOT NULL column
show this annotation in SHOW CREATE TABLE
allow declaring columns as NOT NULL in Hive connector

Relates to: https://github.com/prestosql/presto/issues/4070

findepi commented 4 years ago

Now that we have https://github.com/prestosql/presto/issues/4070, it should be enough to expose nullity in ColumnMetadata, at least for the enforcement part.

cc @djsstarburst

electrum commented 4 years ago

We need to decide what this constraint means. If this is a guarantee the connector will not return null (meaning the engine can elide null checks) then we’ll also need to add enforcement on read for Hive, since we have can’t trust data files to be correct.

humpfhumpf commented 1 month ago

Hi @electrum, is this decided yet or abandoned?