ClickHouse / ClickHouse/ClickHouse

Renaming a projection

Open
#69,327 1 comment 1 reaction 0 assignees View on GitHub
comp-projections external feature
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.