Skip to content

Unsupported data type: Nested #2477

@Marina-Kr

Description

@Marina-Kr

Hi. I have a table with nested columns.
I tried to write some data in this table by RowBinaryFormatWriter and v-2 Client

var writer = new RowBinaryFormatWriter(outputStream, tableSchema, RowBinary);
for (var v : values()) {
for (var i = 0; i < columns.size(); i++) {
writer.setValue(i + 1, fields.get(i).getGetter().apply(v)); // method setValue subtracts 1 from i
}
try {
writer.commitRow();
} catch (Exception e) {
logger.error("could not commit row: {}", v.toString(), e);
}
}
try (var inputStream = new ByteArrayInputStream(outputStream.toByteArray());
) {
return Optional.of(clickHouseClient.insert(requestBlank.getTargetTable(), columnNames, inputStream, RowBinary));
}

Got this error:

java.lang.UnsupportedOperationException: Unsupported data type: Nested
at com.clickhouse.client.api.data_formats.internal.SerializerUtils.serializePrimitiveData(SerializerUtils.java:584) ~[blob_p-88549d7ddc9b5c7aafeb1f2c6795ccb57f49c5ad-ebf8f6eee257cdf8789714cb8df41813:?]
at com.clickhouse.client.api.data_formats.internal.SerializerUtils.serializeData(SerializerUtils.java:104) ~[blob_p-88549d7ddc9b5c7aafeb1f2c6795ccb57f49c5ad-ebf8f6eee257cdf8789714cb8df41813:?]
at com.clickhouse.client.api.data_formats.internal.SerializerUtils.serializeArrayData(SerializerUtils.java:430) ~[blob_p-88549d7ddc9b5c7aafeb1f2c6795ccb57f49c5ad-ebf8f6eee257cdf8789714cb8df41813:?]
at com.clickhouse.client.api.data_formats.internal.SerializerUtils.serializeData(SerializerUtils.java:66) ~[blob_p-88549d7ddc9b5c7aafeb1f2c6795ccb57f49c5ad-ebf8f6eee257cdf8789714cb8df41813:?]
at com.clickhouse.client.api.data_formats.RowBinaryFormatWriter.commitRow(RowBinaryFormatWriter.java:98) ~[blob_p-88549d7ddc9b5c7aafeb1f2c6795ccb57f49c5ad-ebf8f6eee257cdf8789714cb8df41813:?]
at ru.sberbank.nba.flinkclickhousesink.applied.RowBinaryClickHouseWriterV2Impl$WriterTask.sendRequest(RowBinaryClickHouseWriterV2Impl.java:287) [blob_p-88549d7ddc9b5c7aafeb1f2c6795ccb57f49c5ad-ebf8f6eee257cdf8789714cb8df41813:?]
at ru.sberbank.nba.flinkclickhousesink.applied.RowBinaryClickHouseWriterV2Impl$WriterTask.send(RowBinaryClickHouseWriterV2Impl.java:263) [blob_p-88549d7ddc9b5c7aafeb1f2c6795ccb57f49c5ad-ebf8f6eee257cdf8789714cb8df41813:?]
at ru.sberbank.nba.flinkclickhousesink.applied.RowBinaryClickHouseWriterV2Impl$WriterTask.runInternal(RowBinaryClickHouseWriterV2Impl.java:251) [blob_p-88549d7ddc9b5c7aafeb1f2c6795ccb57f49c5ad-ebf8f6eee257cdf8789714cb8df41813:?]
at ru.sberbank.nba.flinkclickhousesink.applied.RowBinaryClickHouseWriterV2Impl$WriterTask.run(RowBinaryClickHouseWriterV2Impl.java:234) [blob_p-88549d7ddc9b5c7aafeb1f2c6795ccb57f49c5ad-ebf8f6eee257cdf8789714cb8df41813:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539) [?:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) [?:?]
at java.lang.Thread.run(Thread.java:840) [?:?]

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions