Channels
#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 10that 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 10I wrote it up here in case anyone else comes across it - https://www.markhneedham.com/blog/2021/07/16/pinot-bad-query-request-exception-cannot-convert-value-long/