Hello team, quick question I need to be able to store in my dateTimeFieldSpecs , my timestamp column upto nanoseconds from epoch. Is that possible in Pinot? I am looking at the docs and I see only milliseconds. I could be missing the doc for this, but just wanted to check with the team.

"dateTimeFieldSpecs": [{
    "name": "consensus_timestamp",
    "dataType": "LONG",
    "format" : "1:MILLISECONDS:EPOCH",
    "granularity": "1:NANOSECONDS"
  }]

Is something like this possible?

if your input is nanos, you should use

format

also nanos

"dateTimeFieldSpecs": [{
    "name": "consensus_timestamp",
    "dataType": "LONG",
    "format" : "1:NANOSECONDS:EPOCH",
    "granularity": "1:NANOSECONDS"
  }]

got it. But this should work right. As in pinot supports nanoseconds from epoch?

yes. it works.