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

ALTER TABLE ... ON CLUSTER ... FETCH PARTITION not implemented? #45991

Open
cyberhuman opened this issue Feb 3, 2023 · 0 comments
Open

ALTER TABLE ... ON CLUSTER ... FETCH PARTITION not implemented? #45991

cyberhuman opened this issue Feb 3, 2023 · 0 comments

Comments

@cyberhuman
Copy link

Describe the unexpected behaviour

ALTER TABLE FETCH PARTITION doesn't work for me when adding ON CLUSTER:

ALTER TABLE db.table ON CLUSTER cluster1
    FETCH PARTITION (col1, col2) FROM '{zk}:/clickhouse/tables/db/table/0-{shard}'

Query id: b0b224f9-893f-428d-8b9c-14c31a870654


0 rows in set. Elapsed: 0.013 sec. 

Received exception from server (version 22.11.4):
Code: 48. DB::Exception: Received from 10.100.0.241:9001. DB::Exception: Unsupported type of ALTER query. (NOT_IMPLEMENTED)

How to reproduce

  • Which ClickHouse server version to use
    22.11.4

  • Which interface to use, if matters
    I used clickhouse-client.

  • Non-default settings, if any

  • CREATE TABLE statements for all tables involved

  • Sample data for all these tables, use clickhouse-obfuscator if necessary

  • Queries to run that lead to unexpected result

Expected behavior
partitions must be fetched on all nodes in the cluster

Error message and/or stacktrace
If applicable, add screenshots to help explain your problem.

Additional context
The documentation mentions ON CLUSTER: https://clickhouse.com/docs/en/sql-reference/statements/alter/partition/#fetch-partitionpart

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant