Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Syntax error when select from the result of explain query #819

Open
Tracked by #826
sunset3000 opened this issue Aug 14, 2024 · 0 comments
Open
Tracked by #826

Syntax error when select from the result of explain query #819

sunset3000 opened this issue Aug 14, 2024 · 0 comments
Assignees
Labels
bug Something isn't working

Comments

@sunset3000
Copy link
Collaborator

Describe what's wrong

  1. excute the below query, it reports syntax error
create STREAM tab (a int32, b int32, c int32, d int32) engine = MergeTree order by (a, b, c);

insert into tab select 0, number % 3, 2 - int_div(number, 3), (number % 3 + 1) * 10 from numbers(6);
insert into tab select 0, number % 3, 2 - int_div(number, 3), (number % 3 + 1) * 100 from numbers(6);

select * from (explain actions = 1, sorting=1 select a, any(b), c, d from tab where b = 1 group by a, c, d settings optimize_aggregation_in_order=1, query_plan_aggregation_in_order=1) where explain like '%Sorting (Stream)%' or explain like '%ReadFromMergeTree%' or explain like '%Aggregating%' or explain like '%Order:%';

Expected Result:
the above can run without problem.

How to reproduce

Error message and/or stacktrace

Additional context

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants