Decimal division issue

80 views
Skip to first unread message

karthi djax

unread,
Apr 23, 2022, 12:36:51 AM4/23/22
to ClickHouse
Hi,
While processing query getting below exception

<p>Message: HttpCode: 500 ; ;Code: 153. DB: :Exception: Division by zero: while executing 'FUNCTION divide(sum(dj_total_revenue) : 11, sum(impressions) : 6) -> divide(sum(dj_total_revenue), sum(impressions)) Decimal(38,
6) : 15'. (ILLEGAL_DIVISION) (version 21.12.3.32 (official build))

Can anyone please help me on this.

Thanks,
Karthik
Reply all
Reply to author
Forward
0 new messages