v.18.12New Feature
Decimal Type Enhancements: Support for var* and stddev* Aggregate Functions
TheDecimaltype now supportsvar*andstddev*aggregate functions. #3129
Why it matters
This feature enables users to perform variance and standard deviation calculations onDecimal columns, which was previously unsupported. It allows for more accurate and precise statistical analysis on decimal numeric data types.How to use it
Users can directly apply thevarPop, varSamp, stddevPop, and stddevSamp aggregate functions on columns with the Decimal type in their SQL queries as usual. For example:SELECT varPop(decimal_column), stddevSamp(decimal_column) FROM table_name