The small queries can’t be executed
- Dominant language
- C++
- Stars
- 2.2k
- Forks
- 220
- PR merge metrics
- No merged PRs in 30d
Description
Some CHYT queries execute indefinitely even on the small tables and are aborted by timeout (several hours).
The problem queries are the standard ones from the TPC-H benchmark:
* [Q19](https://github.com/MonetDB/tpch-clickhouse/blob/main/ch19.sql) hangs on Scale Factor 1
* [Q2](https://github.com/MonetDB/tpch-clickhouse/blob/main/ch02.sql), [Q8](https://github.com/MonetDB/tpch-clickhouse/blob/main/ch08.sql), [Q9](https://github.com/MonetDB/tpch-clickhouse/blob/main/ch09.sql) hang on SF10.
All these queries work well at the tiny scale factor. Another queries are successful even on a much larger scale (so it’s not like a cluster lack of resources).
The used ClickHouse in CHYT version: 22.8.16.1
Please investigate whether it’s caused by unsupported syntax or something else.
Contributor guide
Assessment
This issue has not been assessed yet.