Closed dataroaring closed 2 years ago
master 1.0.0 1.0.1
push down does not work good enough on left outer join.
works good enough.
CREATE TABLE left_outer_left_table ( k1varchar(200) NULL COMMENT "" ) ENGINE=OLAP UNIQUE KEY(k1) COMMENT "olap" DISTRIBUTED BY HASH(k1) BUCKETS 20 PROPERTIES ( "in_memory" = "false", "storage_format" = "V2", "replication_num" = "1" );
CREATE TABLE left_outer_left_table (
varchar(200) NULL COMMENT "" ) ENGINE=OLAP UNIQUE KEY(
) COMMENT "olap" DISTRIBUTED BY HASH(
) BUCKETS 20 PROPERTIES ( "in_memory" = "false", "storage_format" = "V2", "replication_num" = "1" );
CREATE TABLE left_outer_right_table ( k2varchar(100) NULL COMMENT "" ) ENGINE=OLAP UNIQUE KEY(k2) COMMENT "olap" DISTRIBUTED BY HASH(k2) BUCKETS 20 PROPERTIES ( "in_memory" = "false", "storage_format" = "V2", "replication_num" = "1" );
CREATE TABLE left_outer_right_table (
varchar(100) NULL COMMENT "" ) ENGINE=OLAP UNIQUE KEY(
explain select k2 from left_outer_left_table a left outer join left_outer_right_table b on b.k2 = a.k1 where a.k1='uuid'
No response
fixed by #9703
Search before asking
Version
master 1.0.0 1.0.1
What's Wrong?
push down does not work good enough on left outer join.
What You Expected?
works good enough.
How to Reproduce?
CREATE TABLE left_outer_left_table (
k1varchar(200) NULL COMMENT "" ) ENGINE=OLAP UNIQUE KEY(
k1) COMMENT "olap" DISTRIBUTED BY HASH(
k1) BUCKETS 20 PROPERTIES ( "in_memory" = "false", "storage_format" = "V2", "replication_num" = "1" );
CREATE TABLE left_outer_right_table (
k2varchar(100) NULL COMMENT "" ) ENGINE=OLAP UNIQUE KEY(
k2) COMMENT "olap" DISTRIBUTED BY HASH(
k2) BUCKETS 20 PROPERTIES ( "in_memory" = "false", "storage_format" = "V2", "replication_num" = "1" );
explain select k2 from left_outer_left_table a left outer join left_outer_right_table b on b.k2 = a.k1 where a.k1='uuid'
Anything Else?
No response
Are you willing to submit PR?
Code of Conduct