https://pinot.apache.org/ logo
#general
Title
# general
j

Josh Highley

04/22/2021, 5:25 PM
When doing upsert, can the table's time column be a string or does it have to be a long?
y

Yupeng Fu

04/22/2021, 5:29 PM
it has to be the time column of the table for now
so needs to be long
j

Josh Highley

04/22/2021, 5:31 PM
ah, so time column can't be a string? "format":"1MILLISECONDSSIMPLE_DATE_FORMAT:EE,dd MMM yyyy HHmmss.SSS"
y

Yupeng Fu

04/22/2021, 5:33 PM
yeah, it can be converted during ingestion
j

Josh Highley

04/22/2021, 5:35 PM
I can't use simple_data_format with LONG, though, correct? I believe I tried that and it wouldn't convert
I'd have to use a transformFunction, correct?
j

Jackie

04/22/2021, 5:52 PM
Currently we don't support SDF string as the upsert time values, but that is doable. Can you please submit a github issue for this?
For now, you have to use transform to convert the values to long