How to insert Array(String) using clickhouse-http-client 4.6 (RowBinary) ? #1425

Activity

1. zhicwu commented on Aug 24, 2023

   

   zhicwu

   on Aug 24, 2023

   Contributor

   More actions

   Hi @den-crane, you can use ClickHouseDataProcessor to find proper serializers for serialization, and use *Value object to set values. It's kind of tedius but here below is an example:

   // table: (a String, b Nullable(String), c Array(String))
   try (ClickHousePipedOutputStream stream = ClickHouseDataStreamFactory.getInstance()
           .createPipedOutputStream(config, (Runnable) null)) {
       // in async mode, which is default, execution happens in a worker thread
       future = request.data(stream.getInputStream()).execute();
   
       List<ClickHouseColumn> columns = ClickHouseColumn
               .parse("a String, b Nullable(String), c Array(String)");
       ClickHouseDataProcessor processor = ClickHouseDataStreamFactory.getInstance().getProcessor(config, null,
               stream, null, columns);
       ClickHouseValue[] values = new ClickHouseValue[] {
               ClickHouseStringValue.ofNull(), // columns.get(0).newValue()
               ClickHouseStringValue.ofNull(), // columns.get(1).newValue()
               ClickHouseArrayValue.of(new String[0]) // columns.get(2).newValue()
       };
       ClickHouseSerializer[] serializers = processor.getSerializers(config, columns);
       // writing happens in main thread
       for (int i = 0; i < 10_000; i++) {
           serializers[0].serialize(values[0].update(String.valueOf(i % 16)), stream);
           serializers[1].serialize(values[1].update(UUID.randomUUID().toString()), stream);
           serializers[2].serialize(values[2].update(new String[] { "1", "2" }), stream);
       }
   }
   
   // response should be always closed
   try (ClickHouseResponse response = future.get()) {
       ClickHouseResponseSummary summary = response.getSummary();
       return summary.getWrittenRows();
   }
2. zhicwu

   added

   code-example

   on Aug 24, 2023
3. mshustov

   added

   area:docsDocumentation missingDocumentation missing

   on Aug 31, 2023
4. mshustov

   added this to the v0.5.1 milestone on Aug 31, 2023
5. chernser

   added

   module-clientClient API and all implementationsClient API and all implementations

   on Jun 18, 2024
6. chernser

   added

   jdbc-v2jdbc-v2 issuesjdbc-v2 issues

   on Jan 9, 2025
7. chernser commented on Jan 9, 2025

   

   chernser

   on Jan 9, 2025

   Contributor

   More actions

   need clear documentation
8. chernser

   added

   area:data-typedata type processing issuesdata type processing issues

   on Jan 10, 2025
9. chernser

   removed this from the old v0.6.later milestone on Nov 17, 2025
10. chernser

    added this to the 0.12.0 milestone on Jul 22, 2026
11. chernser

    added a parent issue on Nov 5, 2026

    • [Data Types] Wrapper (Array, Tuple, Map, Variant, etc. ) #3299