Hash Group Aggregate - 2024.2 English

Hash Group Aggregate resides in the L1/benchmarks/hash_group_aggregate directory.

SELECT
        max(l_extendedprice), min(l_extendedprice), count_non_zero(l_extendedprice) as revenue
FROM
        Lineitem
GROUP BY
        l_orderkey
;

Here, Lineitem is a table filled with random data, which contains two columns named l_orderkey and l_extendedprice.