Skip to content

feat(sql): rewrite select count_distinct() queries #4078

Merged
puzpuzpuz merged 6 commits intopuzpuzpuz_parallel_group_byfrom
bz_rewrite_count_distinct
Dec 21, 2023
Merged

feat(sql): rewrite select count_distinct() queries #4078
puzpuzpuz merged 6 commits intopuzpuzpuz_parallel_group_byfrom
bz_rewrite_count_distinct

Conversation

@bziobrowski
Copy link
Copy Markdown
Contributor

@bziobrowski bziobrowski commented Dec 21, 2023

PR rewrites expressions such as :

   SELECT count_distinct(s) FROM tab WHERE s like '%a ;

into more parallel-friendly :

   SELECT count(*) FROM (SELECT s FROM tab WHERE s like '%a' AND s IS NOT NULL GROUP BY s);

@bziobrowski bziobrowski changed the base branch from master to puzpuzpuz_parallel_group_by December 21, 2023 12:19
@puzpuzpuz puzpuzpuz merged commit 997863d into puzpuzpuz_parallel_group_by Dec 21, 2023
@puzpuzpuz puzpuzpuz deleted the bz_rewrite_count_distinct branch December 21, 2023 12:40
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants