CREATE TABLE ... ENGINE=ReplicatedMergeTree AS (SELECT...) cannot work correctly

[Alex-Cheng]

I created a cluster with several replicas and I try to create ReplicatedMergeTree tables with a subquery, aka. CREATE TABLE ... ENGINE=ReplicatedMergeTree AS (SELECT...). For consistency, I set insert_quorum = <number of replicas>.However, it does not work correctly, when insert_quorum_parallel=0 I got an exception, and when insert_quorum_parallel=1 the SQL statement does not throw exception but the succeedant dependent SQL fails.

I analyzed the issue should be caused by the following reasons:

When SQL statement CREATE TABLE ... ENGINE=ReplicatedMergeTree AS (SELECT...) is sent to a replica node of the cluster, the SQL will be written to ZK as a DDL statements. However the DDL statement actually will internally run a INSERT INTO statement. When other replica nodes obtain the DDL from ZK and run it locally, the INSERT INTO statement is also internally generated and executed, that breaks the rule of settings insert_quorum_parallel=0.

Is my analysis correct and how could I get rid of it?

Thank you very much.