# SQL selects retrieve partial data
**URL:** https://community.cratedb.com/t/sql-selects-retrieve-partial-data/1488
**Category:** CrateDB
**Tags:** sql
**Created:** [May 23, 2023, 11:16am UTC](https://community.cratedb.com/t/sql-selects-retrieve-partial-data/1488 "2023-05-23T11:16:19Z")
**Posts on this page:** 1
**Showing post:** 2
### Author:  [@amotl](https://community.cratedb.com/u/amotl)
#### Post date: [May 23, 2023, 12:04pm UTC](https://community.cratedb.com/t/sql-selects-retrieve-partial-data/1488/2 "2023-05-23T12:04:57Z")
Dear Felipe,
thank you for writing in. Let me start by citing our documentation on this topic, where I believe you are observing the corresponding behaviour, when quickly querying the table directly after inserting.
> [@](#):
>
> CrateDB is [eventually consistent](https://en.wikipedia.org/wiki/Eventual_consistency). Data written with a former statement is not guaranteed to be fetched with the next following select statement for the affected rows.
>
> If required, one or more tables can be refreshed explicitly in order to ensure that the latest state of the table gets fetched, i.e. to synchronize data, using the `REFRESH TABLE ` SQL statement.
>
> – [Refresh — CrateDB: Reference](https://crate.io/docs/crate/reference/en/latest/general/dql/refresh.html)
> – [https://crate.io/docs/crate/reference/en/latest/sql/statements/refresh.html](https://crate.io/docs/crate/reference/en/latest/sql/statements/refresh.html)
By default, the table-level setting [`refresh_interval`](https://crate.io/docs/crate/reference/en/latest/sql/statements/create-table.html#refresh-interval) is set to 1000ms, but that setting can be changed to fit your needs.
Other than the documentation, @proddata also shared a good explanation at [CrateDB need timeout to see changes from insert/update/delete queries](https://community.cratedb.com/t/cratedb-need-timeout-to-see-changes-from-insert-update-delete-queries/726), which may be useful.
Please let us know if this helps already, or if you think you are observing a different issue.
With kind regards,
Andreas.
---
_[View the full topic](https://community.cratedb.com/t/sql-selects-retrieve-partial-data/1488)._