TPC-H test

[Radek Tomšej]

Hi,

thank you for this awesome database. Currently I am trying to benchmark it to Oracle and some other databases. I want to use TPC-H test. Unfortunately TPC-H can generate only csv delimited by | (pipe) and CSV format in ClickHouse only supports , (comma). Is there any easy solution how to import data for TPC-H and make data loading comparable to other solutions?

Thank you!

[man...@gmail.com]

Hi.

You could try one of the following solutions:
1. Edit source code of TPC-H generator programs, replace pipe with comma and recompile them.
2. Generate data and then prepare it, changing pipe to comma using tr/sed/perl.

BTW, I have not yet tried to load TPC-H data.

[va...@percona.com]

Hi,

Speaking about TPC-H, what table structure and table engine is recommended for running this benchmark in ClichHouse.

If we look at TPC-H schema https://docs.snowflake.net/manuals/user-guide/sample-data-tpch.html

there is often no Date column available, so MergeTree can't be used.

Any advises?

[man...@gmail.com]

You could use MergeTree table engine even if your data doesn't have date column.

Just declare additional dummy column as
date Date DEFAULT '2000-01-01'.

This dummy date column will not affect performance of queries.

Usually, MergeTree engine is the most efficient.
Also you could try Log engine - simple table engine without support for indexes, MVCC and so on.