SELECT COUNT(vin),COUNT(distinct(vin)) from ods.info;
后面COUNT(distinct(vin)) 统计数据不正确,本应221这个结果,实际结果10
处理方式:下面三行直接一起执行
set streaming_preaggregation_mode = force_preaggregation;
set new_planner_agg_stage = 1;
SELECT COUNT(vin),COUNT(distinct(vin)) from ods.info;