ytsaurus / ytsaurus/ytsaurus

The small queries can’t be executed

Open
#106 0 comments 0 reactions 1 assignee Claimed by @DimasKovas View on GitHub
Bug CHYT
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.