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
FR: Renaming Columns #146
Comments
We have this feature request from other customers too. Implementation is not trivial, because ALTERs that changing columns are processed outside of usual replication queue, and adding rename without reworking of ALTERs will introduce race conditions in replicated tables. |
+1 Do you have any milestone for this feature? |
@fizerkhan unfortunately, there's no ETA at the moment. |
@blinkov Thanks for the update. Do you have any other method to do it? |
@fizerkhan workaround is INSERT+SELECT or clickhouse-copier data into a new table with properly named columns |
@blinkov Is it possible to rename fields between source-destination tables between tables using clickhouse-copier? |
Column rename on simple non-replicated tables would be very welcome for prototyping and single workstation data science workflows. Any pointers for how to implement this? |
Current status: this feature is not in progress and is queued after another feature: non-locking ALTERs. |
Feature in this PR: #9948. |
* I described function randomStringUTF8 * Update docs/en/sql-reference/functions/other-functions.md Co-authored-by: BayoNet <da-daos@yandex.ru> * Update docs/en/sql-reference/functions/other-functions.md Co-authored-by: BayoNet <da-daos@yandex.ru> * Update docs/en/sql-reference/functions/other-functions.md Co-authored-by: BayoNet <da-daos@yandex.ru> * Ive edited en-version and translated function description to Russian. Co-authored-by: BayoNet <da-daos@yandex.ru>
Hello!
Thank you for the great DBMS!
It would be nice to have support of renaming columns. For example:
ALTER TABLE table_name RENAME [ COLUMN ] column_name TO new_column_name;
or
RENAME COLUMN table_name.column_name TO new_column_name;
Now we have to create a new table, copy the data to it using the INSERT SELECT, rename table to the old name. It can takes a lot of time.
The text was updated successfully, but these errors were encountered: