Clikchouse 不同配置下的查询结果一致性验证

SELECT toDateTime(date_trunc('day', `vpc@timezone_#time`)) AS date_time, 'event_0' AS event_index, 'compare_0' AS compare_index, coalesce(formatDateTimeInJodaSyntax(toDateTime(date_trunc('day', `vpc@timezone_#time`)), 'yyyy-MM-dd'), 'null') AS group_0, round(toFloat64(coalesce(COUNT(1), 0)), 2) AS `$amount` FROM (SELECT * FROM (SELECT `#data_lifecycle`, `#dt`, `#event`, `#time`, `vpc@timezone_#time`, `#zone_offset` FROM (SELECT `#data_lifecycle`, `#dt`, `#event`, `#time`, timestamp_add(fromUnixTimestamp64Milli(`#time`), interval 8 * 60 minute) AS `vpc@timezone_#time`, `#zone_offset` FROM events WHERE (`#event` IN ('#user_login')) AND ((`#dt` BETWEEN '2026-03-18' AND '2026-03-20'))) AS event) WHERE (`#data_lifecycle` = '0') AND (`#dt` BETWEEN '2026-03-18' AND '2026-03-20' AND `vpc@timezone_#time` BETWEEN '2026-03-19 00:00:00.000' AND '2026-03-19 23:59:59.999' ) AND (`#event` IN ('#user_login'))) GROUP BY GROUPING SETS((date_time, group_0),(group_0));

SELECT hex(groupBitXor(cityHash64(tuple(*)))) AS cksum FROM (
  SELECT * FROM (
    SELECT *, row_number() over(partition by compare_index,event_index order by total_amount desc) as row_number FROM (
      SELECT compare_index,event_index, total_amount, COUNT(1) over(partition by compare_index,event_index) as group_num,cast((groupArray(date_time), groupArray(`$amount`)) AS Map(Datetime, Float64)) AS data_map, toJSONString(data_map) AS data_map_str FROM (
        SELECT date_time, compare_index,event_index, multiIf(`$amount` = inf, 0, `$amount` = -inf, 0, `$amount`) as `$amount`, SUM(`$amount`) over(partition by 1) as total_amount FROM (

              SELECT toDateTime(date_trunc('day', `vpc@timezone_#time`)) AS date_time, 'event_0' AS event_index, 'compare_0' AS compare_index, round(toFloat64(coalesce(COUNT(1), 0)), 2) AS `$amount` FROM (SELECT * FROM (SELECT `#data_lifecycle`, `#dt`, `#event`, `#time`, `vpc@timezone_#time`, `#zone_offset` FROM (SELECT `#data_lifecycle`, `#dt`, `#event`, `#time`, timestamp_add(fromUnixTimestamp64Milli(`#time`), interval 8 * 60 minute) AS `vpc@timezone_#time`, `#zone_offset` FROM events WHERE (`#event` IN ('#user_login')) AND ((`#dt` BETWEEN '2026-02-23' AND '2026-03-26'))) AS event) WHERE (`#data_lifecycle` = '0') AND (`#dt` BETWEEN '2026-02-23' AND '2026-03-27' AND `vpc@timezone_#time` BETWEEN '2026-02-24 00:00:00.000' AND '2026-03-26 23:59:59.999' ) AND (`#event` IN ('#user_login'))) GROUP BY GROUPING SETS((date_time),())

        ) GROUP BY date_time, compare_index,event_index, `$amount`
      ) GROUP BY compare_index,event_index, total_amount
    )
  ) WHERE row_number <= 1000 ORDER BY compare_index,event_index, row_number LIMIT 100000
)