search

ydb-platform / ydb

YDB is an open source Distributed SQL Database that combines high availability and scalability with strong consistency and ACID transactions
https://ydb.tech
Apache License 2.0
4k stars 565 forks source link

TPCH Q9 on Scale 100 row storage generates too many tasks #3594

Closed pavelvelikhov closed 2 months ago

pavelvelikhov commented 7 months ago

Query: https://github.com/ydb-platform/optimizer-test-framework/blob/main/tpch_100_row_yql_09_04_2024/queries/q9_opt.sql

Error: https://github.com/ydb-platform/optimizer-test-framework/blob/main/tpch_100_row_yql_09_04_2024/errors/q9_opt.analyze

bucket: tpch-datasets https://console.yandex.cloud/folders/b1glgqjg7f3daei68v1p/storage/buckets/tpch-datasets?key=yql_tpch_100_row%2F id: YCAJEtFeww7puX_Czgkqme52M

gridnevvvit commented 2 months ago

it's basically not a problem at this moment