INTO OUTFILE Clause

Add the INTO OUTFILE filename clause (where filename is a string literal) to SELECT query to redirect its output to the specified file on the client-side.

Implementation Details

• This functionality is available in the command-line client and clickhouse-local. Thus a query sent via HTTP interface will fail.
• The query will fail if a file with the same filename already exists.
• The default output format is TabSeparated (like in the command-line client batch mode).