Hi folks for a Partial Upsert table with a boolean field is Apache Pinot #general

Hi folks, for a Partial Upsert table with a boolea...

a

Ankit Sultana

07/11/2023, 12:56 AM

Hi folks, for a Partial Upsert table with a boolean field, is it possible to set a non-null boolean column back to null for a given primary key?

m

Mark Needham

07/13/2023, 11:08 AM

you want to set the primary key to null? I haven’t tried it, but I’d be surprised if that’d work

a

Ankit Sultana

07/13/2023, 4:16 PM

Not the primary key.. any column other than the primary key

Ankit Sultana

07/13/2023, 4:17 PM

Say we have this data before:

Copy code

pkey|is_online|user_uuid
1234|false|user-1

We'd want this, so that a query that does

is_online IS NULL

works correctly:

Copy code

pkey|is_online|user_uuid
1234|null|user-1

My understanding is that this feature is not there because we ignore null events in Partial Upserts, but I wanted to check if any one else is also thinking about it