背景:项目中是使用mysql协议直接连接doris,发现保存数据时,insert into mytable values ..语句执行效率和mysql库相差较大,所以想试试group commit配置。
url配置:原本是jdbc:mysql://ip:9030/mydatabase?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&allowMultiQueries=true&rewriteBatchedStatements=true
替换为:jdbc:mysql://ip:9030/epc_syzs_smk?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&allowMultiQueries=true&rewriteBatchedStatements=true&useServerPrepStmts=true&useLocalSessionState=true&rewriteBatchedStatements=true&cachePrepStmts=true&prepStmtCacheSqlLimit=99999&prepStmtCacheSize=500&sessionVariables=group_commit=sync_mode
发现的问题:
1、在insert into 时,出现相同的sql重复执行的情况
2、两个表根据相同的列event_time进行分区,
sql语句: SELECT count(0)FROM table1 c LEFT JOIN table2 p ON c.epc_code = p.epc_code WHERE。。。
关联查询时,出现java.sql.SQLIntegrityConstraintViolationException: errCode = 2, detailMessage = Column 'event_time' in field list is ambiguous。