Anyone know the pinot SQL to do something like this find rec Apache Pinot #random

Anyone know the pinot SQL to do something like thi...

Harish Bohara

03/14/2023, 7:14 AM

Anyone know the pinot SQL to do something like this? “find records in last 1 day”

Copy code

"select * from table_1 where time > now() - 1 day" OR select * from table_1 where time > now() - 86400

Jayesh Asrani

03/14/2023, 7:24 AM

Copy code

SELECT * 
FROM tableName
WHERE tsInMillis > now() - 86400000

Jayesh Asrani

03/14/2023, 7:25 AM

Something like above should work.