command = "clickhouse-client -h {} -d {} -u {} --password {} --query \"insert into {} FORMAT CSV\" --max_insert_block_size=100000 < {}".format(
"127.0.0.1", "optimizedb", "default", "密码", "opt2", db_path)
command2 = "clickhouse-client -h {} -d {} -u {} --password {} --query \"OPTIMIZE TABLE {} FINAL\"".format(
"127.0.0.1", "optimizedb", "default", "密码", "opt2")
os.system(command)
os.system(command2)