Comments (3)
Simplified repro:
$web_v1 = (
select web_sales.ws_item_sk item_sk, date_dim.d_date as d_date from bindings.web_sales as web_sales
cross join bindings.date_dim as date_dim
where ws_sold_date_sk=d_date_sk
);
$store_v1 = (
select store_sales.ss_item_sk item_sk, date_dim.d_date as d_date from bindings.store_sales as store_sales
cross join bindings.date_dim as date_dim
where ss_sold_date_sk=d_date_sk
);
select * from $web_v1 as web full outer join $store_v1 as store on (web.item_sk = store.item_sk and web.d_date = store.d_date);
from ydb.
Query fails here:
CBO chose EJoinAlgoType::MapJoin
, but JoinDict
was built here:
ydb/ydb/library/yql/dq/opt/dq_opt_join.cpp
Line 1479 in 16981dc
from ydb.
We should deprecate using EHashJoinMode::Map
for full and exclusion joins
from ydb.
Related Issues (20)
- TPqGroupTestReboots.AlterWithReboots-PQConfigTransactionsAtSchemeShard-false
- BlobScrubbing.block42
- BlobScrubbing.mirror3dc
- BlobScrubbing.mirror3of4
- move nemesis driver to opensource
- TPCH Q1 scale 100 on column shards doesn't compile
- Fix VERIFY RecoverLostDataModeHandle
- Change VERIFY BuildRequest to KILL_TABLET
- fix describe behavior and diagnostics when scheme shard returns errors
- improve CORS headers in viewer backend
- Error while running query via DataQuery
- KQP: ReadActor uses confusing quotas in TEvReadAck messages
- Add CBO unit tests for column shards
- Implement Join Order hints
- TPCH Q21 on scale 100 has a broken explain analyze
- Analyze TCPH Q10 scale 100 YDB vs GP
- Build benchmark generator for cost functions
- CTAS remove per-statement checks
- CTAS Explain
- TPCH CLI workload command has a minor bug in TPCH schema for column shards
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.