CREATE TABLE "ind_device_hour_0919_2025-10-01"
    (
    `id` bigint NOT NULL IDENTITY(1, 1) COMMENT '自增主键id',
    `device_id` varchar(30) NOT NULL COMMENT '设备编号',
    `device_type` varchar(4) NOT NULL COMMENT '设备类型',
    `date_str` varchar(20) NOT NULL COMMENT '时间',
    `create_time` datetime default NULL COMMENT '创建时间',
    `update_time` datetime default NULL COMMENT '修改时间',
    PRIMARY KEY (`id`) );
    CREATE INDEX "index_ind_device_hour_0919_2025-10-01_date_str" ON "ind_device_hour_0919_2025-10-01"(date_str);
    CREATE INDEX "index_ind_device_hour_0919_2025-10-01_device_id" ON "ind_device_hour_0919_2025-10-01"(device_id);
    CREATE UNIQUE INDEX "index_ind_device_hour_0919_2025-10-01_device_date" ON "ind_device_hour_0919_2025-10-01"(`device_id`,`date_str`);

以上是创建表的语句

SQLark截图

idea报错截图