Software Developer

Delete row from table in clickhouse: :) ALTER TABLE tablename DELETE WHERE condition

Change the name of one column: ALTER TABLE tablename RENAME COLUMN old_name TO new_name Change the names of multiple columns: ALTER TABLE tablename     RENAME COLUMN old_name1 TO new_name1,     RENAME COLUMN old_name2 TO new_name2

Export data from clickhouse into csv file: :) SELECT * FROM table INTO OUTFILE 'file' Import data from csv file: clickhouse-client -q "INSERT INTO database.tablename FORMAT CSV" < tablename.csv

Install command: # pkg install clickhouse Start clickhouse server $ clickhouse server Start clickhouse server without any ouput $ clickhouse server > /dev/null 2>&1 & Start clickhouse client $ clickhouse client