执行一个统计计算,sql如下:
select sum(discharge_power) from ads_energy_storage_system_param
where date_day='2025-06-27';
每次执行得到的结果都不一致,总是在7.64和7.72之间切换
想知道原因是啥?
背景:该表的数据没有更新
DDL如下:
CREATE TABLE ads_energy_storage_system_param
(
date_day
date NULL COMMENT '统计日期',
time_period
varchar(4000) NULL COMMENT '时段类型:峰/谷/平',
operator_id
varchar(3200) NULL COMMENT '运营商编码',
station_id
varchar(3200) NULL COMMENT '充电站编码',
device_id
varchar(320) NULL COMMENT '设备编码',
charge_power
decimal(10,2) REPLACE NULL COMMENT '充电量 日增量',
discharge_power
decimal(10,2) REPLACE NULL COMMENT '放电量 日增量',
soc
decimal(10,2) REPLACE NULL COMMENT '电池SOC',
soh
decimal(10,2) REPLACE NULL COMMENT '电池SOH',
record_time
datetime REPLACE NULL COMMENT '创建时间'
) ENGINE=OLAP
AGGREGATE KEY(date_day
, time_period
, operator_id
, station_id
, device_id
)
PARTITION BY RANGE(date_day
)
(PARTITION p20241231 VALUES [('0000-01-01'), ('2025-01-01')),
PARTITION p20250101 VALUES [('2025-01-01'), ('2025-01-16')),
PARTITION p20250116 VALUES [('2025-01-16'), ('2025-02-01')),
PARTITION p20250201 VALUES [('2025-02-01'), ('2025-02-15')),
PARTITION p20250215 VALUES [('2025-02-15'), ('2025-03-01')),
PARTITION p20250301 VALUES [('2025-03-01'), ('2025-03-15')),
PARTITION p20250315 VALUES [('2025-03-15'), ('2025-04-01')),
PARTITION p20250401 VALUES [('2025-04-01'), ('2025-04-15')),
PARTITION p20250415 VALUES [('2025-04-15'), ('2025-05-01')),
PARTITION p20250501 VALUES [('2025-05-01'), ('2025-05-15')),
PARTITION p20250515 VALUES [('2025-05-15'), ('2025-05-16')),
PARTITION p20250516 VALUES [('2025-05-16'), ('2025-05-17')),
PARTITION p20250517 VALUES [('2025-05-17'), ('2025-05-18')),
PARTITION p20250518 VALUES [('2025-05-18'), ('2025-05-19')),
PARTITION p20250519 VALUES [('2025-05-19'), ('2025-05-20')),
PARTITION p20250520 VALUES [('2025-05-20'), ('2025-05-21')),
PARTITION p20250521 VALUES [('2025-05-21'), ('2025-05-22')),
PARTITION p20250522 VALUES [('2025-05-22'), ('2025-05-23')),
PARTITION p20250523 VALUES [('2025-05-23'), ('2025-05-24')),
PARTITION p20250524 VALUES [('2025-05-24'), ('2025-05-25')),
PARTITION p20250525 VALUES [('2025-05-25'), ('2025-05-26')),
PARTITION p20250526 VALUES [('2025-05-26'), ('2025-05-27')),
PARTITION p20250527 VALUES [('2025-05-27'), ('2025-05-28')),
PARTITION p20250528 VALUES [('2025-05-28'), ('2025-05-29')),
PARTITION p20250529 VALUES [('2025-05-29'), ('2025-05-30')),
PARTITION p20250530 VALUES [('2025-05-30'), ('2025-05-31')),
PARTITION p20250531 VALUES [('2025-05-31'), ('2025-06-01')),
PARTITION p20250601 VALUES [('2025-06-01'), ('2025-06-02')),
PARTITION p20250602 VALUES [('2025-06-02'), ('2025-06-03')),
PARTITION p20250603 VALUES [('2025-06-03'), ('2025-06-04')),
PARTITION p20250604 VALUES [('2025-06-04'), ('2025-06-05')),
PARTITION p20250605 VALUES [('2025-06-05'), ('2025-06-06')),
PARTITION p20250606 VALUES [('2025-06-06'), ('2025-06-07')),
PARTITION p20250607 VALUES [('2025-06-07'), ('2025-06-08')),
PARTITION p20250608 VALUES [('2025-06-08'), ('2025-06-09')),
PARTITION p20250609 VALUES [('2025-06-09'), ('2025-06-10')),
PARTITION p20250610 VALUES [('2025-06-10'), ('2025-06-11')),
PARTITION p20250611 VALUES [('2025-06-11'), ('2025-06-12')),
PARTITION p20250612 VALUES [('2025-06-12'), ('2025-06-13')),
PARTITION p20250613 VALUES [('2025-06-13'), ('2025-06-14')),
PARTITION p20250614 VALUES [('2025-06-14'), ('2025-06-15')),
PARTITION p20250615 VALUES [('2025-06-15'), ('2025-06-16')),
PARTITION p20250616 VALUES [('2025-06-16'), ('2025-06-17')),
PARTITION p20250617 VALUES [('2025-06-17'), ('2025-06-18')),
PARTITION p20250618 VALUES [('2025-06-18'), ('2025-06-19')),
PARTITION p20250619 VALUES [('2025-06-19'), ('2025-06-20')),
PARTITION p20250620 VALUES [('2025-06-20'), ('2025-06-21')),
PARTITION p20250621 VALUES [('2025-06-21'), ('2025-06-22')),
PARTITION p20250622 VALUES [('2025-06-22'), ('2025-06-23')),
PARTITION p20250623 VALUES [('2025-06-23'), ('2025-06-24')),
PARTITION p20250624 VALUES [('2025-06-24'), ('2025-06-25')),
PARTITION p20250625 VALUES [('2025-06-25'), ('2025-06-26')),
PARTITION p20250626 VALUES [('2025-06-26'), ('2025-06-27')),
PARTITION p20250627 VALUES [('2025-06-27'), ('2025-06-28')),
PARTITION p20250628 VALUES [('2025-06-28'), ('2025-06-29')),
PARTITION p20250629 VALUES [('2025-06-29'), ('2025-06-30')),
PARTITION p20250630 VALUES [('2025-06-30'), ('2025-07-01')))
DISTRIBUTED BY HASH(date_day
) BUCKETS 10
PROPERTIES (
"replication_allocation" = "tag.location.default: 3",
"is_being_synced" = "false",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-2147483648",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.replication_allocation" = "tag.location.default: 3",
"dynamic_partition.buckets" = "10",
"dynamic_partition.create_history_partition" = "false",
"dynamic_partition.history_partition_num" = "-1",
"dynamic_partition.hot_partition_num" = "0",
"dynamic_partition.reserved_history_periods" = "NULL",
"dynamic_partition.storage_policy" = "",
"storage_medium" = "hdd",
"storage_format" = "V2",
"light_schema_change" = "true",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false",
"enable_mow_light_delete" = "false"
);