can you try to cast it to long?
# generalx
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 10Mark Needham
07/14/2021, 8:43 AM
that works 🙂
Mark Needham
07/14/2021, 8:43 AM
thanks!
Mark Needham
07/14/2021, 8:45 AM
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 10Mark Needham
07/16/2021, 7:44 AM
I 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/