PROJECTION Compression (skip indexes and settings ?)

[UnamedRus]

Use case

Allow users to set Compression, index and settings for projections.

Describe the solution you'd like

CREATE TABLE xxx_proj
(
    `key` UInt32,
    `value` UInt64,
    PROJECTION proj
    (key UInt32 CODEC (T64,LZ4),
     value UInt64 CODEC(T64,LZ4),
    INDEX idx_mm value TYPE minmax GRANULARITY 1000
    )
    (
        SELECT
            key,
            sum(value)
        GROUP BY key
    ) SETTINGS index_granularity = 1024
)
ENGINE = MergeTree
ORDER BY key

CREATE TABLE xxx_proj
(
    `key` UInt32,
    `value` UInt64,
    PROJECTION proj
    (key UInt32 CODEC (T64,LZ4),
     value UInt64 CODEC(T64,LZ4),
    INDEX idx_mm value TYPE minmax GRANULARITY 1000
    ) AS
        SELECT
            key,
            sum(value)
        GROUP BY key
    SETTINGS index_granularity = 1024
)
ENGINE = MergeTree
ORDER BY key

[alexey-milovidov]

Yes, why not... CC @amosbird

[amosbird]

Not sure what's the proper grammar for this. But yes, it's already in plan.

[orloffv]

@amosbird do you have any updates?