clickhouseExport table to CSV file
clickhouse-client --query "SELECT * from tbl" --format CSV > file.csvctrl + ctblname of the table to export data from | --format CSVspecify CSV format for export |
file.csvfile to save CSV data to | |
More of Clickhouse
- Using temporary table in query
- Parse string with date/time to DateTime format
- String concat
- Using boolean values
- Convert array to string
- How to change column type
- Using variables in queries
- Insert array of strings in CSV format
- How to select data from Buffer table
- Select rows with any of specified values in array column
See more codes...