ClickHouse / ClickHouse/ClickHouse
Renaming a projection
- Dominant language
- C++
- Stars
- 49.9k
- Forks
- 9k
- Avg merge
- 20h 33m
- Merged PRs (30d)
- 501
Description
**Company or project name**
Machine Factor Technologies
**Use case**
Suppose there is a huge table with projection `A`, and we want to improve it. So, we create a new variant of this projection called `B` to test how it would work. After we confirmed that `B` improves performance of a new kind of queries (as well as old ones too), it is time to drop a projection `A`. At this point it would be natural to rename projection `B` to `A`. But there is no way to do it.
(It feels strange to have a `funny_projection_2` in your table when there is no `funny_projection` in it.)
**Describe the solution you'd like**
Implement a query like this:
```sql
ALTER TABLE table RENAME PROJECTION name TO new_name
```
Contributor guide
Assessment
This issue has not been assessed yet.