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
.