Materialized view to table with EmbeddedRocksDB engine

[Amit Sharma]

Hi All, 

I am trying to use EmbeddedRocksDB for optimizing key-based lookups. We are inserting into a table that uses MergeTree based engine and from there, insert into a table with EmbeddedRocksDB engine using a materialized view. However, the data inserted is not showing up in RocksDB table.   Are there any limitations in doing this? 

Thank you.

Amit

[Amit Sharma]

Thank you Denis for the sample. I realized later that I had the wrong column aliases in the materialized view.