[GitHub] [incubator-doris] spaces-X commented on pull request #3915: fix subquery bug when reorder table

[GitBox <gi...@apache.org>]

spaces-X commented on pull request #3915:
URL: https://github.com/apache/incubator-doris/pull/3915#issuecomment-650872454


   > Doris will construct a left-deep tree for the join tables. In the star schema, fact table usually is the biggest table, it will be make the leftmost node by ordering the table by row counts. When doing hash-join, all the right table will be loaded into memory to build a hash table. If the fact table is regarded as build table, the performance will be bad.
   
   Thanks a lot.
   We have encoutered some problems in reordering table. [#3908 ](https://github.com/apache/incubator-doris/issues/3908)
   After reordering table and query rewrite, stmt will be reanalyzed.
   In reanalyze process, column can not be resloved.
   Do you have some advice to improve this case?
   
   


----------------------------------------------------------------
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



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org