search

ContentSquare / chproxy

Open-Source ClickHouse http proxy and load balancer
https://www.chproxy.org/
MIT License
1.24k stars 256 forks source link

[QUESTION] Availability of max_query_size Flag in Chproxy #433

Closed mrankitsinghal closed 1 month ago

mrankitsinghal commented 2 months ago

Question: Availability of max_query_size Flag in Chproxy

Question details In our use case with ClickHouse, we often encounter the need to pass larger queries. While the max_query_size flag works seamlessly with ClickHouse directly, we've encountered errors when using it with Chproxy. Can someone confirm whether the max_query_size flag is available in Chproxy?

Additional context/motivations The max_query_size parameter is supported by ClickHouse within Query statements, aiding in the handling of larger queries.

mga-chka commented 2 months ago

indead you can use this flag. One way to have it in chproxy is to write it in the clickhouse query using the SETTINGS keyword. For example: select * from system.numbers limit 1 settings max_query_size= 400, would it solve your issue?