由mysql数据同步到clickhouse 批量插入clickhouse 报错

wangxi得 发布于 03/11 17:45
阅读 545
收藏 0

开源之夏第三届火热来袭,高校学生参与赢万元奖金!>>>

16:21:53.528 [pool-7-thread-49] INFO  o.a.h.i.e.RetryExec - [execute,97] - I/O exception (java.net.SocketException) caught when processing request to {}->http://10.96.9.122:8123: Connection reset by peer: socket write error 16:21:53.528 [pool-7-thread-49] INFO  o.a.h.i.e.RetryExec - [execute,113] - Retrying request to {}->http://10.96.9.122:8123

16:29:31.805 [pool-7-thread-23] INFO  r.y.c.ClickHouseStatementImpl - [getInputStream,630] - Error during connection to ru.yandex.clickhouse.settings.ClickHouseProperties@11f01ccc, reporting failure to data source, message: 10.96.9.122:8123 failed to respond
16:29:31.808 [pool-7-thread-23] INFO  r.y.c.ClickHouseStatementImpl - [getInputStream,632] - Error sql: 

INSERT INTO t_electronic_back_order
        (
        id,
        orderCode,
        userName,
        scaleCode,
        orderTotalPrice,
        recordTime,
        orderPayMode,
        cabinetId,
        orderStatus,
        payDetail,
        oldOrderCode,
        moZero,
        actualMoney,
        operateFlag,
        orderCommodityWeight,
        cabinetName,
        cabinetCode
        )
        VALUES
          
            (
            2690277,
            '0007010070201906240171',
            '1001',
            '0070',
            4.33,
            '2019-06-24 00:00:00',
            null,
            '22',
            '0',
            null,
            '',
            0.03,
            4.3,
            0,
            0.62,
            '鹏海菜柜',
            '007'
            )

 

加载中
OSCHINA
登录后可查看更多优质内容
返回顶部
顶部