Cause: java.sql.SQLSyntaxErrorException: already stopped, skip waiting for close. cancelled/!eos: : 1/0
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: already stopped, skip waiting for close. cancelled/!eos: : 1/0] with root cause
java.sql.SQLSyntaxErrorException: already stopped, skip waiting for close. cancelled/!eos: : 1/0
DDL
CREATE TABLE a(
event_time date,
id int DEFAULT '1',
code char(8) DEFAULT '',
name char(8) DEFAULT '',
value decimal(16,6) SUM DEFAULT '0'
)
ENGINE=olap
AGGREGATE KEY(event_time, id, code, name)
PARTITION BY RANGE(event_time)
(
PARTITION p202108 VALUES LESS THAN ('2021-09-01'),
PARTITION p202109 VALUES LESS THAN ('2021-10-01'),
PARTITION p202110 VALUES LESS THAN ('2021-11-01'),
PARTITION p202111 VALUES LESS THAN ('2021-12-01'),
PARTITION p202112 VALUES LESS THAN ('2022-01-01'),
PARTITION p202201 VALUES LESS THAN ('2022-02-01'),
PARTITION p202202 VALUES LESS THAN ('2022-03-01'),
PARTITION p202203 VALUES LESS THAN ('2022-04-01'),
PARTITION p202204 VALUES LESS THAN ('2022-05-01'),
PARTITION p202205 VALUES LESS THAN ('2022-06-01'),
PARTITION p202206 VALUES LESS THAN ('2022-07-01'),
PARTITION p202207 VALUES LESS THAN ('2022-08-01'),
PARTITION p202208 VALUES LESS THAN ('2022-09-01')
)
DISTRIBUTED BY HASH(id) BUCKETS 8
PROPERTIES(
"replication_num" = "2",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "MONTH",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "8",
"dynamic_partition.end" = "12"
);
使用mybatis批量插入:
insert into a values (xx),(xx)
的方式
insert into a values
<foreach collection="list" item="item" separator=",">
(#{item.eventTime}, #{item.id}, #{item.code}, #{item.name}, #{item.value})
</foreach>
不知道这个是什么问题导致,恳请解惑,谢谢~