通过JDBC向TDSQL中批量插入数据报错,单条执行是可以的。请问这是TDSQL自己的限制嘛?
表结构
custom_event_report_realtime | CREATE TABLE `custom_event_report_realtime` (
`FId` int(10) unsigned NOT NULL AUTO_INCREMENT,
`FKFUin` bigint(20) NOT NULL,
`FTimestamp` bigint(20) NOT NULL,
`FUserID` varchar(100) NOT NULL,
`FEventName` varchar(100) NOT NULL,
`FProperties` json DEFAULT NULL,
PRIMARY KEY (`FId`),
KEY `FKFUin` (`FKFUin`),
KEY `FUserID` (`FKFUin`,`FUserID`),
KEY `FEventName` (`FKFUin`,`FEventName`),
KEY `user_eventname` (`FKFUin`,`FUserID`,`FEventName`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 shardkey=fid PARTITION BY RANGE ( day(FTimestamp) ) ( PARTITION p_20200809 VALUES LESS THAN (20200810), PARTITION p_20200810 VALUES LESS THAN (20200811), PARTITION p_20200811 VALUES LESS THAN (20200812), PARTITION p_20200812 VALUES LESS THAN (20200813))
插入语句
insert into custom_event_report_realtime ( FKFUin, FTimestamp, FUserID, FEventName, FProperties ) values (?, ?, ?, ?, ?) ON DUPLICATE KEY UPDATE FKFUin=?, FTimestamp=?, FUserID=?, FEventName=?, FProperties=?
单条执行是可以的,通过JDBC的batchexecute执行报错,提示Proxy ERROR:This type of SQL is not supported
相似问题