首页
学习
活动
专区
工具
TVP
发布
社区首页 >问答首页 >TDSQL JDBC batchexecute插入数据报错,是TDSQL不支持嘛?

TDSQL JDBC batchexecute插入数据报错,是TDSQL不支持嘛?

提问于 2020-08-11 14:19:37
回答 1关注 0查看 904

通过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

相关文章

相似问题

相关问答用户
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档