前言
最近在使用spark将数据写入clickhouse中,中间也遇到了一些问题,报错如下:
[ERROR 2019-08-15 11:19:12 (com.ly.data.ysck.tool.CKTool:47)] 插入异常
ru.yandex.clickhouse.except.ClickHouseUnknownException: ClickHouse exception, code: 1002, host: 172.20.89.26, port: 17133; Broken pipe
at ru.yandex.clickhouse.except.ClickHouseExceptionSpecifier.getException(ClickHouseExceptionSpecifier.java:88)
at ru.yandex.clickhouse.except.ClickHouseExceptionSpecifier.specify(ClickHouseExceptionSpecifier.java:55)
at ru.yandex.clickhouse.except.ClickHouseExceptionSpecifier.specify(ClickHouseExceptionSpecifier.java:24)
at ru.yandex.clickhouse.ClickHouseStatementImpl.sendStream(ClickHouseStatementImpl.java:795)
at ru.yandex.clickhouse.ClickHouseStatementImpl.sendStream(ClickHouseStatementImpl.java:773)
at ru.yandex.clickhouse.ClickHousePreparedStatementImpl.executeBatch(ClickHousePreparedStatementImpl.java:363)
at ru.yandex.clickhouse.ClickHousePreparedStatementImpl.executeBatch(ClickHousePreparedStatementImpl.java:348)
at com.ly.data.ysck.tool.CKTool.inseartData(CKTool.java:84)
at com.ly.data.ysck.tool.CKTool.inseartAction(CKTool.java:44)
at com.ly.data.ysc