framework/resources/Functional/s3minio/fragments/data/having_count.sql

SET planner.width.max_per_node=100;
SET planner.slice_target=1;
SET planner.enable_multiphase_agg=false;
SELECT
  count(decimal_big.DECIMAL_15_5)
FROM
  s3minio.tmp.`big_files/T_DECIMAL_BIG` decimal_big
GROUP BY decimal_big.DECIMAL_15_5
HAVING count(decimal_big.DECIMAL_15_5) > 200277;
RESET planner.width.max_per_node;
RESET planner.slice_target;
RESET planner.enable_multiphase_agg;