When generating a pivot table with more than 20 columns using the SUM() aggregation, DuckDB forces the result into a HUGEINT (INT128), even when the values are explicitly cast to a smaller numeric ...
Data wonks, rejoice! Pivot tables now automatically refresh themselves in a new beta version of Microsoft Excel. You might expect that pivot tables—which can be used to summarize rows and columns of ...