# --q0 Q1-1: key_int64; distinct rate: 10M/300M; HashMap
select /*+ mpp_1phase_agg() */ sum(l_quantity) as csum, l_partkey from lineitem group by l_partkey having csum < 200;
# --q1 Q1-2: key_int64; 75M/300M; HashMp
select /*+ mpp_1phase_agg() */ sum(l_quantity) as csum, l_orderkey from lineitem group by  L_orderkey having csum < 1;
# --q2 Q1-3: key_int64; 7/300M; HashMap
select /*+ mpp_1phase_agg() */ sum(l_quantity), l_linenumber from lineitem group by  l_linenumber;

# --q3 Q2-1: one_key_strbinpadding; 2/300M; StringHashMap
select /*+ mpp_1phase_agg() */ sum(l_discount), l_linestatus from lineitem group by l_linestatus;
# --q4 Q2-2: one_key_strbinpadding; 104M/300M; StringHashMap
select /*+ mpp_1phase_agg() */ sum(l_discount) as csum from lineitem group by l_comment having csum > 800;

# --q5 Q3-1: key_serialized as group by method;  33/300M; HashMap with StringRef key
select /*+ mpp_1phase_agg() */ sum(l_discount), l_returnflag from lineitem group by l_returnflag, l_discount;
# --q6 Q3-2: key_serialized as group by method; 77M/300M; HashMap with StringRef key
select /*+ mpp_1phase_agg() */ sum(l_discount) as csum, l_returnflag from lineitem group by l_returnflag, l_discount, l_extendedprice having csum > 100;


# --q7 Q4-1: two_keys_num64_strbinpadding: 21/300M; HashMap with StringRef key
select /*+ mpp_1phase_agg() */ sum(l_discount) from lineitem group by l_returnflag, L_LINENUMBER;
# --q8 Q4-2: two_keys_num64_strbinpadding; 29.9M/300M; HashMap with StringRef key
select /*+ mpp_1phase_agg() */ sum(l_discount) as csum, l_partkey from lineitem group by l_returnflag, l_partkey having csum > 100;

# --q9 Q5-1: keys_128; 77/300M; HashMap with UInt128 key
select /*+ mpp_1phase_agg() */ sum(l_linenumber), l_discount from lineitem group by l_linenumber, l_discount;
# --q10 Q5-2: keys_128; 5M/300M; HashMap with UInt128 key
select /*+ mpp_1phase_agg() */ sum(l_linenumber) as csum, l_discount from lineitem group by l_suppkey, l_discount having csum > 800;

# --q11 Q6-1: key_string; 4/300M; StringHashMap
select /*+ mpp_1phase_agg() */ sum(l_quantity), l_shipinstruct from lineitem group by l_shipinstruct;

# --q12 Q7-1: keys_256; 290M/300M; HashMap;
select /*+ mpp_1phase_agg() */ sum(l_suppkey) as csum from lineitem group by l_suppkey, l_tax, l_discount, l_partkey having csum = 10;

# --q13 clickbench Q4
select count(distinct userid) from clickbench.hits;

None