79084806

Date: 2024-10-14 05:34:53
Score: 2.5
Natty:
Report link

Could you share SHOW CREATE TABLE vp_1min FORMAT Vertical?

Does your table have engine=AggregatingMergeTree or engine=SummingMergeTree?

If not, then looks like your expectation from Materialized View are wrong.

Materialized View is just AFTER INSERT TRIGGER which works with every rows only inside one INSERT statement INTO tick table.

So you need to apply AggregatingMergeTree engine

https://clickhouse.com/docs/en/engines/table-engines/mergetree-family/aggregatingmergetree

and use SELECT .. FINAL

https://clickhouse.com/docs/en/sql-reference/statements/select/from#final-modifier

Reasons:
  • RegEx Blacklisted phrase (2.5): Could you share
  • Probably link only (1):
  • Has code block (-0.5):
  • Contains question mark (0.5):
  • High reputation (-1):
Posted by: Slach