I need an example how to use ClientV2 and ExternalTable
For example I have a simple query select * from numbers(10) where number in ExternalTable;
final Client client = new Client.Builder().setUsername("default").setPassword("").addEndpoint("http://localhost:8123/")
.build();
final String sql = "select * from numbers(10) where number in ExternalTable";
QueryResponse response = client.query(sql).get(3, TimeUnit.SECONDS);
ClickHouseBinaryFormatReader reader = client.newBinaryFormatReader(response);
while (reader.hasNext()) {
reader.next();
System.out.println(reader.getLong("number"));
}And I need to pass 1\n\2\n3 as ExternalTable.
Like here
|
try (ClickHouseResponse response = request |
Or here #891
https://clickhouse.com/docs/engines/table-engines/special/external-data
I need it because I want to pass a list with 200k values and a query size (SQL length) without using the external data is bigger than 1Mb.
I need an example how to use ClientV2 and ExternalTable
For example I have a simple query
select * from numbers(10) where number in ExternalTable;And I need to pass
1\n\2\n3asExternalTable.Like here
clickhouse-java/clickhouse-client/src/test/java/com/clickhouse/client/ClientIntegrationTest.java
Line 570 in bed84ee
Or here #891
https://clickhouse.com/docs/engines/table-engines/special/external-data
I need it because I want to pass a list with 200k values and a query size (SQL length) without using the external data is bigger than 1Mb.