Hi everyone does anyone know why this query fails: select * from mydata where epoc_time_stamp > now() - 86400000 if I just use now() it works fine. but when i deduct 1 day from now() I get the following error: "message": "QueryExecutionError\norg.apache.pinot.spi.exception.BadQueryRequestException java.lang.IllegalArgumentException: Cannot convert value: '1.64264431985E12' to type: LONG\n\tat interestingly this query works: select epoc_time_stamp, now() as mynow from mydata where epoc_time_stamp > mynow - 86400000

You might have to cast it as follows:

select * from mydata where epoc_time_stamp > now() - cast(86400000 as long)

thanks worked perfect