为了更快的定位您的问题，请提供以下信息，谢谢
【详述】存算分离3.1.3版本，查询数据错误。
-
建表语句，并导入一些数据：
CREATE TABLE rx_bd_test.dwd_fact_event_0preset_login_19(
#user_idvarchar(65533) NULL,
#timedatetime NULL
) ENGINE=OLAP
DUPLICATE KEY(#user_id)
COMMENT “OLAP”
PARTITION BY RANGE(#time)
(PARTITION p20230710 VALUES [(“2023-07-10 00:00:00”), (“2023-07-11 00:00:00”)))
DISTRIBUTED BY HASH(#user_id,#time) BUCKETS 3
PROPERTIES (
“replication_num” = “3”,
“dynamic_partition.enable” = “true”,
“dynamic_partition.time_unit” = “DAY”,
“dynamic_partition.time_zone” = “Asia/Shanghai”,
“dynamic_partition.start” = “-360”,
“dynamic_partition.end” = “360”,
“dynamic_partition.prefix” = “p”,
“dynamic_partition.buckets” = “10”,
“dynamic_partition.history_partition_num” = “0”,
“datacache.partition_duration” = “60 days”,
“datacache.enable” = “true”,
“enable_async_write_back” = “false”,
“enable_persistent_index” = “false”,
“compression” = “ZSTD”
); -
查询sql如下：
SELECT
date_add( a.#time, INTERVAL 0 HOUR ) AS#time
, a.#user_id
, DATE_FORMAT(date_add(#time, interval 0 hour), ‘%Y-%m’)
, DATE_FORMAT(add_months(date_add(now(), interval 0 hour), 0), ‘%Y-%m’)
from
dwd_fact_event_0preset_login_19 a
where
1 = 1
AND DATE_FORMAT(date_add(#time, interval 0 hour), ‘%Y-%m’) = DATE_FORMAT(add_months(date_add(now(), interval 0 hour), 0), ‘%Y-%m’)
; -
表里的数据
-
错误结果：
【业务影响】
【StarRocks版本】存算分离 3.1.3-384ba23
【集群规模】3fe + 10be
