Soon
03/13/2025, 2:54 PM-Infinity when taking avg on an empty column and return 0 instead.Mayank
Soon
03/14/2025, 1:07 PMSoon
03/14/2025, 1:29 PM-Infinity as it is trying to take an avg on empty rows.
For example,
select avg(json_extract_scalar(column1, '$.my_awesome_json_column', 'Double', 0)) from my_cool_table
When there is no data in my_cool_table it is returning -Infinitiy