Could we specify column type, aggregation function and compression on materialized view?

[hueiyuan]

Describe the bug

As topic, Could we specify column type and compression on materialized view?

Following the below example table:

CREATE TABLE IF NOT EXISTS db.mv_table ON CLUSTER '{cluster}'
(
    dt_day DateTime CODEC(Delta, ZSTD(1)),
    team_id LowCardinality(String) CODEC(ZSTD(1)),
    "le_accumulate" SimpleAggregateFunction(sum, Float64),
.......
)ENGINE = ReplicatedAggregatingMergeTree('/clickhouse/clusters/{cluster}/databases/{database}/tables/{table}/{shard}', '{replica}')
PARTITION BY (toYYYYMMDD(dt_day))

How do we create materialized_view and specify column type as like LowCardinality(String) or compression as CODEC(ZSTD(1)) as the same time? Additionally, how to we specify SimpleAggregateFunction(sum, Float64) during create materialized_view

If have any ideas can solve this, I will be appreciated it.