Hello team, quick question I need to be able to st...
# general
m
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.
Copy code
"dateTimeFieldSpecs": [{
    "name": "consensus_timestamp",
    "dataType": "LONG",
    "format" : "1:MILLISECONDS:EPOCH",
    "granularity": "1:NANOSECONDS"
  }]
Is something like this possible?
l
if your input is nanos, you should use
format
also nanos
Copy code
"dateTimeFieldSpecs": [{
    "name": "consensus_timestamp",
    "dataType": "LONG",
    "format" : "1:NANOSECONDS:EPOCH",
    "granularity": "1:NANOSECONDS"
  }]
😃 1
m
got it. But this should work right. As in pinot supports nanoseconds from epoch?
l
yes. it works.