CREATE TABLE Samples ( 
	Time TIMESTAMP,
	DeviceId INT,
	Register SYMBOL CAPACITY 256 CACHE INDEX CAPACITY 256,
	Value DOUBLE
) timestamp(Time) PARTITION BY MONTH WAL
DEDUP UPSERT KEYS(Time,DeviceId,Register);

CREATE MATERIALIZED VIEW Samples_latest AS
  SELECT
    Time as UnixEpoch,
    last(Time) AS Time,
    DeviceId,
    Register,
    last(Value) AS Value
  FROM
    Samples
  SAMPLE BY 2y;

INSERT INTO Samples (Time, DeviceId, Register, Value) VALUES (now(), 1, 'hello', 123);

SELECT * FROM wal_tables() WHERE suspended;