Materialized view test hypothesis based on https://altinity.com/blog/clickhouse-materialized-views-illuminated-part-1 ``` $ bash 01_start_clickhouse.sh $ bash 02-prepare.sh $ bash 03-check_results_before.sh ===== Aggregated using raw query 2021-07-11 00:00:00 22 1440 72520612970 2021-07-10 00:00:00 22 1440 71997844405 2021-07-09 00:00:00 22 1229 62470639726 2021-07-12 00:00:00 22 891 43958623401 2021-07-11 00:00:00 25 1440 72082035463 2021-07-10 00:00:00 25 1440 70593255841 2021-07-09 00:00:00 25 1229 64833984769 2021-07-12 00:00:00 25 891 44041607375 ===== Aggregated using materialized view 2021-07-11 00:00:00 22 1440 72520612970 2021-07-10 00:00:00 22 1440 71997844405 2021-07-09 00:00:00 22 1229 62470639726 2021-07-12 00:00:00 22 891 43958623401 2021-07-11 00:00:00 25 1440 72082035463 2021-07-10 00:00:00 25 1440 70593255841 2021-07-09 00:00:00 25 1229 64833984769 2021-07-12 00:00:00 25 891 44041607375 $ bash 04-delete_part.sh $ bash 05-check_results_after.sh ===== Aggregated using raw query 2021-07-11 00:00:00 25 1440 72082035463 2021-07-10 00:00:00 25 1440 70593255841 2021-07-09 00:00:00 25 1229 64833984769 2021-07-12 00:00:00 25 891 44041607375 ===== Aggregated using materialized view 2021-07-11 00:00:00 22 1440 72520612970 2021-07-10 00:00:00 22 1440 71997844405 2021-07-09 00:00:00 22 1229 62470639726 2021-07-12 00:00:00 22 891 43958623401 2021-07-11 00:00:00 25 1440 72082035463 2021-07-10 00:00:00 25 1440 70593255841 2021-07-09 00:00:00 25 1229 64833984769 2021-07-12 00:00:00 25 891 44041607375 ```