Hi All, I am using Pinot 1.1 and I want to store null for my DOUBLE column.. For that I have used below confs:

nullHandlingEnabled=true at table config level

enableColumnBasedNullHandling": true at schema level

{
      "name": "notNullColumn",
      "dataType": "DOUBLE",
      "notNull": False
 }

Still when I am querying, I am getting "0" instead of null. How can I fix this issue where I want to see null (original value) instead of 0 in query response without adding "SET enableNullHandling=true" in my query

this

notNull": False

should be

true

?

I want to store null values, so notNull should be false right ?

ah, yes then

This is my doubt, Even when I am querying with condition : select column1,* from abc where column1 is null. This returns null values are 0 for column1.

so by adding

SET enableNullHandling=true

you will be able to see the correct results？

I see... So on adding SET enableNullHandling=true, I am able to see column1 nul data as -- instead of 0

correct

Thanks @Xiang Fu, i ll go through it.