【详述】问题详细描述
【背景】做过哪些操作？
【业务影响】
【StarRocks版本】例如：2.51.
【集群规模】例如：2fe（1 follower+1leader）+2be（fe与be混部）
【机器信息】CPU虚拟核/内存/网卡，例如：48C/64G/万兆
【联系方式】为了在解决问题过程中能及时联系到您获取一些日志信息，
【附件】
select
sum(sales_volume) as sales_volume,
group_subsidiaries_2020, brand_2020,
brand_attribute_2020,
manufacturing_enterprise_2020,
luxury,
catarc_enterprise_name,
catarc_brand,
model_2020,
model_all_power,
level_2020,
department_2020,
subdivision_2020,
category_2020,
model_category,
special_classification_2020,
catarc_model, model_attr,
catarc_model_category,
catarc_model_level,
catarc_model_category_serice,
fuel_2020, fuel_new,
fuel_type_new,
catarc_fuel_type,
ownership,
ownership_class,
nature_of_use,
nature_of_use_ori,
operation_class,
price_trans,
region,
use_province,
city,
use_district,
division,
dual_net_district, corporate_district, denza_district,
double_limit_city, city_class, red_black_city,
red_black_city_level, city_level, price_segment_2020,
rated_passenger_capacity, tire_specification, outline_height,
outline_width, outline_length, wheelbase, number_of_cars,
body_form_2020, price_segment, displacement, transmission,
power, engine_torque, engine_enterprise, engine_model, emission_level,
driving_form, consumption_level_2020, model_color, byd_city_level, search_time
from ic_cyb_cdm.cyb_cdm_catarc_sales_mon_wide_ds_h where search_time >= '2023-03' and search_time <= '2023-03'
group by group_subsidiaries_2020,
brand_2020, brand_attribute_2020, manufacturing_enterprise_2020, luxury,
catarc_enterprise_name, catarc_brand, model_2020, model_all_power,
level_2020, department_2020, subdivision_2020, category_2020,
model_category, special_classification_2020, catarc_model,
model_attr, catarc_model_category, catarc_model_level,
catarc_model_category_serice, fuel_2020, fuel_new, fuel_type_new,
catarc_fuel_type, ownership, ownership_class, nature_of_use, nature_of_use_ori,
operation_class, price_trans, region, use_province, city, use_district, division,
dual_net_district, corporate_district, denza_district, double_limit_city, city_class,
red_black_city, red_black_city_level, city_level, price_segment_2020, rated_passenger_capacity,
tire_specification, outline_height, outline_width, outline_length, wheelbase, number_of_cars,
body_form_2020, price_segment, displacement, transmission, power, engine_torque,
engine_enterprise, engine_model, emission_level, driving_form, consumption_level_2020, model_color, byd_city_level, search_time
order by group_subsidiaries_2020, brand_2020, brand_attribute_2020, manufacturing_enterprise_2020, luxury, catarc_enterprise_name,
catarc_brand, model_2020, model_all_power, level_2020, department_2020, subdivision_2020, category_2020, model_category, special_classification_2020, catarc_model,
model_attr, catarc_model_category, catarc_model_level, catarc_model_category_serice, fuel_2020, fuel_new, fuel_type_new, catarc_fuel_type, ownership,
ownership_class, nature_of_use, nature_of_use_ori, operation_class, price_trans, region, use_province, city, use_district, division, dual_net_district,
corporate_district, denza_district, double_limit_city, city_class, red_black_city, red_black_city_level, city_level, price_segment_2020, rated_passenger_capacity,
tire_specification, outline_height, outline_width, outline_length, wheelbase, number_of_cars, body_form_2020, price_segment, displacement, transmission, power,
engine_torque, engine_enterprise, engine_model, emission_level, driving_form, consumption_level_2020, model_color, byd_city_level, search_time,sales_volume
limit 390650,50
表中聚合后共 390667 条数据，分页查询查询结果都不一样，换成 limit 50 offset 390650 也是一样的效果，是什么原因导致的，查询表是一张明细模型
