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.

Sign up for GitHub

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

Jump to bottom

Does distributed table support select with order? #37475

Closed
zouyonghao opened this issue May 24, 2022 · 3 comments
Closed

Does distributed table support select with order? #37475

zouyonghao opened this issue May 24, 2022 · 3 comments
Labels
question Question? question-answered

Comments

@zouyonghao
Copy link
Contributor

I know that distributed table does support create with order by, but it seems select from a distrbuted with order by also does not work.

Does distributed table support select with order?
@zouyonghao zouyonghao added the question Question? label May 24, 2022
@zouyonghao
Copy link
Contributor Author

Oops, I figure it out. It seems distributed table does not support order with position?

@den-crane
Copy link
Contributor

Distributed table supports order with position.
What CH version do you use?

@zouyonghao
Copy link
Contributor Author

Hi @den-crane, I'm using version ClickHouse server version 22.4.5.9 (official build).
I noticed that I don't set enable_positional_arguments to 1, but a query result from a local db is still orderd while result from distributed db is not.
If I set enable_positional_arguments to 1, all results from local/distributed are orderd.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
question Question? question-answered
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@zouyonghao @alexey-milovidov @den-crane