为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8
建表语句:CREATE TABLE "test"."MMT"
(
"ID" BIGINT IDENTITY(163, 1) NOT NULL,
"CITY_CODE" INT,
"ORG_ID" BIGINT,
"ORG_NAME" VARCHAR(120),
"ORG_SHOW_NAME" VARCHAR(64),
"GZ_STU_SUM" VARCHAR(50) DEFAULT '0',
"OFFLINE_STU_SUM" VARCHAR(50) DEFAULT '0',
"ONLINE_STU_SUM" VARCHAR(50) DEFAULT '0',
"DAY_AMOUNT_SUM" VARCHAR(100),
"DAY_HBAMOUNT_SUM" VARCHAR(100),
"DAY" INT,
"MONTH" INT,
"YEAR" INT,
"DATE_COLUMN" VARCHAR(8188),
"CREATOR" VARCHAR(64) DEFAULT '1' NOT NULL,
"CREATE_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP() NOT NULL,
"UPDATER" VARCHAR(64) DEFAULT '',
"UPDATE_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP() NOT NULL,
"DELETED" TINYINT DEFAULT 0 NOT NULL,
"DROP_OUT_SUM" VARCHAR(50),
"TRANSFERS_SUM" VARCHAR(50),
"GRADUATE_SUM" VARCHAR(50),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "test", CLUSTERBTR);
查询SQL:
SELECT year,
month,
SUM(offline_stu_sum) AS offline_stu_sum,
SUM(online_stu_sum) AS online_stu_sum,
SUM(day_amount_sum) AS day_amount_sum,
SUM(day_hbamount_sum) AS day_hbamount_sum
FROM mmt
WHERE deleted = 0
AND org_id IN (?)
AND date_format(date_column, '%Y') = date_format('2023-12-04 14:09:39', '%Y')
GROUP BY month,
year
ORDER BY month DESC
有没有大佬看看
在我本地测试的时候,因为里面没有数据所有没有截断。
按字段类型来控制传参值的类型,应该是传参的数据类型不同引起的