Hash Group Aggregate - Hash Group Aggregate - 2023.1 English

Hash Group Aggregate resides in 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 2 columns named l_orderkey and l_extendedprice.