Does ClickHouse support multiple insert simultaneously?

108 views
Skip to first unread message

clickhouse0987654321

unread,
Aug 17, 2018, 9:06:47 AM8/17/18
to ClickHouse
Hello,

I would like to know whether I can insert data into different tables simultaneously.

For example,

Can I run the following two statements at the same time?

Thank you
-Danyu

xz -v -c -d < ontime01.csv.xz | clickhouse-client --query="INSERT INTO ontime01 FORMAT CSV"

xz -v -c -d < ontime02.csv.xz | clickhouse-client --query="INSERT INTO ontime02 FORMAT CSV"

tatiana....@revjet.com

unread,
Aug 17, 2018, 11:02:06 AM8/17/18
to ClickHouse
Yes, if the table's engine is *MergeTree

tatiana....@revjet.com

unread,
Aug 17, 2018, 11:07:24 AM8/17/18
to ClickHouse
Actually I was answering the question "can I insert data into THE SAME table simultaneously".
Reply all
Reply to author
Forward
0 new messages