Member since
08-15-2014
1
Post
0
Kudos Received
0
Solutions
08-15-2014
12:13 PM
Hi, The issuing a REFRESH will broadcast the updated table to all nodes. There may be a short delay after the command completes before the changes are visible on remote nodes. This is because we must wait for a statestore update to propagate the changes out. If you need stronger consistency guarantees (the change is visible on all nodes at the time it completes) you can use the query option: SET SYNC_DDL=true This will impact DDL performance, so it is disabled by default. For optimal performance, you can batch your DDL statements and only enable this query option for the final statement in the batch. For example: > connect to node 1 CREATE TABLE Foo ALTER TABLE ADD PARTITION 1 .. SET SYNC_DDL=true ALTER TABLE ADD PARTITION N > connect to node2 SELECT * FROM TABLE Thanks, Lenni
... View more