Search code examples
clickhouse

Will clickhouse copy new data by using insert+select?


Will ClickHouse copy data by insert into ... select which added when operation already in progress?

PS^ I know it has to do with the level of isolation, but there are a lot of unclear points for ClickHouse.


Solution

  • No, clickhouse will only copy data which is present at the start of the execution of the INSERT ... SELECT ... query.