Hi, we are ingesting a timestamp data into a offline Pinot offline table as a long data type and 1millisecondsepoch date time specs. But for all null records Pinot ingested as min long value. How should we define the schema so that null timestamp can be also ingested as a null value in Pinot?

Pinot does not support storing null natively currently. Instead what it provides you is a way to replace nulls with a default value of your choice (can be set in schema). You can then filter those out when querying

This is not the one we use for timecolumnname, it’s one of field happens to be null in certain situation. So could we add e.g. “defaultNullValue” :”null” for this dateTimeFieldSpecs field so it can be filtered out too?

yes

Should the nullHandlingEnabled flag be set to true in the tableIndexConfig for this to work?

Yeah, you need to provide a value of your choice (must match the data type) and add filter in the query. The

nullHandlingEnabled

flag is not for this.