clickhouse-备份表结构

clickhouse导出表结构

#!/bin/bash

OUTDIR=/root/backup/
 
clickhouse-client  -q "SHOW DATABASES" > /root/backup/db.txt
while read -r db 
do
        clickhouse-client -q "SHOW TABLES FROM $db" > /root/backup/table.txt
        
        while read -r table  
        do
                if [ "$db" == "system" ]; then
                　　echo "skip system db"
                　　continue 2;
                fi
 
                if [[ "$table" == ".inner."* ]]; then
                　　echo "skip materialized view $table ($db)"
                　　continue;
                fi
 
                echo "export table $table from database $db"
 
                # dump schema
                clickhouse-client -q "SHOW CREATE TABLE ${db}.${table} format CSV" >> "${OUTDIR}/schema.sql"
 
 　　　　done  < `ls /root/backup/table.txt`

done  < `ls /root/backup/db.txt`