confluentinc / ksql

The database purpose-built for stream processing applications.
https://ksqldb.io
Other
93 stars 1.04k forks source link

Support for `NON NULL` columns #4436

Open big-andy-coates opened 4 years ago

big-andy-coates commented 4 years ago

At the moment, all columns in KSQL are implicitly NULLable. The SQL standard allows a column to be defined as NON NULL and this is a useful feature to ensure data integrity.

KSQL should support NON NULL columns.

It should also allow components of complex types to be non-null too, e.g. a MAP with non-null key or value parts, or a STRUCT with a mixture of nullable and non-null fields.

big-andy-coates commented 4 years ago

If we were to make MAP have non-null keys by default, then maps could be serialized as Avro maps, rather than arrays of key-value pairs, (which confuses a lot of people!)

eshepelyuk commented 4 years ago

Voting for the issue and interested which milestone it's gonna be targeted for ?

neoliant commented 2 years ago

+1

tfindlay-au commented 1 year ago

+1