Dear Hugh,
thank you for writing in.
If you want to flush manually, instantly and purposely, you will need to invoke the REFRESH TABLE statement to synchronize writes, because of CrateDB’s eventual consistency properties. However, data also converges automatically after one second by default, see below.
REFRESH TABLE crate.temp;
That’s correct. By default, data automatically converges after 1000ms, but you can also adjust that on behalf of the refresh_interval table setting, to match your needs.
@hammerhead and @proddata also shared excellent details about this topic over here, including relevant pointers to the reference documentation. Enjoy reading, and don’t hesitate to come back with relevant questions.
- Fundamentals of eventual consistency in CrateDB
- CrateDB need timeout to see changes from insert/update/delete queries
- It takes longer to count tables where data is being inserted
- SQL selects retrieve partial data
With kind regards,
Andreas.