We are now using Clickhouse for OLTP  streaming computing system.

Read this PDF for some tips for MV of Clickhouse CK-MV