CREATE TABLE t1 (
  i UInt32,
  time DateTime
) ENGINE = MergeTree()
PARTITION BY time
ORDER BY time

CREATE TABLE t2 (
  i UInt32,
  time DateTime
) ENGINE = MergeTree()
PARTITION BY time
ORDER BY time

CREATE MATERIALIZED VIEW mv1
TO t2
AS SELECT * FROM (SELECT * FROM t1)

CREATE TABLE b1 AS t1
ENGINE = Buffer(default, t1, 1, 0, 0, 1, 1, 1, 1)

vmihailenco :) INSERT INTO b1 VALUES (1, now());

INSERT INTO b1 VALUES

Received exception from server (version 20.3.7):
Code: 393. DB::Exception: Received from localhost:9000. DB::Exception: There is no query.