Comments (5)
Надо поправить зависание в каналах, включить спиллинг и выключить split stage. После этого проверить воспроизведение.
from ydb.
Reproducible with
PRAGMA dq.SplitStageOnDqReplicate="0"
PRAGMA dq.EnableDqReplicate = "1";
and --enable-spilling
(this query is not affected by stalls due to Split*=0
)
from ydb.
Full list of pragma:
PRAGMA dq.SplitStageOnDqReplicate="0";
PRAGMA dq.EnableDqReplicate = "1";
PRAGMA DisableSimpleColumns;
PRAGMA dq.MaxTasksPerOperation='1700';
PRAGMA dq.HashJoinMode = "grace";
PRAGMA dq.HashShuffleTasksRatio="1.0";
PRAGMA dq.HashShuffleMaxTasks="200";
-- pragma dq.AggregateStatsByStage="false";
pragma dq.OptLLVM="off";
PRAGMA s3.UseBlocksSource="true";
pragma OrderedColumns="true";
pragma dq.MaxTasksPerStage="8";
pragma dq.ComputeActorType="async";
pragma AnsiOptionalAs="1";
from ydb.
$bla1
in t1/t8 identical, $bla2
has different row order (but sorted content identical).
After replacing count(*)
with *
, and sorting results,
--- ds-1-q87-nocount-t8.sql.yson-sorted 2024-06-13 15:12:52.351514497 +0300
+++ ds-1-q87-nocount.sql.yson-sorted 2024-06-13 15:12:57.911540251 +0300
@@ -37416,7 +37416,6 @@
["Scott";"";["11654"]];
["";"Scott";["11688"]];
["Scott";"";["11765"]];
-["Scott";"";["11926"]];
["Scott";"";["11959"]];
["Scott";"Adam";["11596"]];
["Scott";"Adam";["11751"]];
As ["Scott";"";["11926"]];
row is missing in $bla2
, probably left only join
works incorrectly.
Other queries with left only join
are q16, q69, q94
from ydb.
from ydb.
Related Issues (20)
- add http-handle returning configs
- Parquet file import error
- Query fails with Snapshot too old
- Error: Delivery problem: EvScanDataAck lost
- Failed to build physical query: some stages are broken
- Unexpected "Mkql memory limit exceeded" problem after the query failure (tpcds q14 & q24 problems) HOT 1
- "Mkql memory limit exceeded" q13 & q23 problems
- Balancer blocking other balancers in Hive
- Timeout in query table explain --analyze doesn't work
- Implement TabletService
- Effective writes for sparse data
- VERIFY ydb/library/yql/minikql/computation/mkql_computation_pattern_cache.cpp:80 HOT 1
- embedded_ui_refresh workflow bug
- Remove grpc legacy for bsconfig
- Add current_schema function to PG whilelist HOT 1
- CS fails on verify
- [[Aardappel]]: Do not allow commit topic from multiple gorutine simultaneously HOT 1
- Memory tracking for CA block inputs
- Condition violated: `queryIt.second' in kqp_compile_service.cpp
- Statistics lost when computing predicate selectivity in unit test
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from ydb.