Apache Pinot

Hi all, I'm new here. I'm using 0.7.1. I have a timestamp field that is formatted as epoch. So I'm trying to query all the records that are older than one day.

Here's the query I wrote for it.

`select * from steps where loggedAt &gt; now() - cast(60*60*24*1000 as long)`

I have records that falls into this bucket. But this query returns nothing.

Where did it go wrong?

Is the query returning empty response or not returning any response (ie spinning wheel)?

Also, do you have access to broker/server logs? If so, can you check what it says?

I will check the broker/server logs as you mentioned. I'm running a single node cluster configured in my laptop.

I didn't see any error in the logs. However, I was able to achieve this with the following query.

`select * from steps where loggedAt &gt; ToEpochSeconds(now()- 86400000)`