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

Xiang Fu

07/14/2021, 8:19 AM
can you try to cast it to long?
m

Mark Needham

07/14/2021, 8:43 AM
oh nice! I didn't know you could do that, my SQL foo is weak clearly:
Copy code
select count(*)
from pullRequestMergedEvents 
where createdTimeMillis < (now() - cast(1000*120 as long))
limit 10
that works 🙂
thanks!
actually the cast works if I do it before or after the calculation:
Copy code
select count(*)
from pullRequestMergedEvents 
where createdTimeMillis < cast((now() - 1000*60*60) as long)
limit 10