Skip to content

Conversation

@xiaokang
Copy link
Contributor

@xiaokang xiaokang commented Jun 4, 2023

Proposed changes

Issue Number: close #xxx

  1. add testcase for key topn opt
  2. disable key topn opt only for DUP_KEYS and UNIQUE_KEYS with MOW
  3. cherry pick some bugfix commit from master

commit 58c5108
Author: Kang kxiao.tiger@gmail.com
Date: Sun Feb 19 23:28:33 2023 +0800

[bugfix](topn) fix topn read_orderby_key_columns nullptr (#16896)

commit 479272f
Author: Kang kxiao.tiger@gmail.com
Date: Fri Mar 31 10:02:07 2023 +0800

[bugfix](topn) fix topn optimzation wrong result for NULL values (#18121)

commit d9924c9
Author: Kang kxiao.tiger@gmail.com
Date: Fri Feb 10 12:56:33 2023 +0800

[Improvement](topn) add limit threashold session variable and fuzzy for topn optimizations (#16514)

1. add limit threshold for topn runtime pushdown and key topn optimization
2. use unified session variable topn_opt_limit_threshold for all topn optimizations
4. add fuzzy support for topn_opt_limit_threshold

Further comments

If this is a relatively large or complex change, kick off the discussion at dev@doris.apache.org by explaining why you chose the solution you did and what alternatives you considered, etc...

xiaokang added 5 commits June 4, 2023 17:00
…or topn optimizations (apache#16514)

1. add limit threshold for topn runtime pushdown and key topn optimization
2. use unified session variable topn_opt_limit_threshold for all topn optimizations
3. add fuzzy support for topn_opt_limit_threshold
 [bugfix](topn) fix topn optimzation wrong result for NULL values (apache#18121)
@github-actions github-actions bot added area/planner Issues or PRs related to the query planner kind/test labels Jun 4, 2023
@xiaokang
Copy link
Contributor Author

xiaokang commented Jun 4, 2023

run buildall

@morningman morningman merged commit 158831a into apache:branch-1.2-lts Jun 6, 2023
mongo360 pushed a commit to mongo360/doris that referenced this pull request Jul 12, 2023
…20406)

1. add testcase for key topn opt
2. disable key topn opt only for DUP_KEYS and UNIQUE_KEYS with MOW
3. cherry pick some bugfix commit from master

commit 58c5108
Author: Kang <kxiao.tiger@gmail.com>
Date:   Sun Feb 19 23:28:33 2023 +0800

    [bugfix](topn) fix topn read_orderby_key_columns nullptr (apache#16896)

commit 479272f
Author: Kang <kxiao.tiger@gmail.com>
Date:   Fri Mar 31 10:02:07 2023 +0800

    [bugfix](topn) fix topn optimzation wrong result for NULL values (apache#18121)


commit d9924c9
Author: Kang <kxiao.tiger@gmail.com>
Date:   Fri Feb 10 12:56:33 2023 +0800

    [Improvement](topn) add limit threashold session variable and fuzzy for topn optimizations (apache#16514)

    1. add limit threshold for topn runtime pushdown and key topn optimization
    2. use unified session variable topn_opt_limit_threshold for all topn optimizations
    4. add fuzzy support for topn_opt_limit_threshold
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

area/planner Issues or PRs related to the query planner dev/1.2.5-merged kind/test

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants