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
- List all tables from all database
- Using variables in queries
- Create table example
- Get total database size
- Inserting data into table example
- Add row number to results
- Create AggregatingMergeTree materialized view
- How to select based on Tuple element value
- How to execute SQL query from a file
- Select distinct values
See more codes...