Date Time functions not working in 1.4 version
Acc...
# troubleshootingm
Monika reddy
03/03/2026, 9:54 PMDate Time functions not working in 1.4 version
According to https://docs.pinot.apache.org/functions/datetime-functions
dateDiff and timestampDiff --> getting exception 'hours' or 'seconds' not a valid Timestamp field
I did read one of Mayank's post suggesting for dateDiff had to pass in quotes but same exception for both the functions.
Query failed with exceptions. Stats may be partial
(SQLParsingError)
ror: Caught exception while invoking method: timestampDiff with arguments: [' hours, 1700000000000, 1700010800000]: "hours" is not a valid Timestamp field
Please refer the screenshot in the reply, if you notice I am not passing quotes to timestampDiff but in the error message I can still see
@Xiang Fu @Mayank
Monika reddy
03/03/2026, 10:13 PMThis actually worked on 1.1 production but we have upgraded UAT to 1.4 and the overall huge query is failing. The example is short version of what we want to achieve.
Is this the correct way of using these functions?
m
Mayank
03/03/2026, 10:35 PM
@Yash Mayya ^^
y
Yash Mayya
03/03/2026, 10:44 PMShouldn't it be
hourhoursx
Xiang Fu
03/03/2026, 11:38 PM
it should be single quoted
'hours'm
Monika reddy
03/04/2026, 4:01 AMI tried both with and without single quotes. Note timestampAdd and timestamp_ADD works both correctly but not diff
Monika reddy
03/04/2026, 4:02 AM@Yash Mayya Not only hours, but Day, Days none of them work for datediff, timestampDiff, timestamp_DIFf
2 Views