TRUNCATE TABLE Operation timed out

ClickHouse / clickhouse-cpp

C++ client library for ClickHouse

Apache License 2.0

306 stars 159 forks source link

TRUNCATE TABLE Operation timed out #306

Closed giosh04 closed 1 year ago

giosh04 commented 1 year ago

Hello! When i do loop with two queries

client->Execute("INSERT INTO FUNCTION remote('"+remote_db_host+"',"+remote_db_name+","+table+",'"+remote_db_user+"','"+remote_db_pass+"',rand()) SELECT * from "+db_name+"."+table); client->Execute("TRUNCATE TABLE " + table);

On second loop I get "closed: Operation timed out"

Can you please help me to solve it?

Enmk commented 1 year ago

Hi @giosh04 could you please share what was the problem and how did you solved it?