Queries with external data specified are not parsed correctly in the clickhouse server

[Zark1999]

Bug Description

Clickhouse Version: 21.3.4.25
JDBC Version: 0.3.1-patch

When executing queries with several ClickhouseExternalData, the server side has a possiblility that the parsed sql (store in system.query_log) is incorrect, which causes either syntax error or missing column exception.

---

e.g.
Querying about the avg, sum, min, max and any of column Ca with some extra conditions
L0, L1 ... and L9 are ClickhouseExternalData specified on the client side that pass along with the http uri

A correct query would be

select avgIf(Ca, Cb in L0) as avgCa1, sumIf(Ca, Cb in L0) as sumCa1, minIf(Ca, Cb in L0) as minCa1, maxIf(Ca, Cb in L0) as maxCa1, anyIf(Ca, Cb in L0) as anyCa1, avgIf(Ca, Cb in L1) as avgCa2, sumIf(Ca, Cb in L1) as sumCa2, minIf(Ca, Cb in L1) as minCa2, maxIf(Ca, Cb in L1) as maxCa2, anyIf(Ca, Cb in L1) as anyCa2, avgIf(Ca, Cb in L2) as avgCa3, sumIf(Ca, Cb in L2) as sumCa3, minIf(Ca, Cb in L2) as minCa3, maxIf(Ca, Cb in L2) as maxCa3, anyIf(Ca, Cb in L2) as anyCa3, avgIf(Ca, Cb in L3) as avgCa4, sumIf(Ca, Cb in L3) as sumCa4, minIf(Ca, Cb in L3) as minCa4, maxIf(Ca, Cb in L3) as maxCa4, anyIf(Ca, Cb in L3) as anyCa4, avgIf(Ca, Cb in L4) as avgCa5, sumIf(Ca, Cb in L4) as sumCa5, minIf(Ca, Cb in L4) as minCa5, maxIf(Ca, Cb in L4) as maxCa5, anyIf(Ca, Cb in L4) as anyCa5, avgIf(Ca, Cb in L5) as avgCa6, sumIf(Ca, Cb in L5) as sumCa6, minIf(Ca, Cb in L5) as minCa6, maxIf(Ca, Cb in L5) as maxCa6, anyIf(Ca, Cb in L5) as anyCa6, avgIf(Ca, Cb in L6) as avgCa7, sumIf(Ca, Cb in L6) as sumCa7, minIf(Ca, Cb in L6) as minCa7, maxIf(Ca, Cb in L6) as maxCa7, anyIf(Ca, Cb in L6) as anyCa7, avgIf(Ca, Cb in L7) as avgCa8, sumIf(Ca, Cb in L7) as sumCa8, minIf(Ca, Cb in L7) as minCa8, maxIf(Ca, Cb in L7) as maxCa8, anyIf(Ca, Cb in L7) as anyCa8, avgIf(Ca, Cb in L8) as avgCa9, sumIf(Ca, Cb in L8) as sumCa9, minIf(Ca, Cb in L8) as minCa9, maxIf(Ca, Cb in L8) as maxCa9, anyIf(Ca, Cb in L8) as anyCa9, avgIf(Ca, Cb in L9) as avgCa10, sumIf(Ca, Cb in L9) as sumCa10, minIf(Ca, Cb in L9) as minCa10, maxIf(Ca, Cb in L9) as maxCa10, anyIf(Ca, Cb in L9) as anyCa10 from test.test_table where TIMESTAMP >= 1625644740 and TIMESTAMP < 1625644800 and Cc = 'some value'
FORMAT TabSeparatedWithNamesAndTypes

It is supposed to have two lines , whereas the first line is a large query and the second line is added by jdbc.

However, in the query_log I saw queries like

select avgIf(Ca, Cb in L0) as avgCa1, sumIf(Ca, Cb in L0) as sumCa1, minIf(Ca, Cb in L0) as minCa1, maxIf(Ca, Cb in L0) as maxCa1, anyIf(Ca, Cb in L0) as anyCa1, avgIf(Ca, Cb in L1) as avgCa2, sumIf(Ca, Cb in L1) as sumCa2, minIf(Ca, Cb in L1) as minCa2, maxIf(Ca, Cb in L1) as maxCa2, anyIf(Ca, Cb in L1) as anyCa2, avgIf(Ca, Cb in L2) as avgCa3, sumIf(Ca, Cb in L2) as sumCa3, minIf(Ca, Cb in L2) as minCa3, maxIf(Ca, Cb in L2) as maxCa3, anyIf(Ca, Cb in L2) as anyCa3, avgIf(Ca, Cb in L3) as avgCa4, sumIf(Ca, Cb in L3) as sumCa4, minIf(Ca, Cb in L3) as minCa4, maxIf(Ca, Cb in L3) as maxCa4, anyIf(Ca, Cb in L3) as anyCa4, avgIf(Ca, Cb in L4) as avgCa5, sumIf(Ca, Cb in L4) as sumCa5, minIf(Ca, Cb in L4) as minCa5, maxIf(Ca, Cb in L4) as maxCa5, anyIf(Ca, Cb in L4) as anyCa5, avgIf(Ca, Cb in L5) as avgCa6, sumIf(Ca, Cb in L5) as sumCa6, minIf(Ca, Cb in L5) as minCa6, maxIf(Ca, Cb in L5) as maxCa6, anyIf(Ca, Cb in L5) as anyCa6, avgIf(Ca, Cb in L6) as avgCa7, sumIf(Ca, Cb in L6) as sumCa7, minIf(Ca, Cb in L6) as minCa7, maxIf(Ca, Cb in L6) as maxCa7, anyIf(Ca, Cb in L6) as anyCa7, avgIf(Ca, Cb in L7) as avgCa8, sumIf(Ca, Cb in L7) as sumCa8, minIf(Ca, Cb in L7) as minCa8, maxIf(Ca, Cb in L7) as maxCa8, anyIf(Ca, Cb in L7) as anyCa8, avgIf(Ca, Cb in L8) as avgCa9, sumIf(Ca, Cb in L8) as sumCa9, minIf(Ca, Cb in L8) as minCa9, maxIf(Ca, Cb in L8) as maxCa9, anyIf(Ca, Cb in L8) as anyCa9, avgIf(Ca, Cb in L9) as avgCa10, sumIf(Ca, Cb in L9) as sumCa10, minIf(Ca, Cb in L9) as minCa10, maxIf(Ca, Cb in L9) as maxCa10, anyIf(Ca, Cb in L9) as anyCa10 from test.test_table where TIMESTAMP >= 1625646900 and TIMESTAMP < 1625646960 and Cc = 'some value'
 TIMESTAMP >= 1625646900 and TIMESTAMP < 1625646960 and Cc = 'some value'
FORMAT TabSeparatedWithNamesAndTypes

and

select avgIf(Ca, DN in L0) as avgCa1, sumIf(Ca, DN in L0) as sumCa1, minIf(Ca, DN in L0) as minCa1, maxIf(Ca, DN in L0) as maxCa1, anyIf(Ca, DN in L0) as anyCa1, avgIf(Ca, DN in L1) as avgCa2, sumIf(Ca, DN in L1) as sumCa2, minIf(Ca, DN in L1) as minCa2, maxIf(Ca, DN in L1) as maxCa2, anyIf(Ca, DN in L1) as anyCa2, avgIf(Ca, DN in L2) as avgCa3, sumIf(Ca, DN in L2) as sumCa3, minIf(Ca, DN in L2) as minCa3, maxIf(Ca, DN in L2) as maxCa3, anyIf(Ca, DN in L2) as anyCa3, avgIf(Ca, DN in L3) as avgCa4, sumIf(Ca, DN in L3) as sumCa4, minIf(Ca, DN in L3) as minCa4, maxIf(Ca, DN in L3) as maxCa4, anyIf(Ca, DN in L3) as anyCa4, avgIf(Ca, DN in L4) as avgCa5, sumIf(Ca, DN in L4) as sumCa5, minIf(Ca, DN in L4) as minCa5, maxIf(Ca, DN in L4) as maxCa5, anyIf(Ca, DN in L4) as anyCa5, avgIf(Ca, DN in L5) as avgCa6, sumIf(Ca, DN in L5) as sumCa6, minIf(Ca, DN in L5) as minCa6, maxIf(Ca, DN in L5) as maxCa6, anyIf(Ca, DN in L5) as anyCa6, avgIf(Ca, DN in L6) as avgCa7, sumIf(Ca, DN in L6) as sumCa7, minIf(Ca, DN in L6) as minCa7, maxIf(Ca, DN in L6) as maxCa7, anyIf(Ca, DN in L6) as anyCa7, avgIf(Ca, DN in L7) as avgCa8, sumIf(Ca, DN in L7) as sumCa8, minIf(Ca, DN in L7) as minCa8, maxIf(Ca, DN in L7) as maxCa8, anyIf(Ca, DN in L7) as anyCa8, avgIf(Ca, DN in L8) as avgCa9, sumIf(Ca, DN in L8) as sumCa9, minIf(Ca, DN in L8) as minCa9, maxIf(Ca, DN in L8) as maxCa9, anyIf(Ca, DN in L8) as anyCa9, avgIf(Ca, DN in L9) as avgCa10, sumIf(Ca, DN in L9) as sumCa10, minIf(Ca, DN in L9) as minCa10, maxIf(Ca, DN in L9) as maxCa10, anyIf(Ca, DN in L9) as anyCa10 from test.DT_NETWORKIF1 where TIMESTAMP >= 1625646840 and TIMESTAMP < 1625646900 and IFNAME = 'eth0'
a, Cb in L3) as avgCa4, sumIf(Ca, Cb in L3) as sumCa4, minIf(Ca, Cb in L3) as minCa4, maxIf(Ca, Cb in L3) as maxCa4, anyIf(Ca, Cb in L3) as anyCa4, avgIf(Ca, Cb in L4) as avgCa5, sumIf(Ca, Cb in L4) as sumCa5, minIf(Ca, Cb in L4) as minCa5, maxIf(Ca, Cb in L4) as maxCa5, anyIf(Ca, Cb in L4) as anyCa5, avgIf(Ca, Cb in L5) as avgCa6, sumIf(Ca, Cb in L5) as sumCa6, minIf(Ca, Cb in L5) as minCa6, maxIf(Ca, Cb in L5) as maxCa6, anyIf(Ca, Cb in L5) as anyCa6, avgIf(Ca, Cb in L6) as avgCa7, sumIf(Ca, Cb in L6) as sumCa7, minIf(Ca, Cb in L6) as minCa7, maxIf(Ca, Cb in L6) as maxCa7, anyIf(Ca, Cb in L6) as anyCa7, avgIf(Ca, Cb in L7) as avgCa8, sumIf(Ca, Cb in L7) as sumCa8, minIf(Ca, Cb in L7) as minCa8, maxIf(Ca, Cb in L7) as maxCa8, anyIf(Ca, Cb in L7) as anyCa8, avgIf(Ca, Cb in L8) as avgCa9, sumIf(Ca, Cb in L8) as sumCa9, minIf(Ca, Cb in L8) as minCa9, maxIf(Ca, Cb in L8) as maxCa9, anyIf(Ca, Cb in L8) as anyCa9, avgIf(Ca, Cb in L9) as avgCa10, sumIf(Ca, Cb in L9) as sumCa10, minIf(Ca, Cb in L9) as minCa10, maxIf(Ca, Cb in L9) as maxCa10, anyIf(Ca, Cb in L9) as anyCa10 from test.test_table where TIMESTAMP >= 1625646840 and TIMESTAMP < 1625646900 and Cc= 'some value'
FORMAT TabSeparatedWithNamesAndTypes

Some parts in the original query was duplicated in the second line and that directly caused many kinds of expcetions. The parsed query stored in system.query_log table differs almost every time I run it (in the case where exception is thrown)

BTW, it worked fine with Clickhouse version 20.8.12.2 and jdbc version 0.3.1-patch. I have checked the client side using debugger mode, and the parsedStmt and httpContext seemed ok to me.

---

How to reproduce

1. creare a table with engine replicatedMergeTree, no need to insert data.
2. On the java side, send a query to the server side with aggregate function and externaldata specified (like the example shown above),
3. The larger the query size and number of externalData, the higher the possibility that the query throws exception.

[kitaisreal]

@zhicwu can you take a look at it ?

[zhicwu]

Sure, I'll look into this today.

The timestamps are different in above queries so I guess the major differences are in the where clause. I haven't enabled SQL rewrite in JDBC driver yet but it's possible related to SQL parsing.

[zhicwu]

@Zark1999, I was not able to reproduce the issue on both 20.8 and 21.3. Does it has to be ReplicatedMergeTree? Are you saying the exact same case on 20.8 worked but not on 21.3? And the two environments are similar?

It sounds like a server side issue, but can you add log4j.logger.org.apache.http=DEBUG into your log4j.properties to check if JDBC driver somehow changed the query before sending to server?

[den-crane]

I was unable to reproduce it with ch server + curl .

21.8.1.7290

create table test_table(Ca Int64, Cb Int64, Cc String, TIMESTAMP Int64) Engine=Memory;

for i in `seq 1 5000`; do curl -s -F 'L0=@L0' -F 'L1=@L0' -F 'L2=@L0' -F 'L3=@L0' -F 'L4=@L0' -F 'L5=@L0' -F 'L6=@L0' -F 'L7=@L0' -F 'L8=@L0' -F 'L9=@L0' `cat test_table.sql`; echo -n "."; done

26046.tar.gz

[Zark1999]

@zhicwu

Sorry that my example is ambiguous. Let me rephrase the whole process in a clearer way (with some data masking).
In order to make the query has a higher chance to throw the exception, I will construct a more complex query.

The table engine is ReplicatedMergeTree. I am not sure whether this affects how sql is parsed on the server side or not.
The table has sorting key (Cb,TIMESTAMP,Cc), with some other columns Ca1, Ca2, Ca3

1. On Java side, create a ClickHouseStatement, a hashMap that specifies the priority and 30 ClickHouseExternalData

ClickHouseStatement statement = conn.createStatement();

Map<ClickHouseQueryParam, String> paramMap = new HashMap<>();
paramMap.put(ClickHouseQueryParam.PRIORITY,"2");

// example of creating one ClickhouseExternalData 'L0', the size of valueList is 10. Every ClickHouseExternalData uses different valueList.
String extStr = String.join("\n", valueList);
InputStream inputStream = new ByteArrayInputStream(extStr.getBytes(Charset.forName("UTF-8")));
ClickHouseExternalData extData = new ClickHouseExternalData("L0", inputStream);
extData.setStructure("Cb String");
extDataList.add(extData);

2. Concate all the aggregate functions (on three different field) in one query, the original sql before execution is shown below.
   Basically what it does is, for fields Ca1, Ca2 and Ca3, call aggregate function sumIf, avgIf, minIf, maxIf, anyIf with 30 different conditions like Cb in L0, Cb in L1 etc.

select avgIf(Ca1, Cb in L0) as avgCa11, sumIf(Ca1, Cb in L0) as sumCa11, minIf(Ca1, Cb in L0) as minCa11, maxIf(Ca1, Cb in L0) as maxCa11, anyIf(Ca1, Cb in L0) as anyCa11, avgIf(Ca2, Cb in L0) as avgCa21, sumIf(Ca2, Cb in L0) as sumCa21, minIf(Ca2, Cb in L0) as minCa21, maxIf(Ca2, Cb in L0) as maxCa21, anyIf(Ca2, Cb in L0) as anyCa21, avgIf(Ca3, Cb in L0) as avgCa31, sumIf(Ca3, Cb in L0) as sumCa31, minIf(Ca3, Cb in L0) as minCa31, maxIf(Ca3, Cb in L0) as maxCa31, anyIf(Ca3, Cb in L0) as anyCa31, avgIf(Ca1, Cb in L1) as avgCa12, sumIf(Ca1, Cb in L1) as sumCa12, minIf(Ca1, Cb in L1) as minCa12, maxIf(Ca1, Cb in L1) as maxCa12, anyIf(Ca1, Cb in L1) as anyCa12, avgIf(Ca2, Cb in L1) as avgCa22, sumIf(Ca2, Cb in L1) as sumCa22, minIf(Ca2, Cb in L1) as minCa22, maxIf(Ca2, Cb in L1) as maxCa22, anyIf(Ca2, Cb in L1) as anyCa22, avgIf(Ca3, Cb in L1) as avgCa32, sumIf(Ca3, Cb in L1) as sumCa32, minIf(Ca3, Cb in L1) as minCa32, maxIf(Ca3, Cb in L1) as maxCa32, anyIf(Ca3, Cb in L1) as anyCa32, avgIf(Ca1, Cb in L2) as avgCa13, sumIf(Ca1, Cb in L2) as sumCa13, minIf(Ca1, Cb in L2) as minCa13, maxIf(Ca1, Cb in L2) as maxCa13, anyIf(Ca1, Cb in L2) as anyCa13, avgIf(Ca2, Cb in L2) as avgCa23, sumIf(Ca2, Cb in L2) as sumCa23, minIf(Ca2, Cb in L2) as minCa23, maxIf(Ca2, Cb in L2) as maxCa23, anyIf(Ca2, Cb in L2) as anyCa23, avgIf(Ca3, Cb in L2) as avgCa33, sumIf(Ca3, Cb in L2) as sumCa33, minIf(Ca3, Cb in L2) as minCa33, maxIf(Ca3, Cb in L2) as maxCa33, anyIf(Ca3, Cb in L2) as anyCa33, avgIf(Ca1, Cb in L3) as avgCa14, sumIf(Ca1, Cb in L3) as sumCa14, minIf(Ca1, Cb in L3) as minCa14, maxIf(Ca1, Cb in L3) as maxCa14, anyIf(Ca1, Cb in L3) as anyCa14, avgIf(Ca2, Cb in L3) as avgCa24, sumIf(Ca2, Cb in L3) as sumCa24, minIf(Ca2, Cb in L3) as minCa24, maxIf(Ca2, Cb in L3) as maxCa24, anyIf(Ca2, Cb in L3) as anyCa24, avgIf(Ca3, Cb in L3) as avgCa34, sumIf(Ca3, Cb in L3) as sumCa34, minIf(Ca3, Cb in L3) as minCa34, maxIf(Ca3, Cb in L3) as maxCa34, anyIf(Ca3, Cb in L3) as anyCa34, avgIf(Ca1, Cb in L4) as avgCa15, sumIf(Ca1, Cb in L4) as sumCa15, minIf(Ca1, Cb in L4) as minCa15, maxIf(Ca1, Cb in L4) as maxCa15, anyIf(Ca1, Cb in L4) as anyCa15, avgIf(Ca2, Cb in L4) as avgCa25, sumIf(Ca2, Cb in L4) as sumCa25, minIf(Ca2, Cb in L4) as minCa25, maxIf(Ca2, Cb in L4) as maxCa25, anyIf(Ca2, Cb in L4) as anyCa25, avgIf(Ca3, Cb in L4) as avgCa35, sumIf(Ca3, Cb in L4) as sumCa35, minIf(Ca3, Cb in L4) as minCa35, maxIf(Ca3, Cb in L4) as maxCa35, anyIf(Ca3, Cb in L4) as anyCa35, avgIf(Ca1, Cb in L5) as avgCa16, sumIf(Ca1, Cb in L5) as sumCa16, minIf(Ca1, Cb in L5) as minCa16, maxIf(Ca1, Cb in L5) as maxCa16, anyIf(Ca1, Cb in L5) as anyCa16, avgIf(Ca2, Cb in L5) as avgCa26, sumIf(Ca2, Cb in L5) as sumCa26, minIf(Ca2, Cb in L5) as minCa26, maxIf(Ca2, Cb in L5) as maxCa26, anyIf(Ca2, Cb in L5) as anyCa26, avgIf(Ca3, Cb in L5) as avgCa36, sumIf(Ca3, Cb in L5) as sumCa36, minIf(Ca3, Cb in L5) as minCa36, maxIf(Ca3, Cb in L5) as maxCa36, anyIf(Ca3, Cb in L5) as anyCa36, avgIf(Ca1, Cb in L6) as avgCa17, sumIf(Ca1, Cb in L6) as sumCa17, minIf(Ca1, Cb in L6) as minCa17, maxIf(Ca1, Cb in L6) as maxCa17, anyIf(Ca1, Cb in L6) as anyCa17, avgIf(Ca2, Cb in L6) as avgCa27, sumIf(Ca2, Cb in L6) as sumCa27, minIf(Ca2, Cb in L6) as minCa27, maxIf(Ca2, Cb in L6) as maxCa27, anyIf(Ca2, Cb in L6) as anyCa27, avgIf(Ca3, Cb in L6) as avgCa37, sumIf(Ca3, Cb in L6) as sumCa37, minIf(Ca3, Cb in L6) as minCa37, maxIf(Ca3, Cb in L6) as maxCa37, anyIf(Ca3, Cb in L6) as anyCa37, avgIf(Ca1, Cb in L7) as avgCa18, sumIf(Ca1, Cb in L7) as sumCa18, minIf(Ca1, Cb in L7) as minCa18, maxIf(Ca1, Cb in L7) as maxCa18, anyIf(Ca1, Cb in L7) as anyCa18, avgIf(Ca2, Cb in L7) as avgCa28, sumIf(Ca2, Cb in L7) as sumCa28, minIf(Ca2, Cb in L7) as minCa28, maxIf(Ca2, Cb in L7) as maxCa28, anyIf(Ca2, Cb in L7) as anyCa28, avgIf(Ca3, Cb in L7) as avgCa38, sumIf(Ca3, Cb in L7) as sumCa38, minIf(Ca3, Cb in L7) as minCa38, maxIf(Ca3, Cb in L7) as maxCa38, anyIf(Ca3, Cb in L7) as anyCa38, avgIf(Ca1, Cb in L8) as avgCa19, sumIf(Ca1, Cb in L8) as sumCa19, minIf(Ca1, Cb in L8) as minCa19, maxIf(Ca1, Cb in L8) as maxCa19, anyIf(Ca1, Cb in L8) as anyCa19, avgIf(Ca2, Cb in L8) as avgCa29, sumIf(Ca2, Cb in L8) as sumCa29, minIf(Ca2, Cb in L8) as minCa29, maxIf(Ca2, Cb in L8) as maxCa29, anyIf(Ca2, Cb in L8) as anyCa29, avgIf(Ca3, Cb in L8) as avgCa39, sumIf(Ca3, Cb in L8) as sumCa39, minIf(Ca3, Cb in L8) as minCa39, maxIf(Ca3, Cb in L8) as maxCa39, anyIf(Ca3, Cb in L8) as anyCa39, avgIf(Ca1, Cb in L9) as avgCa110, sumIf(Ca1, Cb in L9) as sumCa110, minIf(Ca1, Cb in L9) as minCa110, maxIf(Ca1, Cb in L9) as maxCa110, anyIf(Ca1, Cb in L9) as anyCa110, avgIf(Ca2, Cb in L9) as avgCa210, sumIf(Ca2, Cb in L9) as sumCa210, minIf(Ca2, Cb in L9) as minCa210, maxIf(Ca2, Cb in L9) as maxCa210, anyIf(Ca2, Cb in L9) as anyCa210, avgIf(Ca3, Cb in L9) as avgCa310, sumIf(Ca3, Cb in L9) as sumCa310, minIf(Ca3, Cb in L9) as minCa310, maxIf(Ca3, Cb in L9) as maxCa310, anyIf(Ca3, Cb in L9) as anyCa310, avgIf(Ca1, Cb in L10) as avgCa111, sumIf(Ca1, Cb in L10) as sumCa111, minIf(Ca1, Cb in L10) as minCa111, maxIf(Ca1, Cb in L10) as maxCa111, anyIf(Ca1, Cb in L10) as anyCa111, avgIf(Ca2, Cb in L10) as avgCa211, sumIf(Ca2, Cb in L10) as sumCa211, minIf(Ca2, Cb in L10) as minCa211, maxIf(Ca2, Cb in L10) as maxCa211, anyIf(Ca2, Cb in L10) as anyCa211, avgIf(Ca3, Cb in L10) as avgCa311, sumIf(Ca3, Cb in L10) as sumCa311, minIf(Ca3, Cb in L10) as minCa311, maxIf(Ca3, Cb in L10) as maxCa311, anyIf(Ca3, Cb in L10) as anyCa311, avgIf(Ca1, Cb in L11) as avgCa112, sumIf(Ca1, Cb in L11) as sumCa112, minIf(Ca1, Cb in L11) as minCa112, maxIf(Ca1, Cb in L11) as maxCa112, anyIf(Ca1, Cb in L11) as anyCa112, avgIf(Ca2, Cb in L11) as avgCa212, sumIf(Ca2, Cb in L11) as sumCa212, minIf(Ca2, Cb in L11) as minCa212, maxIf(Ca2, Cb in L11) as maxCa212, anyIf(Ca2, Cb in L11) as anyCa212, avgIf(Ca3, Cb in L11) as avgCa312, sumIf(Ca3, Cb in L11) as sumCa312, minIf(Ca3, Cb in L11) as minCa312, maxIf(Ca3, Cb in L11) as maxCa312, anyIf(Ca3, Cb in L11) as anyCa312, avgIf(Ca1, Cb in L12) as avgCa113, sumIf(Ca1, Cb in L12) as sumCa113, minIf(Ca1, Cb in L12) as minCa113, maxIf(Ca1, Cb in L12) as maxCa113, anyIf(Ca1, Cb in L12) as anyCa113, avgIf(Ca2, Cb in L12) as avgCa213, sumIf(Ca2, Cb in L12) as sumCa213, minIf(Ca2, Cb in L12) as minCa213, maxIf(Ca2, Cb in L12) as maxCa213, anyIf(Ca2, Cb in L12) as anyCa213, avgIf(Ca3, Cb in L12) as avgCa313, sumIf(Ca3, Cb in L12) as sumCa313, minIf(Ca3, Cb in L12) as minCa313, maxIf(Ca3, Cb in L12) as maxCa313, anyIf(Ca3, Cb in L12) as anyCa313, avgIf(Ca1, Cb in L13) as avgCa114, sumIf(Ca1, Cb in L13) as sumCa114, minIf(Ca1, Cb in L13) as minCa114, maxIf(Ca1, Cb in L13) as maxCa114, anyIf(Ca1, Cb in L13) as anyCa114, avgIf(Ca2, Cb in L13) as avgCa214, sumIf(Ca2, Cb in L13) as sumCa214, minIf(Ca2, Cb in L13) as minCa214, maxIf(Ca2, Cb in L13) as maxCa214, anyIf(Ca2, Cb in L13) as anyCa214, avgIf(Ca3, Cb in L13) as avgCa314, sumIf(Ca3, Cb in L13) as sumCa314, minIf(Ca3, Cb in L13) as minCa314, maxIf(Ca3, Cb in L13) as maxCa314, anyIf(Ca3, Cb in L13) as anyCa314, avgIf(Ca1, Cb in L14) as avgCa115, sumIf(Ca1, Cb in L14) as sumCa115, minIf(Ca1, Cb in L14) as minCa115, maxIf(Ca1, Cb in L14) as maxCa115, anyIf(Ca1, Cb in L14) as anyCa115, avgIf(Ca2, Cb in L14) as avgCa215, sumIf(Ca2, Cb in L14) as sumCa215, minIf(Ca2, Cb in L14) as minCa215, maxIf(Ca2, Cb in L14) as maxCa215, anyIf(Ca2, Cb in L14) as anyCa215, avgIf(Ca3, Cb in L14) as avgCa315, sumIf(Ca3, Cb in L14) as sumCa315, minIf(Ca3, Cb in L14) as minCa315, maxIf(Ca3, Cb in L14) as maxCa315, anyIf(Ca3, Cb in L14) as anyCa315, avgIf(Ca1, Cb in L15) as avgCa116, sumIf(Ca1, Cb in L15) as sumCa116, minIf(Ca1, Cb in L15) as minCa116, maxIf(Ca1, Cb in L15) as maxCa116, anyIf(Ca1, Cb in L15) as anyCa116, avgIf(Ca2, Cb in L15) as avgCa216, sumIf(Ca2, Cb in L15) as sumCa216, minIf(Ca2, Cb in L15) as minCa216, maxIf(Ca2, Cb in L15) as maxCa216, anyIf(Ca2, Cb in L15) as anyCa216, avgIf(Ca3, Cb in L15) as avgCa316, sumIf(Ca3, Cb in L15) as sumCa316, minIf(Ca3, Cb in L15) as minCa316, maxIf(Ca3, Cb in L15) as maxCa316, anyIf(Ca3, Cb in L15) as anyCa316, avgIf(Ca1, Cb in L16) as avgCa117, sumIf(Ca1, Cb in L16) as sumCa117, minIf(Ca1, Cb in L16) as minCa117, maxIf(Ca1, Cb in L16) as maxCa117, anyIf(Ca1, Cb in L16) as anyCa117, avgIf(Ca2, Cb in L16) as avgCa217, sumIf(Ca2, Cb in L16) as sumCa217, minIf(Ca2, Cb in L16) as minCa217, maxIf(Ca2, Cb in L16) as maxCa217, anyIf(Ca2, Cb in L16) as anyCa217, avgIf(Ca3, Cb in L16) as avgCa317, sumIf(Ca3, Cb in L16) as sumCa317, minIf(Ca3, Cb in L16) as minCa317, maxIf(Ca3, Cb in L16) as maxCa317, anyIf(Ca3, Cb in L16) as anyCa317, avgIf(Ca1, Cb in L17) as avgCa118, sumIf(Ca1, Cb in L17) as sumCa118, minIf(Ca1, Cb in L17) as minCa118, maxIf(Ca1, Cb in L17) as maxCa118, anyIf(Ca1, Cb in L17) as anyCa118, avgIf(Ca2, Cb in L17) as avgCa218, sumIf(Ca2, Cb in L17) as sumCa218, minIf(Ca2, Cb in L17) as minCa218, maxIf(Ca2, Cb in L17) as maxCa218, anyIf(Ca2, Cb in L17) as anyCa218, avgIf(Ca3, Cb in L17) as avgCa318, sumIf(Ca3, Cb in L17) as sumCa318, minIf(Ca3, Cb in L17) as minCa318, maxIf(Ca3, Cb in L17) as maxCa318, anyIf(Ca3, Cb in L17) as anyCa318, avgIf(Ca1, Cb in L18) as avgCa119, sumIf(Ca1, Cb in L18) as sumCa119, minIf(Ca1, Cb in L18) as minCa119, maxIf(Ca1, Cb in L18) as maxCa119, anyIf(Ca1, Cb in L18) as anyCa119, avgIf(Ca2, Cb in L18) as avgCa219, sumIf(Ca2, Cb in L18) as sumCa219, minIf(Ca2, Cb in L18) as minCa219, maxIf(Ca2, Cb in L18) as maxCa219, anyIf(Ca2, Cb in L18) as anyCa219, avgIf(Ca3, Cb in L18) as avgCa319, sumIf(Ca3, Cb in L18) as sumCa319, minIf(Ca3, Cb in L18) as minCa319, maxIf(Ca3, Cb in L18) as maxCa319, anyIf(Ca3, Cb in L18) as anyCa319, avgIf(Ca1, Cb in L19) as avgCa120, sumIf(Ca1, Cb in L19) as sumCa120, minIf(Ca1, Cb in L19) as minCa120, maxIf(Ca1, Cb in L19) as maxCa120, anyIf(Ca1, Cb in L19) as anyCa120, avgIf(Ca2, Cb in L19) as avgCa220, sumIf(Ca2, Cb in L19) as sumCa220, minIf(Ca2, Cb in L19) as minCa220, maxIf(Ca2, Cb in L19) as maxCa220, anyIf(Ca2, Cb in L19) as anyCa220, avgIf(Ca3, Cb in L19) as avgCa320, sumIf(Ca3, Cb in L19) as sumCa320, minIf(Ca3, Cb in L19) as minCa320, maxIf(Ca3, Cb in L19) as maxCa320, anyIf(Ca3, Cb in L19) as anyCa320, avgIf(Ca1, Cb in L20) as avgCa121, sumIf(Ca1, Cb in L20) as sumCa121, minIf(Ca1, Cb in L20) as minCa121, maxIf(Ca1, Cb in L20) as maxCa121, anyIf(Ca1, Cb in L20) as anyCa121, avgIf(Ca2, Cb in L20) as avgCa221, sumIf(Ca2, Cb in L20) as sumCa221, minIf(Ca2, Cb in L20) as minCa221, maxIf(Ca2, Cb in L20) as maxCa221, anyIf(Ca2, Cb in L20) as anyCa221, avgIf(Ca3, Cb in L20) as avgCa321, sumIf(Ca3, Cb in L20) as sumCa321, minIf(Ca3, Cb in L20) as minCa321, maxIf(Ca3, Cb in L20) as maxCa321, anyIf(Ca3, Cb in L20) as anyCa321, avgIf(Ca1, Cb in L21) as avgCa122, sumIf(Ca1, Cb in L21) as sumCa122, minIf(Ca1, Cb in L21) as minCa122, maxIf(Ca1, Cb in L21) as maxCa122, anyIf(Ca1, Cb in L21) as anyCa122, avgIf(Ca2, Cb in L21) as avgCa222, sumIf(Ca2, Cb in L21) as sumCa222, minIf(Ca2, Cb in L21) as minCa222, maxIf(Ca2, Cb in L21) as maxCa222, anyIf(Ca2, Cb in L21) as anyCa222, avgIf(Ca3, Cb in L21) as avgCa322, sumIf(Ca3, Cb in L21) as sumCa322, minIf(Ca3, Cb in L21) as minCa322, maxIf(Ca3, Cb in L21) as maxCa322, anyIf(Ca3, Cb in L21) as anyCa322, avgIf(Ca1, Cb in L22) as avgCa123, sumIf(Ca1, Cb in L22) as sumCa123, minIf(Ca1, Cb in L22) as minCa123, maxIf(Ca1, Cb in L22) as maxCa123, anyIf(Ca1, Cb in L22) as anyCa123, avgIf(Ca2, Cb in L22) as avgCa223, sumIf(Ca2, Cb in L22) as sumCa223, minIf(Ca2, Cb in L22) as minCa223, maxIf(Ca2, Cb in L22) as maxCa223, anyIf(Ca2, Cb in L22) as anyCa223, avgIf(Ca3, Cb in L22) as avgCa323, sumIf(Ca3, Cb in L22) as sumCa323, minIf(Ca3, Cb in L22) as minCa323, maxIf(Ca3, Cb in L22) as maxCa323, anyIf(Ca3, Cb in L22) as anyCa323, avgIf(Ca1, Cb in L23) as avgCa124, sumIf(Ca1, Cb in L23) as sumCa124, minIf(Ca1, Cb in L23) as minCa124, maxIf(Ca1, Cb in L23) as maxCa124, anyIf(Ca1, Cb in L23) as anyCa124, avgIf(Ca2, Cb in L23) as avgCa224, sumIf(Ca2, Cb in L23) as sumCa224, minIf(Ca2, Cb in L23) as minCa224, maxIf(Ca2, Cb in L23) as maxCa224, anyIf(Ca2, Cb in L23) as anyCa224, avgIf(Ca3, Cb in L23) as avgCa324, sumIf(Ca3, Cb in L23) as sumCa324, minIf(Ca3, Cb in L23) as minCa324, maxIf(Ca3, Cb in L23) as maxCa324, anyIf(Ca3, Cb in L23) as anyCa324, avgIf(Ca1, Cb in L24) as avgCa125, sumIf(Ca1, Cb in L24) as sumCa125, minIf(Ca1, Cb in L24) as minCa125, maxIf(Ca1, Cb in L24) as maxCa125, anyIf(Ca1, Cb in L24) as anyCa125, avgIf(Ca2, Cb in L24) as avgCa225, sumIf(Ca2, Cb in L24) as sumCa225, minIf(Ca2, Cb in L24) as minCa225, maxIf(Ca2, Cb in L24) as maxCa225, anyIf(Ca2, Cb in L24) as anyCa225, avgIf(Ca3, Cb in L24) as avgCa325, sumIf(Ca3, Cb in L24) as sumCa325, minIf(Ca3, Cb in L24) as minCa325, maxIf(Ca3, Cb in L24) as maxCa325, anyIf(Ca3, Cb in L24) as anyCa325, avgIf(Ca1, Cb in L25) as avgCa126, sumIf(Ca1, Cb in L25) as sumCa126, minIf(Ca1, Cb in L25) as minCa126, maxIf(Ca1, Cb in L25) as maxCa126, anyIf(Ca1, Cb in L25) as anyCa126, avgIf(Ca2, Cb in L25) as avgCa226, sumIf(Ca2, Cb in L25) as sumCa226, minIf(Ca2, Cb in L25) as minCa226, maxIf(Ca2, Cb in L25) as maxCa226, anyIf(Ca2, Cb in L25) as anyCa226, avgIf(Ca3, Cb in L25) as avgCa326, sumIf(Ca3, Cb in L25) as sumCa326, minIf(Ca3, Cb in L25) as minCa326, maxIf(Ca3, Cb in L25) as maxCa326, anyIf(Ca3, Cb in L25) as anyCa326, avgIf(Ca1, Cb in L26) as avgCa127, sumIf(Ca1, Cb in L26) as sumCa127, minIf(Ca1, Cb in L26) as minCa127, maxIf(Ca1, Cb in L26) as maxCa127, anyIf(Ca1, Cb in L26) as anyCa127, avgIf(Ca2, Cb in L26) as avgCa227, sumIf(Ca2, Cb in L26) as sumCa227, minIf(Ca2, Cb in L26) as minCa227, maxIf(Ca2, Cb in L26) as maxCa227, anyIf(Ca2, Cb in L26) as anyCa227, avgIf(Ca3, Cb in L26) as avgCa327, sumIf(Ca3, Cb in L26) as sumCa327, minIf(Ca3, Cb in L26) as minCa327, maxIf(Ca3, Cb in L26) as maxCa327, anyIf(Ca3, Cb in L26) as anyCa327, avgIf(Ca1, Cb in L27) as avgCa128, sumIf(Ca1, Cb in L27) as sumCa128, minIf(Ca1, Cb in L27) as minCa128, maxIf(Ca1, Cb in L27) as maxCa128, anyIf(Ca1, Cb in L27) as anyCa128, avgIf(Ca2, Cb in L27) as avgCa228, sumIf(Ca2, Cb in L27) as sumCa228, minIf(Ca2, Cb in L27) as minCa228, maxIf(Ca2, Cb in L27) as maxCa228, anyIf(Ca2, Cb in L27) as anyCa228, avgIf(Ca3, Cb in L27) as avgCa328, sumIf(Ca3, Cb in L27) as sumCa328, minIf(Ca3, Cb in L27) as minCa328, maxIf(Ca3, Cb in L27) as maxCa328, anyIf(Ca3, Cb in L27) as anyCa328, avgIf(Ca1, Cb in L28) as avgCa129, sumIf(Ca1, Cb in L28) as sumCa129, minIf(Ca1, Cb in L28) as minCa129, maxIf(Ca1, Cb in L28) as maxCa129, anyIf(Ca1, Cb in L28) as anyCa129, avgIf(Ca2, Cb in L28) as avgCa229, sumIf(Ca2, Cb in L28) as sumCa229, minIf(Ca2, Cb in L28) as minCa229, maxIf(Ca2, Cb in L28) as maxCa229, anyIf(Ca2, Cb in L28) as anyCa229, avgIf(Ca3, Cb in L28) as avgCa329, sumIf(Ca3, Cb in L28) as sumCa329, minIf(Ca3, Cb in L28) as minCa329, maxIf(Ca3, Cb in L28) as maxCa329, anyIf(Ca3, Cb in L28) as anyCa329, avgIf(Ca1, Cb in L29) as avgCa130, sumIf(Ca1, Cb in L29) as sumCa130, minIf(Ca1, Cb in L29) as minCa130, maxIf(Ca1, Cb in L29) as maxCa130, anyIf(Ca1, Cb in L29) as anyCa130, avgIf(Ca2, Cb in L29) as avgCa230, sumIf(Ca2, Cb in L29) as sumCa230, minIf(Ca2, Cb in L29) as minCa230, maxIf(Ca2, Cb in L29) as maxCa230, anyIf(Ca2, Cb in L29) as anyCa230, avgIf(Ca3, Cb in L29) as avgCa330, sumIf(Ca3, Cb in L29) as sumCa330, minIf(Ca3, Cb in L29) as minCa330, maxIf(Ca3, Cb in L29) as maxCa330, anyIf(Ca3, Cb in L29) as anyCa330 from test.test_table where TIMESTAMP >= 1625796480 and TIMESTAMP < 1625796540 and Cc = 'eth0';

3. Run ResultSet rs = statement.executeQuery(query.toString(), paramMap, extDataList);
   I set a break point at ClickhouseStatementImpl.java line 776 HttpResponse response = client.execute(post, httpContext);, which is right before sending everything to the clickhouse server. The variables are shown below

parsedStmt.sql (The first line is the original sql and the second line is generated by clickhouse jdbc)

select avgIf(Ca1, Cb in L0) as avgCa11, sumIf(Ca1, Cb in L0) as sumCa11, minIf(Ca1, Cb in L0) as minCa11, maxIf(Ca1, Cb in L0) as maxCa11, anyIf(Ca1, Cb in L0) as anyCa11, avgIf(Ca2, Cb in L0) as avgCa21, sumIf(Ca2, Cb in L0) as sumCa21, minIf(Ca2, Cb in L0) as minCa21, maxIf(Ca2, Cb in L0) as maxCa21, anyIf(Ca2, Cb in L0) as anyCa21, avgIf(Ca3, Cb in L0) as avgCa31, sumIf(Ca3, Cb in L0) as sumCa31, minIf(Ca3, Cb in L0) as minCa31, maxIf(Ca3, Cb in L0) as maxCa31, anyIf(Ca3, Cb in L0) as anyCa31, avgIf(Ca1, Cb in L1) as avgCa12, sumIf(Ca1, Cb in L1) as sumCa12, minIf(Ca1, Cb in L1) as minCa12, maxIf(Ca1, Cb in L1) as maxCa12, anyIf(Ca1, Cb in L1) as anyCa12, avgIf(Ca2, Cb in L1) as avgCa22, sumIf(Ca2, Cb in L1) as sumCa22, minIf(Ca2, Cb in L1) as minCa22, maxIf(Ca2, Cb in L1) as maxCa22, anyIf(Ca2, Cb in L1) as anyCa22, avgIf(Ca3, Cb in L1) as avgCa32, sumIf(Ca3, Cb in L1) as sumCa32, minIf(Ca3, Cb in L1) as minCa32, maxIf(Ca3, Cb in L1) as maxCa32, anyIf(Ca3, Cb in L1) as anyCa32, avgIf(Ca1, Cb in L2) as avgCa13, sumIf(Ca1, Cb in L2) as sumCa13, minIf(Ca1, Cb in L2) as minCa13, maxIf(Ca1, Cb in L2) as maxCa13, anyIf(Ca1, Cb in L2) as anyCa13, avgIf(Ca2, Cb in L2) as avgCa23, sumIf(Ca2, Cb in L2) as sumCa23, minIf(Ca2, Cb in L2) as minCa23, maxIf(Ca2, Cb in L2) as maxCa23, anyIf(Ca2, Cb in L2) as anyCa23, avgIf(Ca3, Cb in L2) as avgCa33, sumIf(Ca3, Cb in L2) as sumCa33, minIf(Ca3, Cb in L2) as minCa33, maxIf(Ca3, Cb in L2) as maxCa33, anyIf(Ca3, Cb in L2) as anyCa33, avgIf(Ca1, Cb in L3) as avgCa14, sumIf(Ca1, Cb in L3) as sumCa14, minIf(Ca1, Cb in L3) as minCa14, maxIf(Ca1, Cb in L3) as maxCa14, anyIf(Ca1, Cb in L3) as anyCa14, avgIf(Ca2, Cb in L3) as avgCa24, sumIf(Ca2, Cb in L3) as sumCa24, minIf(Ca2, Cb in L3) as minCa24, maxIf(Ca2, Cb in L3) as maxCa24, anyIf(Ca2, Cb in L3) as anyCa24, avgIf(Ca3, Cb in L3) as avgCa34, sumIf(Ca3, Cb in L3) as sumCa34, minIf(Ca3, Cb in L3) as minCa34, maxIf(Ca3, Cb in L3) as maxCa34, anyIf(Ca3, Cb in L3) as anyCa34, avgIf(Ca1, Cb in L4) as avgCa15, sumIf(Ca1, Cb in L4) as sumCa15, minIf(Ca1, Cb in L4) as minCa15, maxIf(Ca1, Cb in L4) as maxCa15, anyIf(Ca1, Cb in L4) as anyCa15, avgIf(Ca2, Cb in L4) as avgCa25, sumIf(Ca2, Cb in L4) as sumCa25, minIf(Ca2, Cb in L4) as minCa25, maxIf(Ca2, Cb in L4) as maxCa25, anyIf(Ca2, Cb in L4) as anyCa25, avgIf(Ca3, Cb in L4) as avgCa35, sumIf(Ca3, Cb in L4) as sumCa35, minIf(Ca3, Cb in L4) as minCa35, maxIf(Ca3, Cb in L4) as maxCa35, anyIf(Ca3, Cb in L4) as anyCa35, avgIf(Ca1, Cb in L5) as avgCa16, sumIf(Ca1, Cb in L5) as sumCa16, minIf(Ca1, Cb in L5) as minCa16, maxIf(Ca1, Cb in L5) as maxCa16, anyIf(Ca1, Cb in L5) as anyCa16, avgIf(Ca2, Cb in L5) as avgCa26, sumIf(Ca2, Cb in L5) as sumCa26, minIf(Ca2, Cb in L5) as minCa26, maxIf(Ca2, Cb in L5) as maxCa26, anyIf(Ca2, Cb in L5) as anyCa26, avgIf(Ca3, Cb in L5) as avgCa36, sumIf(Ca3, Cb in L5) as sumCa36, minIf(Ca3, Cb in L5) as minCa36, maxIf(Ca3, Cb in L5) as maxCa36, anyIf(Ca3, Cb in L5) as anyCa36, avgIf(Ca1, Cb in L6) as avgCa17, sumIf(Ca1, Cb in L6) as sumCa17, minIf(Ca1, Cb in L6) as minCa17, maxIf(Ca1, Cb in L6) as maxCa17, anyIf(Ca1, Cb in L6) as anyCa17, avgIf(Ca2, Cb in L6) as avgCa27, sumIf(Ca2, Cb in L6) as sumCa27, minIf(Ca2, Cb in L6) as minCa27, maxIf(Ca2, Cb in L6) as maxCa27, anyIf(Ca2, Cb in L6) as anyCa27, avgIf(Ca3, Cb in L6) as avgCa37, sumIf(Ca3, Cb in L6) as sumCa37, minIf(Ca3, Cb in L6) as minCa37, maxIf(Ca3, Cb in L6) as maxCa37, anyIf(Ca3, Cb in L6) as anyCa37, avgIf(Ca1, Cb in L7) as avgCa18, sumIf(Ca1, Cb in L7) as sumCa18, minIf(Ca1, Cb in L7) as minCa18, maxIf(Ca1, Cb in L7) as maxCa18, anyIf(Ca1, Cb in L7) as anyCa18, avgIf(Ca2, Cb in L7) as avgCa28, sumIf(Ca2, Cb in L7) as sumCa28, minIf(Ca2, Cb in L7) as minCa28, maxIf(Ca2, Cb in L7) as maxCa28, anyIf(Ca2, Cb in L7) as anyCa28, avgIf(Ca3, Cb in L7) as avgCa38, sumIf(Ca3, Cb in L7) as sumCa38, minIf(Ca3, Cb in L7) as minCa38, maxIf(Ca3, Cb in L7) as maxCa38, anyIf(Ca3, Cb in L7) as anyCa38, avgIf(Ca1, Cb in L8) as avgCa19, sumIf(Ca1, Cb in L8) as sumCa19, minIf(Ca1, Cb in L8) as minCa19, maxIf(Ca1, Cb in L8) as maxCa19, anyIf(Ca1, Cb in L8) as anyCa19, avgIf(Ca2, Cb in L8) as avgCa29, sumIf(Ca2, Cb in L8) as sumCa29, minIf(Ca2, Cb in L8) as minCa29, maxIf(Ca2, Cb in L8) as maxCa29, anyIf(Ca2, Cb in L8) as anyCa29, avgIf(Ca3, Cb in L8) as avgCa39, sumIf(Ca3, Cb in L8) as sumCa39, minIf(Ca3, Cb in L8) as minCa39, maxIf(Ca3, Cb in L8) as maxCa39, anyIf(Ca3, Cb in L8) as anyCa39, avgIf(Ca1, Cb in L9) as avgCa110, sumIf(Ca1, Cb in L9) as sumCa110, minIf(Ca1, Cb in L9) as minCa110, maxIf(Ca1, Cb in L9) as maxCa110, anyIf(Ca1, Cb in L9) as anyCa110, avgIf(Ca2, Cb in L9) as avgCa210, sumIf(Ca2, Cb in L9) as sumCa210, minIf(Ca2, Cb in L9) as minCa210, maxIf(Ca2, Cb in L9) as maxCa210, anyIf(Ca2, Cb in L9) as anyCa210, avgIf(Ca3, Cb in L9) as avgCa310, sumIf(Ca3, Cb in L9) as sumCa310, minIf(Ca3, Cb in L9) as minCa310, maxIf(Ca3, Cb in L9) as maxCa310, anyIf(Ca3, Cb in L9) as anyCa310, avgIf(Ca1, Cb in L10) as avgCa111, sumIf(Ca1, Cb in L10) as sumCa111, minIf(Ca1, Cb in L10) as minCa111, maxIf(Ca1, Cb in L10) as maxCa111, anyIf(Ca1, Cb in L10) as anyCa111, avgIf(Ca2, Cb in L10) as avgCa211, sumIf(Ca2, Cb in L10) as sumCa211, minIf(Ca2, Cb in L10) as minCa211, maxIf(Ca2, Cb in L10) as maxCa211, anyIf(Ca2, Cb in L10) as anyCa211, avgIf(Ca3, Cb in L10) as avgCa311, sumIf(Ca3, Cb in L10) as sumCa311, minIf(Ca3, Cb in L10) as minCa311, maxIf(Ca3, Cb in L10) as maxCa311, anyIf(Ca3, Cb in L10) as anyCa311, avgIf(Ca1, Cb in L11) as avgCa112, sumIf(Ca1, Cb in L11) as sumCa112, minIf(Ca1, Cb in L11) as minCa112, maxIf(Ca1, Cb in L11) as maxCa112, anyIf(Ca1, Cb in L11) as anyCa112, avgIf(Ca2, Cb in L11) as avgCa212, sumIf(Ca2, Cb in L11) as sumCa212, minIf(Ca2, Cb in L11) as minCa212, maxIf(Ca2, Cb in L11) as maxCa212, anyIf(Ca2, Cb in L11) as anyCa212, avgIf(Ca3, Cb in L11) as avgCa312, sumIf(Ca3, Cb in L11) as sumCa312, minIf(Ca3, Cb in L11) as minCa312, maxIf(Ca3, Cb in L11) as maxCa312, anyIf(Ca3, Cb in L11) as anyCa312, avgIf(Ca1, Cb in L12) as avgCa113, sumIf(Ca1, Cb in L12) as sumCa113, minIf(Ca1, Cb in L12) as minCa113, maxIf(Ca1, Cb in L12) as maxCa113, anyIf(Ca1, Cb in L12) as anyCa113, avgIf(Ca2, Cb in L12) as avgCa213, sumIf(Ca2, Cb in L12) as sumCa213, minIf(Ca2, Cb in L12) as minCa213, maxIf(Ca2, Cb in L12) as maxCa213, anyIf(Ca2, Cb in L12) as anyCa213, avgIf(Ca3, Cb in L12) as avgCa313, sumIf(Ca3, Cb in L12) as sumCa313, minIf(Ca3, Cb in L12) as minCa313, maxIf(Ca3, Cb in L12) as maxCa313, anyIf(Ca3, Cb in L12) as anyCa313, avgIf(Ca1, Cb in L13) as avgCa114, sumIf(Ca1, Cb in L13) as sumCa114, minIf(Ca1, Cb in L13) as minCa114, maxIf(Ca1, Cb in L13) as maxCa114, anyIf(Ca1, Cb in L13) as anyCa114, avgIf(Ca2, Cb in L13) as avgCa214, sumIf(Ca2, Cb in L13) as sumCa214, minIf(Ca2, Cb in L13) as minCa214, maxIf(Ca2, Cb in L13) as maxCa214, anyIf(Ca2, Cb in L13) as anyCa214, avgIf(Ca3, Cb in L13) as avgCa314, sumIf(Ca3, Cb in L13) as sumCa314, minIf(Ca3, Cb in L13) as minCa314, maxIf(Ca3, Cb in L13) as maxCa314, anyIf(Ca3, Cb in L13) as anyCa314, avgIf(Ca1, Cb in L14) as avgCa115, sumIf(Ca1, Cb in L14) as sumCa115, minIf(Ca1, Cb in L14) as minCa115, maxIf(Ca1, Cb in L14) as maxCa115, anyIf(Ca1, Cb in L14) as anyCa115, avgIf(Ca2, Cb in L14) as avgCa215, sumIf(Ca2, Cb in L14) as sumCa215, minIf(Ca2, Cb in L14) as minCa215, maxIf(Ca2, Cb in L14) as maxCa215, anyIf(Ca2, Cb in L14) as anyCa215, avgIf(Ca3, Cb in L14) as avgCa315, sumIf(Ca3, Cb in L14) as sumCa315, minIf(Ca3, Cb in L14) as minCa315, maxIf(Ca3, Cb in L14) as maxCa315, anyIf(Ca3, Cb in L14) as anyCa315, avgIf(Ca1, Cb in L15) as avgCa116, sumIf(Ca1, Cb in L15) as sumCa116, minIf(Ca1, Cb in L15) as minCa116, maxIf(Ca1, Cb in L15) as maxCa116, anyIf(Ca1, Cb in L15) as anyCa116, avgIf(Ca2, Cb in L15) as avgCa216, sumIf(Ca2, Cb in L15) as sumCa216, minIf(Ca2, Cb in L15) as minCa216, maxIf(Ca2, Cb in L15) as maxCa216, anyIf(Ca2, Cb in L15) as anyCa216, avgIf(Ca3, Cb in L15) as avgCa316, sumIf(Ca3, Cb in L15) as sumCa316, minIf(Ca3, Cb in L15) as minCa316, maxIf(Ca3, Cb in L15) as maxCa316, anyIf(Ca3, Cb in L15) as anyCa316, avgIf(Ca1, Cb in L16) as avgCa117, sumIf(Ca1, Cb in L16) as sumCa117, minIf(Ca1, Cb in L16) as minCa117, maxIf(Ca1, Cb in L16) as maxCa117, anyIf(Ca1, Cb in L16) as anyCa117, avgIf(Ca2, Cb in L16) as avgCa217, sumIf(Ca2, Cb in L16) as sumCa217, minIf(Ca2, Cb in L16) as minCa217, maxIf(Ca2, Cb in L16) as maxCa217, anyIf(Ca2, Cb in L16) as anyCa217, avgIf(Ca3, Cb in L16) as avgCa317, sumIf(Ca3, Cb in L16) as sumCa317, minIf(Ca3, Cb in L16) as minCa317, maxIf(Ca3, Cb in L16) as maxCa317, anyIf(Ca3, Cb in L16) as anyCa317, avgIf(Ca1, Cb in L17) as avgCa118, sumIf(Ca1, Cb in L17) as sumCa118, minIf(Ca1, Cb in L17) as minCa118, maxIf(Ca1, Cb in L17) as maxCa118, anyIf(Ca1, Cb in L17) as anyCa118, avgIf(Ca2, Cb in L17) as avgCa218, sumIf(Ca2, Cb in L17) as sumCa218, minIf(Ca2, Cb in L17) as minCa218, maxIf(Ca2, Cb in L17) as maxCa218, anyIf(Ca2, Cb in L17) as anyCa218, avgIf(Ca3, Cb in L17) as avgCa318, sumIf(Ca3, Cb in L17) as sumCa318, minIf(Ca3, Cb in L17) as minCa318, maxIf(Ca3, Cb in L17) as maxCa318, anyIf(Ca3, Cb in L17) as anyCa318, avgIf(Ca1, Cb in L18) as avgCa119, sumIf(Ca1, Cb in L18) as sumCa119, minIf(Ca1, Cb in L18) as minCa119, maxIf(Ca1, Cb in L18) as maxCa119, anyIf(Ca1, Cb in L18) as anyCa119, avgIf(Ca2, Cb in L18) as avgCa219, sumIf(Ca2, Cb in L18) as sumCa219, minIf(Ca2, Cb in L18) as minCa219, maxIf(Ca2, Cb in L18) as maxCa219, anyIf(Ca2, Cb in L18) as anyCa219, avgIf(Ca3, Cb in L18) as avgCa319, sumIf(Ca3, Cb in L18) as sumCa319, minIf(Ca3, Cb in L18) as minCa319, maxIf(Ca3, Cb in L18) as maxCa319, anyIf(Ca3, Cb in L18) as anyCa319, avgIf(Ca1, Cb in L19) as avgCa120, sumIf(Ca1, Cb in L19) as sumCa120, minIf(Ca1, Cb in L19) as minCa120, maxIf(Ca1, Cb in L19) as maxCa120, anyIf(Ca1, Cb in L19) as anyCa120, avgIf(Ca2, Cb in L19) as avgCa220, sumIf(Ca2, Cb in L19) as sumCa220, minIf(Ca2, Cb in L19) as minCa220, maxIf(Ca2, Cb in L19) as maxCa220, anyIf(Ca2, Cb in L19) as anyCa220, avgIf(Ca3, Cb in L19) as avgCa320, sumIf(Ca3, Cb in L19) as sumCa320, minIf(Ca3, Cb in L19) as minCa320, maxIf(Ca3, Cb in L19) as maxCa320, anyIf(Ca3, Cb in L19) as anyCa320, avgIf(Ca1, Cb in L20) as avgCa121, sumIf(Ca1, Cb in L20) as sumCa121, minIf(Ca1, Cb in L20) as minCa121, maxIf(Ca1, Cb in L20) as maxCa121, anyIf(Ca1, Cb in L20) as anyCa121, avgIf(Ca2, Cb in L20) as avgCa221, sumIf(Ca2, Cb in L20) as sumCa221, minIf(Ca2, Cb in L20) as minCa221, maxIf(Ca2, Cb in L20) as maxCa221, anyIf(Ca2, Cb in L20) as anyCa221, avgIf(Ca3, Cb in L20) as avgCa321, sumIf(Ca3, Cb in L20) as sumCa321, minIf(Ca3, Cb in L20) as minCa321, maxIf(Ca3, Cb in L20) as maxCa321, anyIf(Ca3, Cb in L20) as anyCa321, avgIf(Ca1, Cb in L21) as avgCa122, sumIf(Ca1, Cb in L21) as sumCa122, minIf(Ca1, Cb in L21) as minCa122, maxIf(Ca1, Cb in L21) as maxCa122, anyIf(Ca1, Cb in L21) as anyCa122, avgIf(Ca2, Cb in L21) as avgCa222, sumIf(Ca2, Cb in L21) as sumCa222, minIf(Ca2, Cb in L21) as minCa222, maxIf(Ca2, Cb in L21) as maxCa222, anyIf(Ca2, Cb in L21) as anyCa222, avgIf(Ca3, Cb in L21) as avgCa322, sumIf(Ca3, Cb in L21) as sumCa322, minIf(Ca3, Cb in L21) as minCa322, maxIf(Ca3, Cb in L21) as maxCa322, anyIf(Ca3, Cb in L21) as anyCa322, avgIf(Ca1, Cb in L22) as avgCa123, sumIf(Ca1, Cb in L22) as sumCa123, minIf(Ca1, Cb in L22) as minCa123, maxIf(Ca1, Cb in L22) as maxCa123, anyIf(Ca1, Cb in L22) as anyCa123, avgIf(Ca2, Cb in L22) as avgCa223, sumIf(Ca2, Cb in L22) as sumCa223, minIf(Ca2, Cb in L22) as minCa223, maxIf(Ca2, Cb in L22) as maxCa223, anyIf(Ca2, Cb in L22) as anyCa223, avgIf(Ca3, Cb in L22) as avgCa323, sumIf(Ca3, Cb in L22) as sumCa323, minIf(Ca3, Cb in L22) as minCa323, maxIf(Ca3, Cb in L22) as maxCa323, anyIf(Ca3, Cb in L22) as anyCa323, avgIf(Ca1, Cb in L23) as avgCa124, sumIf(Ca1, Cb in L23) as sumCa124, minIf(Ca1, Cb in L23) as minCa124, maxIf(Ca1, Cb in L23) as maxCa124, anyIf(Ca1, Cb in L23) as anyCa124, avgIf(Ca2, Cb in L23) as avgCa224, sumIf(Ca2, Cb in L23) as sumCa224, minIf(Ca2, Cb in L23) as minCa224, maxIf(Ca2, Cb in L23) as maxCa224, anyIf(Ca2, Cb in L23) as anyCa224, avgIf(Ca3, Cb in L23) as avgCa324, sumIf(Ca3, Cb in L23) as sumCa324, minIf(Ca3, Cb in L23) as minCa324, maxIf(Ca3, Cb in L23) as maxCa324, anyIf(Ca3, Cb in L23) as anyCa324, avgIf(Ca1, Cb in L24) as avgCa125, sumIf(Ca1, Cb in L24) as sumCa125, minIf(Ca1, Cb in L24) as minCa125, maxIf(Ca1, Cb in L24) as maxCa125, anyIf(Ca1, Cb in L24) as anyCa125, avgIf(Ca2, Cb in L24) as avgCa225, sumIf(Ca2, Cb in L24) as sumCa225, minIf(Ca2, Cb in L24) as minCa225, maxIf(Ca2, Cb in L24) as maxCa225, anyIf(Ca2, Cb in L24) as anyCa225, avgIf(Ca3, Cb in L24) as avgCa325, sumIf(Ca3, Cb in L24) as sumCa325, minIf(Ca3, Cb in L24) as minCa325, maxIf(Ca3, Cb in L24) as maxCa325, anyIf(Ca3, Cb in L24) as anyCa325, avgIf(Ca1, Cb in L25) as avgCa126, sumIf(Ca1, Cb in L25) as sumCa126, minIf(Ca1, Cb in L25) as minCa126, maxIf(Ca1, Cb in L25) as maxCa126, anyIf(Ca1, Cb in L25) as anyCa126, avgIf(Ca2, Cb in L25) as avgCa226, sumIf(Ca2, Cb in L25) as sumCa226, minIf(Ca2, Cb in L25) as minCa226, maxIf(Ca2, Cb in L25) as maxCa226, anyIf(Ca2, Cb in L25) as anyCa226, avgIf(Ca3, Cb in L25) as avgCa326, sumIf(Ca3, Cb in L25) as sumCa326, minIf(Ca3, Cb in L25) as minCa326, maxIf(Ca3, Cb in L25) as maxCa326, anyIf(Ca3, Cb in L25) as anyCa326, avgIf(Ca1, Cb in L26) as avgCa127, sumIf(Ca1, Cb in L26) as sumCa127, minIf(Ca1, Cb in L26) as minCa127, maxIf(Ca1, Cb in L26) as maxCa127, anyIf(Ca1, Cb in L26) as anyCa127, avgIf(Ca2, Cb in L26) as avgCa227, sumIf(Ca2, Cb in L26) as sumCa227, minIf(Ca2, Cb in L26) as minCa227, maxIf(Ca2, Cb in L26) as maxCa227, anyIf(Ca2, Cb in L26) as anyCa227, avgIf(Ca3, Cb in L26) as avgCa327, sumIf(Ca3, Cb in L26) as sumCa327, minIf(Ca3, Cb in L26) as minCa327, maxIf(Ca3, Cb in L26) as maxCa327, anyIf(Ca3, Cb in L26) as anyCa327, avgIf(Ca1, Cb in L27) as avgCa128, sumIf(Ca1, Cb in L27) as sumCa128, minIf(Ca1, Cb in L27) as minCa128, maxIf(Ca1, Cb in L27) as maxCa128, anyIf(Ca1, Cb in L27) as anyCa128, avgIf(Ca2, Cb in L27) as avgCa228, sumIf(Ca2, Cb in L27) as sumCa228, minIf(Ca2, Cb in L27) as minCa228, maxIf(Ca2, Cb in L27) as maxCa228, anyIf(Ca2, Cb in L27) as anyCa228, avgIf(Ca3, Cb in L27) as avgCa328, sumIf(Ca3, Cb in L27) as sumCa328, minIf(Ca3, Cb in L27) as minCa328, maxIf(Ca3, Cb in L27) as maxCa328, anyIf(Ca3, Cb in L27) as anyCa328, avgIf(Ca1, Cb in L28) as avgCa129, sumIf(Ca1, Cb in L28) as sumCa129, minIf(Ca1, Cb in L28) as minCa129, maxIf(Ca1, Cb in L28) as maxCa129, anyIf(Ca1, Cb in L28) as anyCa129, avgIf(Ca2, Cb in L28) as avgCa229, sumIf(Ca2, Cb in L28) as sumCa229, minIf(Ca2, Cb in L28) as minCa229, maxIf(Ca2, Cb in L28) as maxCa229, anyIf(Ca2, Cb in L28) as anyCa229, avgIf(Ca3, Cb in L28) as avgCa329, sumIf(Ca3, Cb in L28) as sumCa329, minIf(Ca3, Cb in L28) as minCa329, maxIf(Ca3, Cb in L28) as maxCa329, anyIf(Ca3, Cb in L28) as anyCa329, avgIf(Ca1, Cb in L29) as avgCa130, sumIf(Ca1, Cb in L29) as sumCa130, minIf(Ca1, Cb in L29) as minCa130, maxIf(Ca1, Cb in L29) as maxCa130, anyIf(Ca1, Cb in L29) as anyCa130, avgIf(Ca2, Cb in L29) as avgCa230, sumIf(Ca2, Cb in L29) as sumCa230, minIf(Ca2, Cb in L29) as minCa230, maxIf(Ca2, Cb in L29) as maxCa230, anyIf(Ca2, Cb in L29) as anyCa230, avgIf(Ca3, Cb in L29) as avgCa330, sumIf(Ca3, Cb in L29) as sumCa330, minIf(Ca3, Cb in L29) as minCa330, maxIf(Ca3, Cb in L29) as maxCa330, anyIf(Ca3, Cb in L29) as anyCa330 from test.test_table where TIMESTAMP >= 1625796480 and TIMESTAMP < 1625796540 and Cc = 'eth0'
FORMAT TabSeparatedWithNamesAndTypes

uri

http://{ip}:{port}/?L0_structure=Cb+String&L1_structure=Cb+String&L2_structure=Cb+String&L3_structure=Cb+String&L4_structure=Cb+String&L5_structure=Cb+String&L6_structure=Cb+String&L7_structure=Cb+String&L8_structure=Cb+String&L9_structure=Cb+String&L10_structure=Cb+String&L11_structure=Cb+String&L12_structure=Cb+String&L13_structure=Cb+String&L14_structure=Cb+String&L15_structure=Cb+String&L16_structure=Cb+String&L17_structure=Cb+String&L18_structure=Cb+String&L19_structure=Cb+String&L20_structure=Cb+String&L21_structure=Cb+String&L22_structure=Cb+String&L23_structure=Cb+String&L24_structure=Cb+String&L25_structure=Cb+String&L26_structure=Cb+String&L27_structure=Cb+String&L28_structure=Cb+String&L29_structure=Cb+String&compress=1&database=test&max_ast_elements=9223372036854775807&query_id={query_id}&max_query_size=104857600&priority=2&extremes=0

4. Receive exception from the clickhouse server. Try execute it few times if no exception is thrown.

Java side exception

Caused by: java.lang.Throwable: Code: 62, e.displayText() = DB::Exception: Syntax error: failed at position {position} ('gCa321') (line 2, col 1):

Parsed sql stored in system.query_log, the first line is still the original sql

select avgIf(Ca1, Cb in L0) as avgCa11, sumIf(Ca1, Cb in L0) as sumCa11, minIf(Ca1, Cb in L0) as minCa11, maxIf(Ca1, Cb in L0) as maxCa11, anyIf(Ca1, Cb in L0) as anyCa11, avgIf(Ca2, Cb in L0) as avgCa21, sumIf(Ca2, Cb in L0) as sumCa21, minIf(Ca2, Cb in L0) as minCa21, maxIf(Ca2, Cb in L0) as maxCa21, anyIf(Ca2, Cb in L0) as anyCa21, avgIf(Ca3, Cb in L0) as avgCa31, sumIf(Ca3, Cb in L0) as sumCa31, minIf(Ca3, Cb in L0) as minCa31, maxIf(Ca3, Cb in L0) as maxCa31, anyIf(Ca3, Cb in L0) as anyCa31, avgIf(Ca1, Cb in L1) as avgCa12, sumIf(Ca1, Cb in L1) as sumCa12, minIf(Ca1, Cb in L1) as minCa12, maxIf(Ca1, Cb in L1) as maxCa12, anyIf(Ca1, Cb in L1) as anyCa12, avgIf(Ca2, Cb in L1) as avgCa22, sumIf(Ca2, Cb in L1) as sumCa22, minIf(Ca2, Cb in L1) as minCa22, maxIf(Ca2, Cb in L1) as maxCa22, anyIf(Ca2, Cb in L1) as anyCa22, avgIf(Ca3, Cb in L1) as avgCa32, sumIf(Ca3, Cb in L1) as sumCa32, minIf(Ca3, Cb in L1) as minCa32, maxIf(Ca3, Cb in L1) as maxCa32, anyIf(Ca3, Cb in L1) as anyCa32, avgIf(Ca1, Cb in L2) as avgCa13, sumIf(Ca1, Cb in L2) as sumCa13, minIf(Ca1, Cb in L2) as minCa13, maxIf(Ca1, Cb in L2) as maxCa13, anyIf(Ca1, Cb in L2) as anyCa13, avgIf(Ca2, Cb in L2) as avgCa23, sumIf(Ca2, Cb in L2) as sumCa23, minIf(Ca2, Cb in L2) as minCa23, maxIf(Ca2, Cb in L2) as maxCa23, anyIf(Ca2, Cb in L2) as anyCa23, avgIf(Ca3, Cb in L2) as avgCa33, sumIf(Ca3, Cb in L2) as sumCa33, minIf(Ca3, Cb in L2) as minCa33, maxIf(Ca3, Cb in L2) as maxCa33, anyIf(Ca3, Cb in L2) as anyCa33, avgIf(Ca1, Cb in L3) as avgCa14, sumIf(Ca1, Cb in L3) as sumCa14, minIf(Ca1, Cb in L3) as minCa14, maxIf(Ca1, Cb in L3) as maxCa14, anyIf(Ca1, Cb in L3) as anyCa14, avgIf(Ca2, Cb in L3) as avgCa24, sumIf(Ca2, Cb in L3) as sumCa24, minIf(Ca2, Cb in L3) as minCa24, maxIf(Ca2, Cb in L3) as maxCa24, anyIf(Ca2, Cb in L3) as anyCa24, avgIf(Ca3, Cb in L3) as avgCa34, sumIf(Ca3, Cb in L3) as sumCa34, minIf(Ca3, Cb in L3) as minCa34, maxIf(Ca3, Cb in L3) as maxCa34, anyIf(Ca3, Cb in L3) as anyCa34, avgIf(Ca1, Cb in L4) as avgCa15, sumIf(Ca1, Cb in L4) as sumCa15, minIf(Ca1, Cb in L4) as minCa15, maxIf(Ca1, Cb in L4) as maxCa15, anyIf(Ca1, Cb in L4) as anyCa15, avgIf(Ca2, Cb in L4) as avgCa25, sumIf(Ca2, Cb in L4) as sumCa25, minIf(Ca2, Cb in L4) as minCa25, maxIf(Ca2, Cb in L4) as maxCa25, anyIf(Ca2, Cb in L4) as anyCa25, avgIf(Ca3, Cb in L4) as avgCa35, sumIf(Ca3, Cb in L4) as sumCa35, minIf(Ca3, Cb in L4) as minCa35, maxIf(Ca3, Cb in L4) as maxCa35, anyIf(Ca3, Cb in L4) as anyCa35, avgIf(Ca1, Cb in L5) as avgCa16, sumIf(Ca1, Cb in L5) as sumCa16, minIf(Ca1, Cb in L5) as minCa16, maxIf(Ca1, Cb in L5) as maxCa16, anyIf(Ca1, Cb in L5) as anyCa16, avgIf(Ca2, Cb in L5) as avgCa26, sumIf(Ca2, Cb in L5) as sumCa26, minIf(Ca2, Cb in L5) as minCa26, maxIf(Ca2, Cb in L5) as maxCa26, anyIf(Ca2, Cb in L5) as anyCa26, avgIf(Ca3, Cb in L5) as avgCa36, sumIf(Ca3, Cb in L5) as sumCa36, minIf(Ca3, Cb in L5) as minCa36, maxIf(Ca3, Cb in L5) as maxCa36, anyIf(Ca3, Cb in L5) as anyCa36, avgIf(Ca1, Cb in L6) as avgCa17, sumIf(Ca1, Cb in L6) as sumCa17, minIf(Ca1, Cb in L6) as minCa17, maxIf(Ca1, Cb in L6) as maxCa17, anyIf(Ca1, Cb in L6) as anyCa17, avgIf(Ca2, Cb in L6) as avgCa27, sumIf(Ca2, Cb in L6) as sumCa27, minIf(Ca2, Cb in L6) as minCa27, maxIf(Ca2, Cb in L6) as maxCa27, anyIf(Ca2, Cb in L6) as anyCa27, avgIf(Ca3, Cb in L6) as avgCa37, sumIf(Ca3, Cb in L6) as sumCa37, minIf(Ca3, Cb in L6) as minCa37, maxIf(Ca3, Cb in L6) as maxCa37, anyIf(Ca3, Cb in L6) as anyCa37, avgIf(Ca1, Cb in L7) as avgCa18, sumIf(Ca1, Cb in L7) as sumCa18, minIf(Ca1, Cb in L7) as minCa18, maxIf(Ca1, Cb in L7) as maxCa18, anyIf(Ca1, Cb in L7) as anyCa18, avgIf(Ca2, Cb in L7) as avgCa28, sumIf(Ca2, Cb in L7) as sumCa28, minIf(Ca2, Cb in L7) as minCa28, maxIf(Ca2, Cb in L7) as maxCa28, anyIf(Ca2, Cb in L7) as anyCa28, avgIf(Ca3, Cb in L7) as avgCa38, sumIf(Ca3, Cb in L7) as sumCa38, minIf(Ca3, Cb in L7) as minCa38, maxIf(Ca3, Cb in L7) as maxCa38, anyIf(Ca3, Cb in L7) as anyCa38, avgIf(Ca1, Cb in L8) as avgCa19, sumIf(Ca1, Cb in L8) as sumCa19, minIf(Ca1, Cb in L8) as minCa19, maxIf(Ca1, Cb in L8) as maxCa19, anyIf(Ca1, Cb in L8) as anyCa19, avgIf(Ca2, Cb in L8) as avgCa29, sumIf(Ca2, Cb in L8) as sumCa29, minIf(Ca2, Cb in L8) as minCa29, maxIf(Ca2, Cb in L8) as maxCa29, anyIf(Ca2, Cb in L8) as anyCa29, avgIf(Ca3, Cb in L8) as avgCa39, sumIf(Ca3, Cb in L8) as sumCa39, minIf(Ca3, Cb in L8) as minCa39, maxIf(Ca3, Cb in L8) as maxCa39, anyIf(Ca3, Cb in L8) as anyCa39, avgIf(Ca1, Cb in L9) as avgCa110, sumIf(Ca1, Cb in L9) as sumCa110, minIf(Ca1, Cb in L9) as minCa110, maxIf(Ca1, Cb in L9) as maxCa110, anyIf(Ca1, Cb in L9) as anyCa110, avgIf(Ca2, Cb in L9) as avgCa210, sumIf(Ca2, Cb in L9) as sumCa210, minIf(Ca2, Cb in L9) as minCa210, maxIf(Ca2, Cb in L9) as maxCa210, anyIf(Ca2, Cb in L9) as anyCa210, avgIf(Ca3, Cb in L9) as avgCa310, sumIf(Ca3, Cb in L9) as sumCa310, minIf(Ca3, Cb in L9) as minCa310, maxIf(Ca3, Cb in L9) as maxCa310, anyIf(Ca3, Cb in L9) as anyCa310, avgIf(Ca1, Cb in L10) as avgCa111, sumIf(Ca1, Cb in L10) as sumCa111, minIf(Ca1, Cb in L10) as minCa111, maxIf(Ca1, Cb in L10) as maxCa111, anyIf(Ca1, Cb in L10) as anyCa111, avgIf(Ca2, Cb in L10) as avgCa211, sumIf(Ca2, Cb in L10) as sumCa211, minIf(Ca2, Cb in L10) as minCa211, maxIf(Ca2, Cb in L10) as maxCa211, anyIf(Ca2, Cb in L10) as anyCa211, avgIf(Ca3, Cb in L10) as avgCa311, sumIf(Ca3, Cb in L10) as sumCa311, minIf(Ca3, Cb in L10) as minCa311, maxIf(Ca3, Cb in L10) as maxCa311, anyIf(Ca3, Cb in L10) as anyCa311, avgIf(Ca1, Cb in L11) as avgCa112, sumIf(Ca1, Cb in L11) as sumCa112, minIf(Ca1, Cb in L11) as minCa112, maxIf(Ca1, Cb in L11) as maxCa112, anyIf(Ca1, Cb in L11) as anyCa112, avgIf(Ca2, Cb in L11) as avgCa212, sumIf(Ca2, Cb in L11) as sumCa212, minIf(Ca2, Cb in L11) as minCa212, maxIf(Ca2, Cb in L11) as maxCa212, anyIf(Ca2, Cb in L11) as anyCa212, avgIf(Ca3, Cb in L11) as avgCa312, sumIf(Ca3, Cb in L11) as sumCa312, minIf(Ca3, Cb in L11) as minCa312, maxIf(Ca3, Cb in L11) as maxCa312, anyIf(Ca3, Cb in L11) as anyCa312, avgIf(Ca1, Cb in L12) as avgCa113, sumIf(Ca1, Cb in L12) as sumCa113, minIf(Ca1, Cb in L12) as minCa113, maxIf(Ca1, Cb in L12) as maxCa113, anyIf(Ca1, Cb in L12) as anyCa113, avgIf(Ca2, Cb in L12) as avgCa213, sumIf(Ca2, Cb in L12) as sumCa213, minIf(Ca2, Cb in L12) as minCa213, maxIf(Ca2, Cb in L12) as maxCa213, anyIf(Ca2, Cb in L12) as anyCa213, avgIf(Ca3, Cb in L12) as avgCa313, sumIf(Ca3, Cb in L12) as sumCa313, minIf(Ca3, Cb in L12) as minCa313, maxIf(Ca3, Cb in L12) as maxCa313, anyIf(Ca3, Cb in L12) as anyCa313, avgIf(Ca1, Cb in L13) as avgCa114, sumIf(Ca1, Cb in L13) as sumCa114, minIf(Ca1, Cb in L13) as minCa114, maxIf(Ca1, Cb in L13) as maxCa114, anyIf(Ca1, Cb in L13) as anyCa114, avgIf(Ca2, Cb in L13) as avgCa214, sumIf(Ca2, Cb in L13) as sumCa214, minIf(Ca2, Cb in L13) as minCa214, maxIf(Ca2, Cb in L13) as maxCa214, anyIf(Ca2, Cb in L13) as anyCa214, avgIf(Ca3, Cb in L13) as avgCa314, sumIf(Ca3, Cb in L13) as sumCa314, minIf(Ca3, Cb in L13) as minCa314, maxIf(Ca3, Cb in L13) as maxCa314, anyIf(Ca3, Cb in L13) as anyCa314, avgIf(Ca1, Cb in L14) as avgCa115, sumIf(Ca1, Cb in L14) as sumCa115, minIf(Ca1, Cb in L14) as minCa115, maxIf(Ca1, Cb in L14) as maxCa115, anyIf(Ca1, Cb in L14) as anyCa115, avgIf(Ca2, Cb in L14) as avgCa215, sumIf(Ca2, Cb in L14) as sumCa215, minIf(Ca2, Cb in L14) as minCa215, maxIf(Ca2, Cb in L14) as maxCa215, anyIf(Ca2, Cb in L14) as anyCa215, avgIf(Ca3, Cb in L14) as avgCa315, sumIf(Ca3, Cb in L14) as sumCa315, minIf(Ca3, Cb in L14) as minCa315, maxIf(Ca3, Cb in L14) as maxCa315, anyIf(Ca3, Cb in L14) as anyCa315, avgIf(Ca1, Cb in L15) as avgCa116, sumIf(Ca1, Cb in L15) as sumCa116, minIf(Ca1, Cb in L15) as minCa116, maxIf(Ca1, Cb in L15) as maxCa116, anyIf(Ca1, Cb in L15) as anyCa116, avgIf(Ca2, Cb in L15) as avgCa216, sumIf(Ca2, Cb in L15) as sumCa216, minIf(Ca2, Cb in L15) as minCa216, maxIf(Ca2, Cb in L15) as maxCa216, anyIf(Ca2, Cb in L15) as anyCa216, avgIf(Ca3, Cb in L15) as avgCa316, sumIf(Ca3, Cb in L15) as sumCa316, minIf(Ca3, Cb in L15) as minCa316, maxIf(Ca3, Cb in L15) as maxCa316, anyIf(Ca3, Cb in L15) as anyCa316, avgIf(Ca1, Cb in L16) as avgCa117, sumIf(Ca1, Cb in L16) as sumCa117, minIf(Ca1, Cb in L16) as minCa117, maxIf(Ca1, Cb in L16) as maxCa117, anyIf(Ca1, Cb in L16) as anyCa117, avgIf(Ca2, Cb in L16) as avgCa217, sumIf(Ca2, Cb in L16) as sumCa217, minIf(Ca2, Cb in L16) as minCa217, maxIf(Ca2, Cb in L16) as maxCa217, anyIf(Ca2, Cb in L16) as anyCa217, avgIf(Ca3, Cb in L16) as avgCa317, sumIf(Ca3, Cb in L16) as sumCa317, minIf(Ca3, Cb in L16) as minCa317, maxIf(Ca3, Cb in L16) as maxCa317, anyIf(Ca3, Cb in L16) as anyCa317, avgIf(Ca1, Cb in L17) as avgCa118, sumIf(Ca1, Cb in L17) as sumCa118, minIf(Ca1, Cb in L17) as minCa118, maxIf(Ca1, Cb in L17) as maxCa118, anyIf(Ca1, Cb in L17) as anyCa118, avgIf(Ca2, Cb in L17) as avgCa218, sumIf(Ca2, Cb in L17) as sumCa218, minIf(Ca2, Cb in L17) as minCa218, maxIf(Ca2, Cb in L17) as maxCa218, anyIf(Ca2, Cb in L17) as anyCa218, avgIf(Ca3, Cb in L17) as avgCa318, sumIf(Ca3, Cb in L17) as sumCa318, minIf(Ca3, Cb in L17) as minCa318, maxIf(Ca3, Cb in L17) as maxCa318, anyIf(Ca3, Cb in L17) as anyCa318, avgIf(Ca1, Cb in L18) as avgCa119, sumIf(Ca1, Cb in L18) as sumCa119, minIf(Ca1, Cb in L18) as minCa119, maxIf(Ca1, Cb in L18) as maxCa119, anyIf(Ca1, Cb in L18) as anyCa119, avgIf(Ca2, Cb in L18) as avgCa219, sumIf(Ca2, Cb in L18) as sumCa219, minIf(Ca2, Cb in L18) as minCa219, maxIf(Ca2, Cb in L18) as maxCa219, anyIf(Ca2, Cb in L18) as anyCa219, avgIf(Ca3, Cb in L18) as avgCa319, sumIf(Ca3, Cb in L18) as sumCa319, minIf(Ca3, Cb in L18) as minCa319, maxIf(Ca3, Cb in L18) as maxCa319, anyIf(Ca3, Cb in L18) as anyCa319, avgIf(Ca1, Cb in L19) as avgCa120, sumIf(Ca1, Cb in L19) as sumCa120, minIf(Ca1, Cb in L19) as minCa120, maxIf(Ca1, Cb in L19) as maxCa120, anyIf(Ca1, Cb in L19) as anyCa120, avgIf(Ca2, Cb in L19) as avgCa220, sumIf(Ca2, Cb in L19) as sumCa220, minIf(Ca2, Cb in L19) as minCa220, maxIf(Ca2, Cb in L19) as maxCa220, anyIf(Ca2, Cb in L19) as anyCa220, avgIf(Ca3, Cb in L19) as avgCa320, sumIf(Ca3, Cb in L19) as sumCa320, minIf(Ca3, Cb in L19) as minCa320, maxIf(Ca3, Cb in L19) as maxCa320, anyIf(Ca3, Cb in L19) as anyCa320, avgIf(Ca1, Cb in L20) as avgCa121, sumIf(Ca1, Cb in L20) as sumCa121, minIf(Ca1, Cb in L20) as minCa121, maxIf(Ca1, Cb in L20) as maxCa121, anyIf(Ca1, Cb in L20) as anyCa121, avgIf(Ca2, Cb in L20) as avgCa221, sumIf(Ca2, Cb in L20) as sumCa221, minIf(Ca2, Cb in L20) as minCa221, maxIf(Ca2, Cb in L20) as maxCa221, anyIf(Ca2, Cb in L20) as anyCa221, avgIf(Ca3, Cb in L20) as avgCa321, sumIf(Ca3, Cb in L20) as sumCa321, minIf(Ca3, Cb in L20) as minCa321, maxIf(Ca3, Cb in L20) as maxCa321, anyIf(Ca3, Cb in L20) as anyCa321, avgIf(Ca1, Cb in L21) as avgCa122, sumIf(Ca1, Cb in L21) as sumCa122, minIf(Ca1, Cb in L21) as minCa122, maxIf(Ca1, Cb in L21) as maxCa122, anyIf(Ca1, Cb in L21) as anyCa122, avgIf(Ca2, Cb in L21) as avgCa222, sumIf(Ca2, Cb in L21) as sumCa222, minIf(Ca2, Cb in L21) as minCa222, maxIf(Ca2, Cb in L21) as maxCa222, anyIf(Ca2, Cb in L21) as anyCa222, avgIf(Ca3, Cb in L21) as avgCa322, sumIf(Ca3, Cb in L21) as sumCa322, minIf(Ca3, Cb in L21) as minCa322, maxIf(Ca3, Cb in L21) as maxCa322, anyIf(Ca3, Cb in L21) as anyCa322, avgIf(Ca1, Cb in L22) as avgCa123, sumIf(Ca1, Cb in L22) as sumCa123, minIf(Ca1, Cb in L22) as minCa123, maxIf(Ca1, Cb in L22) as maxCa123, anyIf(Ca1, Cb in L22) as anyCa123, avgIf(Ca2, Cb in L22) as avgCa223, sumIf(Ca2, Cb in L22) as sumCa223, minIf(Ca2, Cb in L22) as minCa223, maxIf(Ca2, Cb in L22) as maxCa223, anyIf(Ca2, Cb in L22) as anyCa223, avgIf(Ca3, Cb in L22) as avgCa323, sumIf(Ca3, Cb in L22) as sumCa323, minIf(Ca3, Cb in L22) as minCa323, maxIf(Ca3, Cb in L22) as maxCa323, anyIf(Ca3, Cb in L22) as anyCa323, avgIf(Ca1, Cb in L23) as avgCa124, sumIf(Ca1, Cb in L23) as sumCa124, minIf(Ca1, Cb in L23) as minCa124, maxIf(Ca1, Cb in L23) as maxCa124, anyIf(Ca1, Cb in L23) as anyCa124, avgIf(Ca2, Cb in L23) as avgCa224, sumIf(Ca2, Cb in L23) as sumCa224, minIf(Ca2, Cb in L23) as minCa224, maxIf(Ca2, Cb in L23) as maxCa224, anyIf(Ca2, Cb in L23) as anyCa224, avgIf(Ca3, Cb in L23) as avgCa324, sumIf(Ca3, Cb in L23) as sumCa324, minIf(Ca3, Cb in L23) as minCa324, maxIf(Ca3, Cb in L23) as maxCa324, anyIf(Ca3, Cb in L23) as anyCa324, avgIf(Ca1, Cb in L24) as avgCa125, sumIf(Ca1, Cb in L24) as sumCa125, minIf(Ca1, Cb in L24) as minCa125, maxIf(Ca1, Cb in L24) as maxCa125, anyIf(Ca1, Cb in L24) as anyCa125, avgIf(Ca2, Cb in L24) as avgCa225, sumIf(Ca2, Cb in L24) as sumCa225, minIf(Ca2, Cb in L24) as minCa225, maxIf(Ca2, Cb in L24) as maxCa225, anyIf(Ca2, Cb in L24) as anyCa225, avgIf(Ca3, Cb in L24) as avgCa325, sumIf(Ca3, Cb in L24) as sumCa325, minIf(Ca3, Cb in L24) as minCa325, maxIf(Ca3, Cb in L24) as maxCa325, anyIf(Ca3, Cb in L24) as anyCa325, avgIf(Ca1, Cb in L25) as avgCa126, sumIf(Ca1, Cb in L25) as sumCa126, minIf(Ca1, Cb in L25) as minCa126, maxIf(Ca1, Cb in L25) as maxCa126, anyIf(Ca1, Cb in L25) as anyCa126, avgIf(Ca2, Cb in L25) as avgCa226, sumIf(Ca2, Cb in L25) as sumCa226, minIf(Ca2, Cb in L25) as minCa226, maxIf(Ca2, Cb in L25) as maxCa226, anyIf(Ca2, Cb in L25) as anyCa226, avgIf(Ca3, Cb in L25) as avgCa326, sumIf(Ca3, Cb in L25) as sumCa326, minIf(Ca3, Cb in L25) as minCa326, maxIf(Ca3, Cb in L25) as maxCa326, anyIf(Ca3, Cb in L25) as anyCa326, avgIf(Ca1, Cb in L26) as avgCa127, sumIf(Ca1, Cb in L26) as sumCa127, minIf(Ca1, Cb in L26) as minCa127, maxIf(Ca1, Cb in L26) as maxCa127, anyIf(Ca1, Cb in L26) as anyCa127, avgIf(Ca2, Cb in L26) as avgCa227, sumIf(Ca2, Cb in L26) as sumCa227, minIf(Ca2, Cb in L26) as minCa227, maxIf(Ca2, Cb in L26) as maxCa227, anyIf(Ca2, Cb in L26) as anyCa227, avgIf(Ca3, Cb in L26) as avgCa327, sumIf(Ca3, Cb in L26) as sumCa327, minIf(Ca3, Cb in L26) as minCa327, maxIf(Ca3, Cb in L26) as maxCa327, anyIf(Ca3, Cb in L26) as anyCa327, avgIf(Ca1, Cb in L27) as avgCa128, sumIf(Ca1, Cb in L27) as sumCa128, minIf(Ca1, Cb in L27) as minCa128, maxIf(Ca1, Cb in L27) as maxCa128, anyIf(Ca1, Cb in L27) as anyCa128, avgIf(Ca2, Cb in L27) as avgCa228, sumIf(Ca2, Cb in L27) as sumCa228, minIf(Ca2, Cb in L27) as minCa228, maxIf(Ca2, Cb in L27) as maxCa228, anyIf(Ca2, Cb in L27) as anyCa228, avgIf(Ca3, Cb in L27) as avgCa328, sumIf(Ca3, Cb in L27) as sumCa328, minIf(Ca3, Cb in L27) as minCa328, maxIf(Ca3, Cb in L27) as maxCa328, anyIf(Ca3, Cb in L27) as anyCa328, avgIf(Ca1, Cb in L28) as avgCa129, sumIf(Ca1, Cb in L28) as sumCa129, minIf(Ca1, Cb in L28) as minCa129, maxIf(Ca1, Cb in L28) as maxCa129, anyIf(Ca1, Cb in L28) as anyCa129, avgIf(Ca2, Cb in L28) as avgCa229, sumIf(Ca2, Cb in L28) as sumCa229, minIf(Ca2, Cb in L28) as minCa229, maxIf(Ca2, Cb in L28) as maxCa229, anyIf(Ca2, Cb in L28) as anyCa229, avgIf(Ca3, Cb in L28) as avgCa329, sumIf(Ca3, Cb in L28) as sumCa329, minIf(Ca3, Cb in L28) as minCa329, maxIf(Ca3, Cb in L28) as maxCa329, anyIf(Ca3, Cb in L28) as anyCa329, avgIf(Ca1, Cb in L29) as avgCa130, sumIf(Ca1, Cb in L29) as sumCa130, minIf(Ca1, Cb in L29) as minCa130, maxIf(Ca1, Cb in L29) as maxCa130, anyIf(Ca1, Cb in L29) as anyCa130, avgIf(Ca2, Cb in L29) as avgCa230, sumIf(Ca2, Cb in L29) as sumCa230, minIf(Ca2, Cb in L29) as minCa230, maxIf(Ca2, Cb in L29) as maxCa230, anyIf(Ca2, Cb in L29) as anyCa230, avgIf(Ca3, Cb in L29) as avgCa330, sumIf(Ca3, Cb in L29) as sumCa330, minIf(Ca3, Cb in L29) as minCa330, maxIf(Ca3, Cb in L29) as maxCa330, anyIf(Ca3, Cb in L29) as anyCa330 from test.test_table where TIMESTAMP >= 1625796480 and TIMESTAMP < 1625796540 and Cc = 'eth0'
gCa321, sumIf(Ca3, Cb in L20) as sumCa321, minIf(Ca3, Cb in L20) as minCa321, maxIf(Ca3, Cb in L20) as maxCa321, anyIf(Ca3, Cb in L20) as anyCa321, avgIf(Ca1, Cb in L21) as avgCa122, sumIf(Ca1, Cb in L21) as sumCa122, minIf(Ca1, Cb in L21) as minCa122, maxIf(Ca1, Cb in L21) as maxCa122, anyIf(Ca1, Cb in L21) as anyCa122, avgIf(Ca2, Cb in L21) as avgCa222, sumIf(Ca2, Cb in L21) as sumCa222, minIf(Ca2, Cb in L21) as minCa222, maxIf(Ca2, Cb in L21) as maxCa222, anyIf(Ca2, Cb in L21) as anyCa222, avgIf(Ca3, Cb in L21) as avgCa322, sumIf(Ca3, Cb in L21) as sumCa322, minIf(Ca3, Cb in L21) as minCa322, maxIf(Ca3, Cb in L21) as maxCa322, anyIf(Ca3, Cb in L21) as anyCa322, avgIf(Ca1, Cb in L22) as avgCa123, sumIf(Ca1, Cb in L22) as sumCa123, minIf(Ca1, Cb in L22) as minCa123, maxIf(Ca1, Cb in L22) as maxCa123, anyIf(Ca1, Cb in L22) as anyCa123, avgIf(Ca2, Cb in L22) as avgCa223, sumIf(Ca2, Cb in L22) as sumCa223, minIf(Ca2, Cb in L22) as minCa223, maxIf(Ca2, Cb in L22) as maxCa223, anyIf(Ca2, Cb in L22) as anyCa223, avgIf(Ca3, Cb in L22) as avgCa323, sumIf(Ca3, Cb in L22) as sumCa323, minIf(Ca3, Cb in L22) as minCa323, maxIf(Ca3, Cb in L22) as maxCa323, anyIf(Ca3, Cb in L22) as anyCa323, avgIf(Ca1, Cb in L23) as avgCa124, sumIf(Ca1, Cb in L23) as sumCa124, minIf(Ca1, Cb in L23) as minCa124, maxIf(Ca1, Cb in L23) as maxCa124, anyIf(Ca1, Cb in L23) as anyCa124, avgIf(Ca2, Cb in L23) as avgCa224, sumIf(Ca2, Cb in L23) as sumCa224, minIf(Ca2, Cb in L23) as minCa224, maxIf(Ca2, Cb in L23) as maxCa224, anyIf(Ca2, Cb in L23) as anyCa224, avgIf(Ca3, Cb in L23) as avgCa324, sumIf(Ca3, Cb in L23) as sumCa324, minIf(Ca3, Cb in L23) as minCa324, maxIf(Ca3, Cb in L23) as maxCa324, anyIf(Ca3, Cb in L23) as anyCa324, avgIf(Ca1, Cb in L24) as avgCa125, sumIf(Ca1, Cb in L24) as sumCa125, minIf(Ca1, Cb in L24) as minCa125, maxIf(Ca1, Cb in L24) as maxCa125, anyIf(Ca1, Cb in L24) as anyCa125, avgIf(Ca2, Cb in L24) as avgCa225, sumIf(Ca2, Cb in L24) as sumCa225, minIf(Ca2, Cb in L24) as minCa225, maxIf(Ca2, Cb in L24) as maxCa225, anyIf(Ca2, Cb in L24) as anyCa225, avgIf(Ca3, Cb in L24) as avgCa325, sumIf(Ca3, Cb in L24) as sumCa325, minIf(Ca3, Cb in L24) as minCa325, maxIf(Ca3, Cb in L24) as maxCa325, anyIf(Ca3, Cb in L24) as anyCa325, avgIf(Ca1, Cb in L25) as avgCa126, sumIf(Ca1, Cb in L25) as sumCa126, minIf(Ca1, Cb in L25) as minCa126, maxIf(Ca1, Cb in L25) as maxCa126, anyIf(Ca1, Cb in L25) as anyCa126, avgIf(Ca2, Cb in L25) as avgCa226, sumIf(Ca2, Cb in L25) as sumCa226, minIf(Ca2, Cb in L25) as minCa226, maxIf(Ca2, Cb in L25) as maxCa226, anyIf(Ca2, Cb in L25) as anyCa226, avgIf(Ca3, Cb in L25) as avgCa326, sumIf(Ca3, Cb in L25) as sumCa326, minIf(Ca3, Cb in L25) as minCa326, maxIf(Ca3, Cb in L25) as maxCa326, anyIf(Ca3, Cb in L25) as anyCa326, avgIf(Ca1, Cb in L26) as avgCa127, sumIf(Ca1, Cb in L26) as sumCa127, minIf(Ca1, Cb in L26) as minCa127, maxIf(Ca1, Cb in L26) as maxCa127, anyIf(Ca1, Cb in L26) as anyCa127, avgIf(Ca2, Cb in L26) as avgCa227, sumIf(Ca2, Cb in L26) as sumCa227, minIf(Ca2, Cb in L26) as minCa227, maxIf(Ca2, Cb in L26) as maxCa227, anyIf(Ca2, Cb in L26) as anyCa227, avgIf(Ca3, Cb in L26) as avgCa327, sumIf(Ca3, Cb in L26) as sumCa327, minIf(Ca3, Cb in L26) as minCa327, maxIf(Ca3, Cb in L26) as maxCa327, anyIf(Ca3, Cb in L26) as anyCa327, avgIf(Ca1, Cb in L27) as avgCa128, sumIf(Ca1, Cb in L27) as sumCa128, minIf(Ca1, Cb in L27) as minCa128, maxIf(Ca1, Cb in L27) as maxCa128, anyIf(Ca1, Cb in L27) as anyCa128, avgIf(Ca2, Cb in L27) as avgCa228, sumIf(Ca2, Cb in L27) as sumCa228, minIf(Ca2, Cb in L27) as minCa228, maxIf(Ca2, Cb in L27) as maxCa228, anyIf(Ca2, Cb in L27) as anyCa228, avgIf(Ca3, Cb in L27) as avgCa328, sumIf(Ca3, Cb in L27) as sumCa328, minIf(Ca3, Cb in L27) as minCa328, maxIf(Ca3, Cb in L27) as maxCa328, anyIf(Ca3, Cb in L27) as anyCa328, avgIf(Ca1, Cb in L28) as avgCa129, sumIf(Ca1, Cb in L28) as sumCa129, minIf(Ca1, Cb in L28) as minCa129, maxIf(Ca1, Cb in L28) as maxCa129, anyIf(Ca1, Cb in L28) as anyCa129, avgIf(Ca2, Cb in L28) as avgCa229, sumIf(Ca2, Cb in L28) as sumCa229, minIf(Ca2, Cb in L28) as minCa229, maxIf(Ca2, Cb in L28) as maxCa229, anyIf(Ca2, Cb in L28) as anyCa229, avgIf(Ca3, Cb in L28) as avgCa329, sumIf(Ca3, Cb in L28) as sumCa329, minIf(Ca3, Cb in L28) as minCa329, maxIf(Ca3, Cb in L28) as maxCa329, anyIf(Ca3, Cb in L28) as anyCa329, avgIf(Ca1, Cb in L29) as avgCa130, sumIf(Ca1, Cb in L29) as sumCa130, minIf(Ca1, Cb in L29) as minCa130, maxIf(Ca1, Cb in L29) as maxCa130, anyIf(Ca1, Cb in L29) as anyCa130, avgIf(Ca2, Cb in L29) as avgCa230, sumIf(Ca2, Cb in L29) as sumCa230, minIf(Ca2, Cb in L29) as minCa230, maxIf(Ca2, Cb in L29) as maxCa230, anyIf(Ca2, Cb in L29) as anyCa230, avgIf(Ca3, Cb in L29) as avgCa330, sumIf(Ca3, Cb in L29) as sumCa330, minIf(Ca3, Cb in L29) as minCa330, maxIf(Ca3, Cb in L29) as maxCa330, anyIf(Ca3, Cb in L29) as anyCa330 from test.test_table where TIMESTAMP >= 1625796480 and TIMESTAMP < 1625796540 and Cc = 'eth0'
FORMAT TabSeparatedWithNamesAndTypes

Syntax error exception is thrown, here is the stack trace

0. Poco::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int) @ 0xd795710 in /usr/bin/clickhouse
1. DB::Exception::Exception(std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, int, bool) @ 0x4843af4 in /usr/bin/clickhouse
2. DB::parseQuery(DB::IParser&, char const*, char const*, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, unsigned long, unsigned long) (.cold) @ 0x45e0fe5 in /usr/bin/clickhouse
3. DB::executeQueryImpl(char const*, char const*, DB::Context&, bool, DB::QueryProcessingStage::Enum, bool, DB::ReadBuffer*) @ 0xa6423c4 in /usr/bin/clickhouse
4. DB::executeQuery(DB::ReadBuffer&, DB::WriteBuffer&, bool, DB::Context&, std::__1::function<void (std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&, std::__1::basic_string<char, std::__1::char_traits<char>, std::__1::allocator<char> > const&)>) @ 0xa645212 in /usr/bin/clickhouse
5. DB::HTTPHandler::processQuery(DB::Context&, DB::HTTPServerRequest&, DB::HTMLForm&, DB::HTTPServerResponse&, DB::HTTPHandler::Output&, std::__1::optional<DB::CurrentThread::QueryScope>&) @ 0xb306757 in /usr/bin/clickhouse
6. DB::HTTPHandler::handleRequest(DB::HTTPServerRequest&, DB::HTTPServerResponse&) @ 0xb30b9df in /usr/bin/clickhouse
7. DB::HTTPServerConnection::run() @ 0xb333601 in /usr/bin/clickhouse
8. Poco::Net::TCPServerConnection::start() @ 0xd6f6067 in /usr/bin/clickhouse
9. Poco::Net::TCPServerDispatcher::run() @ 0xd6f6558 in /usr/bin/clickhouse
10. Poco::PooledThread::run() @ 0xd80297e in /usr/bin/clickhouse
11. Poco::ThreadImpl::runnableEntry(void*) @ 0xd7ffb97 in /usr/bin/clickhouse
12. start_thread @ 0x7e15 in /usr/lib64/libpthread-2.17.so
13. __clone @ 0x101fed in /usr/lib64/libc-2.17.so

[den-crane]

@Zark1999 can you share .java file with repro?

[Zark1999]

@den-crane

Table Creation

create table test.test_table
(
    Cb String,
    CREATETIME DateTime64(3),
    TIMESTAMP UInt64,
    Cc String,
    Ca1 UInt64,
    Ca2 UInt64,
    Ca3 UInt64
)
engine = MergeTree()
PARTITION BY toYYYYMMDD(CREATETIME)
ORDER BY (Cb, CREATETIME, Cc);

Java Code

public static void main(String[] args) throws SQLException {
        ClickHouseProperties clickHouseProperties = new ClickHouseProperties();
        clickHouseProperties.setUser("default");
        clickHouseProperties.setPassword("{password}");
        clickHouseProperties.setDatabase("test");
        clickHouseProperties.setSocketTimeout(300000);
        clickHouseProperties.setMaxAstElements(Long.MAX_VALUE);
        clickHouseProperties.setMaxTotal(20);
        clickHouseProperties.setMaxQuerySize(104857600L);
        BalancedClickhouseDataSource dataSource = new BalancedClickhouseDataSource("jdbc:clickhouse://{ip}:{port}", clickHouseProperties);
        ClickHouseConnection conn = dataSource.getConnection();
        ClickHouseStatement statement = conn.createStatement();

        Map<ClickHouseQueryParam, String> paramMap = new HashMap<>();
        paramMap.put(ClickHouseQueryParam.PRIORITY,"2");

        List<ClickHouseExternalData> extDataList = new ArrayList<>();
        for (int i=0; i < 30; i++) {
            List<String> valueList = new ArrayList<>();
            for (int j=i; j<i+10; j++) {
                valueList.add(String.valueOf(j));
            }
            String dnExtString = String.join("\n", valueList);
            InputStream inputStream = new ByteArrayInputStream(dnExtString.getBytes(Charset.forName("UTF-8")));
            ClickHouseExternalData extData = new ClickHouseExternalData("L" + i, inputStream);
            extData.setStructure("Cb String");
            extDataList.add(extData);
        }

        String query = "select avgIf(Ca1, Cb in L0) as avgCa11, sumIf(Ca1, Cb in L0) as sumCa11, minIf(Ca1, Cb in L0) as minCa11, maxIf(Ca1, Cb in L0) as maxCa11, anyIf(Ca1, Cb in L0) as anyCa11, avgIf(Ca2, Cb in L0) as avgCa21, sumIf(Ca2, Cb in L0) as sumCa21, minIf(Ca2, Cb in L0) as minCa21, maxIf(Ca2, Cb in L0) as maxCa21, anyIf(Ca2, Cb in L0) as anyCa21, avgIf(Ca3, Cb in L0) as avgCa31, sumIf(Ca3, Cb in L0) as sumCa31, minIf(Ca3, Cb in L0) as minCa31, maxIf(Ca3, Cb in L0) as maxCa31, anyIf(Ca3, Cb in L0) as anyCa31, "
            + "avgIf(Ca1, Cb in L1) as avgCa12, sumIf(Ca1, Cb in L1) as sumCa12, minIf(Ca1, Cb in L1) as minCa12, maxIf(Ca1, Cb in L1) as maxCa12, anyIf(Ca1, Cb in L1) as anyCa12, avgIf(Ca2, Cb in L1) as avgCa22, sumIf(Ca2, Cb in L1) as sumCa22, minIf(Ca2, Cb in L1) as minCa22, maxIf(Ca2, Cb in L1) as maxCa22, anyIf(Ca2, Cb in L1) as anyCa22, avgIf(Ca3, Cb in L1) as avgCa32, sumIf(Ca3, Cb in L1) as sumCa32, minIf(Ca3, Cb in L1) as minCa32, maxIf(Ca3, Cb in L1) as maxCa32, anyIf(Ca3, Cb in L1) as anyCa32, "
            + "avgIf(Ca1, Cb in L2) as avgCa13, sumIf(Ca1, Cb in L2) as sumCa13, minIf(Ca1, Cb in L2) as minCa13, maxIf(Ca1, Cb in L2) as maxCa13, anyIf(Ca1, Cb in L2) as anyCa13, avgIf(Ca2, Cb in L2) as avgCa23, sumIf(Ca2, Cb in L2) as sumCa23, minIf(Ca2, Cb in L2) as minCa23, maxIf(Ca2, Cb in L2) as maxCa23, anyIf(Ca2, Cb in L2) as anyCa23, avgIf(Ca3, Cb in L2) as avgCa33, sumIf(Ca3, Cb in L2) as sumCa33, minIf(Ca3, Cb in L2) as minCa33, maxIf(Ca3, Cb in L2) as maxCa33, anyIf(Ca3, Cb in L2) as anyCa33, "
            + "avgIf(Ca1, Cb in L3) as avgCa14, sumIf(Ca1, Cb in L3) as sumCa14, minIf(Ca1, Cb in L3) as minCa14, maxIf(Ca1, Cb in L3) as maxCa14, anyIf(Ca1, Cb in L3) as anyCa14, avgIf(Ca2, Cb in L3) as avgCa24, sumIf(Ca2, Cb in L3) as sumCa24, minIf(Ca2, Cb in L3) as minCa24, maxIf(Ca2, Cb in L3) as maxCa24, anyIf(Ca2, Cb in L3) as anyCa24, avgIf(Ca3, Cb in L3) as avgCa34, sumIf(Ca3, Cb in L3) as sumCa34, minIf(Ca3, Cb in L3) as minCa34, maxIf(Ca3, Cb in L3) as maxCa34, anyIf(Ca3, Cb in L3) as anyCa34, "
            + "avgIf(Ca1, Cb in L4) as avgCa15, sumIf(Ca1, Cb in L4) as sumCa15, minIf(Ca1, Cb in L4) as minCa15, maxIf(Ca1, Cb in L4) as maxCa15, anyIf(Ca1, Cb in L4) as anyCa15, avgIf(Ca2, Cb in L4) as avgCa25, sumIf(Ca2, Cb in L4) as sumCa25, minIf(Ca2, Cb in L4) as minCa25, maxIf(Ca2, Cb in L4) as maxCa25, anyIf(Ca2, Cb in L4) as anyCa25, avgIf(Ca3, Cb in L4) as avgCa35, sumIf(Ca3, Cb in L4) as sumCa35, minIf(Ca3, Cb in L4) as minCa35, maxIf(Ca3, Cb in L4) as maxCa35, anyIf(Ca3, Cb in L4) as anyCa35, "
            + "avgIf(Ca1, Cb in L5) as avgCa16, sumIf(Ca1, Cb in L5) as sumCa16, minIf(Ca1, Cb in L5) as minCa16, maxIf(Ca1, Cb in L5) as maxCa16, anyIf(Ca1, Cb in L5) as anyCa16, avgIf(Ca2, Cb in L5) as avgCa26, sumIf(Ca2, Cb in L5) as sumCa26, minIf(Ca2, Cb in L5) as minCa26, maxIf(Ca2, Cb in L5) as maxCa26, anyIf(Ca2, Cb in L5) as anyCa26, avgIf(Ca3, Cb in L5) as avgCa36, sumIf(Ca3, Cb in L5) as sumCa36, minIf(Ca3, Cb in L5) as minCa36, maxIf(Ca3, Cb in L5) as maxCa36, anyIf(Ca3, Cb in L5) as anyCa36, "
            + "avgIf(Ca1, Cb in L6) as avgCa17, sumIf(Ca1, Cb in L6) as sumCa17, minIf(Ca1, Cb in L6) as minCa17, maxIf(Ca1, Cb in L6) as maxCa17, anyIf(Ca1, Cb in L6) as anyCa17, avgIf(Ca2, Cb in L6) as avgCa27, sumIf(Ca2, Cb in L6) as sumCa27, minIf(Ca2, Cb in L6) as minCa27, maxIf(Ca2, Cb in L6) as maxCa27, anyIf(Ca2, Cb in L6) as anyCa27, avgIf(Ca3, Cb in L6) as avgCa37, sumIf(Ca3, Cb in L6) as sumCa37, minIf(Ca3, Cb in L6) as minCa37, maxIf(Ca3, Cb in L6) as maxCa37, anyIf(Ca3, Cb in L6) as anyCa37, "
            + "avgIf(Ca1, Cb in L7) as avgCa18, sumIf(Ca1, Cb in L7) as sumCa18, minIf(Ca1, Cb in L7) as minCa18, maxIf(Ca1, Cb in L7) as maxCa18, anyIf(Ca1, Cb in L7) as anyCa18, avgIf(Ca2, Cb in L7) as avgCa28, sumIf(Ca2, Cb in L7) as sumCa28, minIf(Ca2, Cb in L7) as minCa28, maxIf(Ca2, Cb in L7) as maxCa28, anyIf(Ca2, Cb in L7) as anyCa28, avgIf(Ca3, Cb in L7) as avgCa38, sumIf(Ca3, Cb in L7) as sumCa38, minIf(Ca3, Cb in L7) as minCa38, maxIf(Ca3, Cb in L7) as maxCa38, anyIf(Ca3, Cb in L7) as anyCa38, "
            + "avgIf(Ca1, Cb in L8) as avgCa19, sumIf(Ca1, Cb in L8) as sumCa19, minIf(Ca1, Cb in L8) as minCa19, maxIf(Ca1, Cb in L8) as maxCa19, anyIf(Ca1, Cb in L8) as anyCa19, avgIf(Ca2, Cb in L8) as avgCa29, sumIf(Ca2, Cb in L8) as sumCa29, minIf(Ca2, Cb in L8) as minCa29, maxIf(Ca2, Cb in L8) as maxCa29, anyIf(Ca2, Cb in L8) as anyCa29, avgIf(Ca3, Cb in L8) as avgCa39, sumIf(Ca3, Cb in L8) as sumCa39, minIf(Ca3, Cb in L8) as minCa39, maxIf(Ca3, Cb in L8) as maxCa39, anyIf(Ca3, Cb in L8) as anyCa39, "
            + "avgIf(Ca1, Cb in L9) as avgCa110, sumIf(Ca1, Cb in L9) as sumCa110, minIf(Ca1, Cb in L9) as minCa110, maxIf(Ca1, Cb in L9) as maxCa110, anyIf(Ca1, Cb in L9) as anyCa110, avgIf(Ca2, Cb in L9) as avgCa210, sumIf(Ca2, Cb in L9) as sumCa210, minIf(Ca2, Cb in L9) as minCa210, maxIf(Ca2, Cb in L9) as maxCa210, anyIf(Ca2, Cb in L9) as anyCa210, avgIf(Ca3, Cb in L9) as avgCa310, sumIf(Ca3, Cb in L9) as sumCa310, minIf(Ca3, Cb in L9) as minCa310, maxIf(Ca3, Cb in L9) as maxCa310, anyIf(Ca3, Cb in L9) as anyCa310, "
            + "avgIf(Ca1, Cb in L10) as avgCa111, sumIf(Ca1, Cb in L10) as sumCa111, minIf(Ca1, Cb in L10) as minCa111, maxIf(Ca1, Cb in L10) as maxCa111, anyIf(Ca1, Cb in L10) as anyCa111, avgIf(Ca2, Cb in L10) as avgCa211, sumIf(Ca2, Cb in L10) as sumCa211, minIf(Ca2, Cb in L10) as minCa211, maxIf(Ca2, Cb in L10) as maxCa211, anyIf(Ca2, Cb in L10) as anyCa211, avgIf(Ca3, Cb in L10) as avgCa311, sumIf(Ca3, Cb in L10) as sumCa311, minIf(Ca3, Cb in L10) as minCa311, maxIf(Ca3, Cb in L10) as maxCa311, anyIf(Ca3, Cb in L10) as anyCa311, "
            + "avgIf(Ca1, Cb in L11) as avgCa112, sumIf(Ca1, Cb in L11) as sumCa112, minIf(Ca1, Cb in L11) as minCa112, maxIf(Ca1, Cb in L11) as maxCa112, anyIf(Ca1, Cb in L11) as anyCa112, avgIf(Ca2, Cb in L11) as avgCa212, sumIf(Ca2, Cb in L11) as sumCa212, minIf(Ca2, Cb in L11) as minCa212, maxIf(Ca2, Cb in L11) as maxCa212, anyIf(Ca2, Cb in L11) as anyCa212, avgIf(Ca3, Cb in L11) as avgCa312, sumIf(Ca3, Cb in L11) as sumCa312, minIf(Ca3, Cb in L11) as minCa312, maxIf(Ca3, Cb in L11) as maxCa312, anyIf(Ca3, Cb in L11) as anyCa312, "
            + "avgIf(Ca1, Cb in L12) as avgCa113, sumIf(Ca1, Cb in L12) as sumCa113, minIf(Ca1, Cb in L12) as minCa113, maxIf(Ca1, Cb in L12) as maxCa113, anyIf(Ca1, Cb in L12) as anyCa113, avgIf(Ca2, Cb in L12) as avgCa213, sumIf(Ca2, Cb in L12) as sumCa213, minIf(Ca2, Cb in L12) as minCa213, maxIf(Ca2, Cb in L12) as maxCa213, anyIf(Ca2, Cb in L12) as anyCa213, avgIf(Ca3, Cb in L12) as avgCa313, sumIf(Ca3, Cb in L12) as sumCa313, minIf(Ca3, Cb in L12) as minCa313, maxIf(Ca3, Cb in L12) as maxCa313, anyIf(Ca3, Cb in L12) as anyCa313, "
            + "avgIf(Ca1, Cb in L13) as avgCa114, sumIf(Ca1, Cb in L13) as sumCa114, minIf(Ca1, Cb in L13) as minCa114, maxIf(Ca1, Cb in L13) as maxCa114, anyIf(Ca1, Cb in L13) as anyCa114, avgIf(Ca2, Cb in L13) as avgCa214, sumIf(Ca2, Cb in L13) as sumCa214, minIf(Ca2, Cb in L13) as minCa214, maxIf(Ca2, Cb in L13) as maxCa214, anyIf(Ca2, Cb in L13) as anyCa214, avgIf(Ca3, Cb in L13) as avgCa314, sumIf(Ca3, Cb in L13) as sumCa314, minIf(Ca3, Cb in L13) as minCa314, maxIf(Ca3, Cb in L13) as maxCa314, anyIf(Ca3, Cb in L13) as anyCa314, "
            + "avgIf(Ca1, Cb in L14) as avgCa115, sumIf(Ca1, Cb in L14) as sumCa115, minIf(Ca1, Cb in L14) as minCa115, maxIf(Ca1, Cb in L14) as maxCa115, anyIf(Ca1, Cb in L14) as anyCa115, avgIf(Ca2, Cb in L14) as avgCa215, sumIf(Ca2, Cb in L14) as sumCa215, minIf(Ca2, Cb in L14) as minCa215, maxIf(Ca2, Cb in L14) as maxCa215, anyIf(Ca2, Cb in L14) as anyCa215, avgIf(Ca3, Cb in L14) as avgCa315, sumIf(Ca3, Cb in L14) as sumCa315, minIf(Ca3, Cb in L14) as minCa315, maxIf(Ca3, Cb in L14) as maxCa315, anyIf(Ca3, Cb in L14) as anyCa315, "
            + "avgIf(Ca1, Cb in L15) as avgCa116, sumIf(Ca1, Cb in L15) as sumCa116, minIf(Ca1, Cb in L15) as minCa116, maxIf(Ca1, Cb in L15) as maxCa116, anyIf(Ca1, Cb in L15) as anyCa116, avgIf(Ca2, Cb in L15) as avgCa216, sumIf(Ca2, Cb in L15) as sumCa216, minIf(Ca2, Cb in L15) as minCa216, maxIf(Ca2, Cb in L15) as maxCa216, anyIf(Ca2, Cb in L15) as anyCa216, avgIf(Ca3, Cb in L15) as avgCa316, sumIf(Ca3, Cb in L15) as sumCa316, minIf(Ca3, Cb in L15) as minCa316, maxIf(Ca3, Cb in L15) as maxCa316, anyIf(Ca3, Cb in L15) as anyCa316, "
            + "avgIf(Ca1, Cb in L16) as avgCa117, sumIf(Ca1, Cb in L16) as sumCa117, minIf(Ca1, Cb in L16) as minCa117, maxIf(Ca1, Cb in L16) as maxCa117, anyIf(Ca1, Cb in L16) as anyCa117, avgIf(Ca2, Cb in L16) as avgCa217, sumIf(Ca2, Cb in L16) as sumCa217, minIf(Ca2, Cb in L16) as minCa217, maxIf(Ca2, Cb in L16) as maxCa217, anyIf(Ca2, Cb in L16) as anyCa217, avgIf(Ca3, Cb in L16) as avgCa317, sumIf(Ca3, Cb in L16) as sumCa317, minIf(Ca3, Cb in L16) as minCa317, maxIf(Ca3, Cb in L16) as maxCa317, anyIf(Ca3, Cb in L16) as anyCa317, "
            + "avgIf(Ca1, Cb in L17) as avgCa118, sumIf(Ca1, Cb in L17) as sumCa118, minIf(Ca1, Cb in L17) as minCa118, maxIf(Ca1, Cb in L17) as maxCa118, anyIf(Ca1, Cb in L17) as anyCa118, avgIf(Ca2, Cb in L17) as avgCa218, sumIf(Ca2, Cb in L17) as sumCa218, minIf(Ca2, Cb in L17) as minCa218, maxIf(Ca2, Cb in L17) as maxCa218, anyIf(Ca2, Cb in L17) as anyCa218, avgIf(Ca3, Cb in L17) as avgCa318, sumIf(Ca3, Cb in L17) as sumCa318, minIf(Ca3, Cb in L17) as minCa318, maxIf(Ca3, Cb in L17) as maxCa318, anyIf(Ca3, Cb in L17) as anyCa318, "
            + "avgIf(Ca1, Cb in L18) as avgCa119, sumIf(Ca1, Cb in L18) as sumCa119, minIf(Ca1, Cb in L18) as minCa119, maxIf(Ca1, Cb in L18) as maxCa119, anyIf(Ca1, Cb in L18) as anyCa119, avgIf(Ca2, Cb in L18) as avgCa219, sumIf(Ca2, Cb in L18) as sumCa219, minIf(Ca2, Cb in L18) as minCa219, maxIf(Ca2, Cb in L18) as maxCa219, anyIf(Ca2, Cb in L18) as anyCa219, avgIf(Ca3, Cb in L18) as avgCa319, sumIf(Ca3, Cb in L18) as sumCa319, minIf(Ca3, Cb in L18) as minCa319, maxIf(Ca3, Cb in L18) as maxCa319, anyIf(Ca3, Cb in L18) as anyCa319, "
            + "avgIf(Ca1, Cb in L19) as avgCa120, sumIf(Ca1, Cb in L19) as sumCa120, minIf(Ca1, Cb in L19) as minCa120, maxIf(Ca1, Cb in L19) as maxCa120, anyIf(Ca1, Cb in L19) as anyCa120, avgIf(Ca2, Cb in L19) as avgCa220, sumIf(Ca2, Cb in L19) as sumCa220, minIf(Ca2, Cb in L19) as minCa220, maxIf(Ca2, Cb in L19) as maxCa220, anyIf(Ca2, Cb in L19) as anyCa220, avgIf(Ca3, Cb in L19) as avgCa320, sumIf(Ca3, Cb in L19) as sumCa320, minIf(Ca3, Cb in L19) as minCa320, maxIf(Ca3, Cb in L19) as maxCa320, anyIf(Ca3, Cb in L19) as anyCa320, "
            + "avgIf(Ca1, Cb in L20) as avgCa121, sumIf(Ca1, Cb in L20) as sumCa121, minIf(Ca1, Cb in L20) as minCa121, maxIf(Ca1, Cb in L20) as maxCa121, anyIf(Ca1, Cb in L20) as anyCa121, avgIf(Ca2, Cb in L20) as avgCa221, sumIf(Ca2, Cb in L20) as sumCa221, minIf(Ca2, Cb in L20) as minCa221, maxIf(Ca2, Cb in L20) as maxCa221, anyIf(Ca2, Cb in L20) as anyCa221, avgIf(Ca3, Cb in L20) as avgCa321, sumIf(Ca3, Cb in L20) as sumCa321, minIf(Ca3, Cb in L20) as minCa321, maxIf(Ca3, Cb in L20) as maxCa321, anyIf(Ca3, Cb in L20) as anyCa321, "
            + "avgIf(Ca1, Cb in L21) as avgCa122, sumIf(Ca1, Cb in L21) as sumCa122, minIf(Ca1, Cb in L21) as minCa122, maxIf(Ca1, Cb in L21) as maxCa122, anyIf(Ca1, Cb in L21) as anyCa122, avgIf(Ca2, Cb in L21) as avgCa222, sumIf(Ca2, Cb in L21) as sumCa222, minIf(Ca2, Cb in L21) as minCa222, maxIf(Ca2, Cb in L21) as maxCa222, anyIf(Ca2, Cb in L21) as anyCa222, avgIf(Ca3, Cb in L21) as avgCa322, sumIf(Ca3, Cb in L21) as sumCa322, minIf(Ca3, Cb in L21) as minCa322, maxIf(Ca3, Cb in L21) as maxCa322, anyIf(Ca3, Cb in L21) as anyCa322, "
            + "avgIf(Ca1, Cb in L22) as avgCa123, sumIf(Ca1, Cb in L22) as sumCa123, minIf(Ca1, Cb in L22) as minCa123, maxIf(Ca1, Cb in L22) as maxCa123, anyIf(Ca1, Cb in L22) as anyCa123, avgIf(Ca2, Cb in L22) as avgCa223, sumIf(Ca2, Cb in L22) as sumCa223, minIf(Ca2, Cb in L22) as minCa223, maxIf(Ca2, Cb in L22) as maxCa223, anyIf(Ca2, Cb in L22) as anyCa223, avgIf(Ca3, Cb in L22) as avgCa323, sumIf(Ca3, Cb in L22) as sumCa323, minIf(Ca3, Cb in L22) as minCa323, maxIf(Ca3, Cb in L22) as maxCa323, anyIf(Ca3, Cb in L22) as anyCa323, "
            + "avgIf(Ca1, Cb in L23) as avgCa124, sumIf(Ca1, Cb in L23) as sumCa124, minIf(Ca1, Cb in L23) as minCa124, maxIf(Ca1, Cb in L23) as maxCa124, anyIf(Ca1, Cb in L23) as anyCa124, avgIf(Ca2, Cb in L23) as avgCa224, sumIf(Ca2, Cb in L23) as sumCa224, minIf(Ca2, Cb in L23) as minCa224, maxIf(Ca2, Cb in L23) as maxCa224, anyIf(Ca2, Cb in L23) as anyCa224, avgIf(Ca3, Cb in L23) as avgCa324, sumIf(Ca3, Cb in L23) as sumCa324, minIf(Ca3, Cb in L23) as minCa324, maxIf(Ca3, Cb in L23) as maxCa324, anyIf(Ca3, Cb in L23) as anyCa324, "
            + "avgIf(Ca1, Cb in L24) as avgCa125, sumIf(Ca1, Cb in L24) as sumCa125, minIf(Ca1, Cb in L24) as minCa125, maxIf(Ca1, Cb in L24) as maxCa125, anyIf(Ca1, Cb in L24) as anyCa125, avgIf(Ca2, Cb in L24) as avgCa225, sumIf(Ca2, Cb in L24) as sumCa225, minIf(Ca2, Cb in L24) as minCa225, maxIf(Ca2, Cb in L24) as maxCa225, anyIf(Ca2, Cb in L24) as anyCa225, avgIf(Ca3, Cb in L24) as avgCa325, sumIf(Ca3, Cb in L24) as sumCa325, minIf(Ca3, Cb in L24) as minCa325, maxIf(Ca3, Cb in L24) as maxCa325, anyIf(Ca3, Cb in L24) as anyCa325, "
            + "avgIf(Ca1, Cb in L25) as avgCa126, sumIf(Ca1, Cb in L25) as sumCa126, minIf(Ca1, Cb in L25) as minCa126, maxIf(Ca1, Cb in L25) as maxCa126, anyIf(Ca1, Cb in L25) as anyCa126, avgIf(Ca2, Cb in L25) as avgCa226, sumIf(Ca2, Cb in L25) as sumCa226, minIf(Ca2, Cb in L25) as minCa226, maxIf(Ca2, Cb in L25) as maxCa226, anyIf(Ca2, Cb in L25) as anyCa226, avgIf(Ca3, Cb in L25) as avgCa326, sumIf(Ca3, Cb in L25) as sumCa326, minIf(Ca3, Cb in L25) as minCa326, maxIf(Ca3, Cb in L25) as maxCa326, anyIf(Ca3, Cb in L25) as anyCa326, "
            + "avgIf(Ca1, Cb in L26) as avgCa127, sumIf(Ca1, Cb in L26) as sumCa127, minIf(Ca1, Cb in L26) as minCa127, maxIf(Ca1, Cb in L26) as maxCa127, anyIf(Ca1, Cb in L26) as anyCa127, avgIf(Ca2, Cb in L26) as avgCa227, sumIf(Ca2, Cb in L26) as sumCa227, minIf(Ca2, Cb in L26) as minCa227, maxIf(Ca2, Cb in L26) as maxCa227, anyIf(Ca2, Cb in L26) as anyCa227, avgIf(Ca3, Cb in L26) as avgCa327, sumIf(Ca3, Cb in L26) as sumCa327, minIf(Ca3, Cb in L26) as minCa327, maxIf(Ca3, Cb in L26) as maxCa327, anyIf(Ca3, Cb in L26) as anyCa327, "
            + "avgIf(Ca1, Cb in L27) as avgCa128, sumIf(Ca1, Cb in L27) as sumCa128, minIf(Ca1, Cb in L27) as minCa128, maxIf(Ca1, Cb in L27) as maxCa128, anyIf(Ca1, Cb in L27) as anyCa128, avgIf(Ca2, Cb in L27) as avgCa228, sumIf(Ca2, Cb in L27) as sumCa228, minIf(Ca2, Cb in L27) as minCa228, maxIf(Ca2, Cb in L27) as maxCa228, anyIf(Ca2, Cb in L27) as anyCa228, avgIf(Ca3, Cb in L27) as avgCa328, sumIf(Ca3, Cb in L27) as sumCa328, minIf(Ca3, Cb in L27) as minCa328, maxIf(Ca3, Cb in L27) as maxCa328, anyIf(Ca3, Cb in L27) as anyCa328, "
            + "avgIf(Ca1, Cb in L28) as avgCa129, sumIf(Ca1, Cb in L28) as sumCa129, minIf(Ca1, Cb in L28) as minCa129, maxIf(Ca1, Cb in L28) as maxCa129, anyIf(Ca1, Cb in L28) as anyCa129, avgIf(Ca2, Cb in L28) as avgCa229, sumIf(Ca2, Cb in L28) as sumCa229, minIf(Ca2, Cb in L28) as minCa229, maxIf(Ca2, Cb in L28) as maxCa229, anyIf(Ca2, Cb in L28) as anyCa229, avgIf(Ca3, Cb in L28) as avgCa329, sumIf(Ca3, Cb in L28) as sumCa329, minIf(Ca3, Cb in L28) as minCa329, maxIf(Ca3, Cb in L28) as maxCa329, anyIf(Ca3, Cb in L28) as anyCa329, "
            + "avgIf(Ca1, Cb in L29) as avgCa130, sumIf(Ca1, Cb in L29) as sumCa130, minIf(Ca1, Cb in L29) as minCa130, maxIf(Ca1, Cb in L29) as maxCa130, anyIf(Ca1, Cb in L29) as anyCa130, avgIf(Ca2, Cb in L29) as avgCa230, sumIf(Ca2, Cb in L29) as sumCa230, minIf(Ca2, Cb in L29) as minCa230, maxIf(Ca2, Cb in L29) as maxCa230, anyIf(Ca2, Cb in L29) as anyCa230, avgIf(Ca3, Cb in L29) as avgCa330, sumIf(Ca3, Cb in L29) as sumCa330, minIf(Ca3, Cb in L29) as minCa330, maxIf(Ca3, Cb in L29) as maxCa330, anyIf(Ca3, Cb in L29) as anyCa330 "
            + "from test.test_table where TIMESTAMP >= 1625796480 and TIMESTAMP < 1625796540 and Cc = 'eth0'";

        ResultSet rs = statement.executeQuery(query, paramMap, extDataList);

        rs.close();
        statement.close();
        conn.close();
    }

No need to insert data. Just tested the MergeTree engine. It is not working, either.

[zhicwu]

Thank you @Zark1999 for the detailed inputs. I hope you don't mind that I added a unit test using the code you provided.

Anyway, I tried a few times using different parameters with no luck. I ran into below error if I create 100 external tables each contains 100 rows, but I don't think it's related. Changing it to 30 tables and 10000 rows worked well. I also tried BalancedClickhouseDataSource without any issue.

Is there any proxy between your program and ClickHouse server?

ClickHouse exception, code: 1000, host: localhost, port: 49544; Poco::Exception. Code: 1000, e.code() = 0, e.displayText() = HTML Form Exception: Too many form fields (version 21.3.4.25 (official build))

[Zark1999]

@zhicwu Sure, use it as one of unit tests. It is great if the code helps to check the funtionality.

As for the problem thrown. if it is not a bug of the source code, it might be caused by other parts like security or proxy. The source code was edited for an enhanced security by the company I'm working at, but I did not expect that would lead to new bugs, which I will check with the other team members later.

I really appreciate your immediate feedback, and I will close this issue.

[zhicwu]

You're welcome. Feel free to re-open the issue if you're certain it's related to either the driver or specific version of ClickHouse.