在物理库上执行sql成功，在mycat2逻辑库执行报错

[peowner]

SELECT
COUNT( 0 ) ct,
any_value ( store_id ) id,
any_value ( store_name ) NAME,
any_value ( rec.store_type ) stype,
any_value (
DATE_FORMAT( rec.create_time, '%Y-%m-%d' )) dt,
any_value ( 0 ) AS type
FROM
op_order_hotel_accommodation_rec rec
INNER JOIN basic_hotel_info hotel ON hotel.id = rec.store_id
WHERE
rec.actual_checkin_time BETWEEN '2023-10-18'
AND '2023-11-24'
AND store_id = '1782421961759117546'
GROUP BY
id,
dt,
name,
stype,
type
UNION
SELECT
COUNT( 0 ) ct,
any_value ( store_id ) id,
any_value ( store_name ) NAME,
any_value ( rec.store_type ) stype,
any_value (
DATE_FORMAT( rec.create_time, '%Y-%m-%d' )) dt,
any_value ( 1 ) AS type
FROM
op_order_hotel_accommodation_abroad rec
INNER JOIN basic_hotel_info hotel ON hotel.id = rec.store_id
WHERE
rec.actual_checkin_time BETWEEN '2023-10-18'
AND '2023-11-24'
AND store_id = '1782421961759117546'
GROUP BY
id,
dt,
name,
stype,
type；

提示错误信息：
Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Aggregate expression is illegal in GROUP BY clause。