Hi All, Any advice/suggestions on how to handle nu...
# general
k
Hi All, Any advice/suggestions on how to handle null values in date column with valid values same as the default
1970-01-01
in Pinot (ex: date of birth)? In my real time table schema I have the date defined as below under dateTimeFieldSpecs:
Copy code
{
  "name": "date_of_birth",
  "dataType": "TIMESTAMP",
  "format": "1:DAYS:TIMESTAMP",
  "granularity": "1:DAYS"
}
m
date_of_birth
is not a time column right, but regular dimension?
k
Right. I have a created_at date which I'm using as the primary time column in the table segment config.
I'm formatting the field to show as date when querying the data.