I am trying to do a count on the volumes in teredata on a table for a certain period but I keep on getting an error saying overflow occurred computing an expression.
SELECT CAST(timestamp_timestamp as Date) as DATEY, COUNT(transactionType)
FROM PRD_ACC_DIGIS_APP_PUB.SECURITY_CHECKS_RESULTS
WHERE timestamp_timestamp BETWEEN '1700431200000' and 1700776800000
GROUP BY DATEY;
I am expecting to get the volumes.