SET allow_deprecated_syntax_for_merge_tree = 1, allow_experimental_analyzer = 1, optimize_on_insert = 0;

DROP TABLE IF EXISTS mult_tab;
CREATE TABLE mult_tab (`date` Date, `value` String, `version` UInt64, `sign` Int8) ENGINE = VersionedCollapsingMergeTree(date, date, 8192, sign, version);
INSERT INTO mult_tab SELECT '2018-01-31', concat('str_', toString(number)), 0, if(number % 2, 1, -1) FROM system.numbers LIMIT 10;
INSERT INTO mult_tab SELECT '2018-01-31', concat('str_', toString(number)), 0, if(number % 2, 1, -1) FROM system.numbers LIMIT 10;
OPTIMIZE TABLE mult_tab;
SELECT * FROM mult_tab;
DROP TABLE mult_tab;