Clickhouse: How to pretty print a generated RowBinary file?

[q0987]

Hello all,

Given a valid ClickHouse RowBinary file, how I can prettyprint the row data within the file?

Thank you

[alexey-milovidov]

Sure! It's very easy to do with clickhouse-local:

clickhouse-local --structure "x UInt8, y String, ..." --query "SELECT * FROM table" --input-format RowBinary --output-format TSV < file

You have to know correct data structure (--structure parameter).

You can use clickhouse-local tool for converting between various formats and for data processing without a server.

[alexey-milovidov]

If you want prettyprint, use --output-format Pretty.

[q0987]

It works for me.

Thank you!