You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@doris.apache.org by GitBox <gi...@apache.org> on 2019/08/15 06:52:44 UTC
[GitHub] [incubator-doris] worker24h opened a new issue #1650: Where clause
can't push down into the right table of JOIN clasure
worker24h opened a new issue #1650: Where clause can't push down into the right table of JOIN clasure
URL: https://github.com/apache/incubator-doris/issues/1650
Where clause can't push down into the right table of JOIN clasure in Doris, howevery Impala or Mysql can do that.
For example：
SELECT persons.pid, orders.oid, persons.lastname, persons.firstname, orders.ordernum FROM persons left join orders ON persons.pid=orders.oid where orders.oid = 2;
-------------------------------------------------------------------------------------------------------------------------------
+------------------------------------------------------------------------------------------------------------------------+
| Explain String |
+------------------------------------------------------------------------------------------------------------------------+
| PLAN FRAGMENT F02 |
| OUTPUT EXPRS:`persons`.`pid` | `orders`.`oid` | `persons`.`lastname` | `persons`.`firstname` | `orders`.`ordernum` | |
| PARTITION: UNPARTITIONED |
| |
| RESULT SINK |
| |
| 4:EXCHANGE |
| tuple ids: 0 1N |
| |
| PLAN FRAGMENT F00 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 04 |
| UNPARTITIONED |
| |
| 2:HASH JOIN |
| | join op: LEFT OUTER JOIN (BROADCAST) |
| | hash predicates: |
| | colocate: false, reason: table not in same group |
| | `persons`.`pid` = `orders`.`oid` |
| | other predicates: `orders`.`oid` = 2 |
| | tuple ids: 0 1N |
| | |
| |----3:EXCHANGE |
| | tuple ids: 1 |
| | |
| 0:OlapScanNode |
| TABLE: persons |
| PREAGGREGATION: OFF. Reason: No AggregateInfo |
| partitions=1/1 |
| rollup: persons |
| buckets=32/32 |
| cardinality=2 |
| avgRowSize=1172.0 |
| numNodes=1 |
| tuple ids: 0 |
| |
| PLAN FRAGMENT F01 |
| OUTPUT EXPRS: |
| PARTITION: RANDOM |
| |
| STREAM DATA SINK |
| EXCHANGE ID: 03 |
| UNPARTITIONED |
| |
| 1:OlapScanNode |
| TABLE: orders |
| PREAGGREGATION: OFF. Reason: null |
| partitions=1/1 |
| rollup: orders |
| buckets=32/32 |
| cardinality=4 |
| avgRowSize=572.75 |
| numNodes=1 |
| tuple ids: 1 |
+------------------------------------------------------------------------------------------------------------------------+
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@doris.apache.org
For additional commands, e-mail: dev-help@doris.apache.org