Read data from mysql SQL and insert into clickhouse

gistfile1.txt

SQL=$(cat <<EOF
SELECT 
	id, DATE_FORMAT(created_at, "%Y-%m-%d"),  
	type, user_id, location_id, UNIX_TIMESTAMP(created_at) 
FROM hits
EOF
)
mysql -h source_db_host mydb -BNe "$sql" > hist.txt
cat hist.txt | clickhouse-client -d mydb --query="INSERT INTO hits FORMAT TabSeparated"