Refresh

    CrateDB is . Data written with a former statement is not guaranteed to be fetched with the next following select statement for the affected rows.

    A table is refreshed periodically with a specified refresh interval. By default, the refresh interval is set to 1000 milliseconds. The refresh interval of a table can be changed with the table parameter (see refresh_interval).

    See also

    If needed, multiple tables can be defined comma-separated in a single SQL request. This ensures that they all get refreshed and so their datasets get consistent. The result message is printed if the request on every given table is completed.

    If one or more tables or partitions do not exist, none of the given tables/partitions are refreshed and an error is returned. The error returns only the first non-existent table/partition.

    Additionally it is possible to define a specific of a partitioned table which should be refreshed (see Partitioned tables).

    By using the clause in the refresh statement a separate request for a given partition can be performed. That means that only specific partitions of a partitioned table are refreshed. For further details on how to create a refresh request on partitioned tables see the SQL syntax and its synopsis (see ).

    In case the clause is omitted all partitions will be refreshed. If a table has many partitions this should be avoided due to performance reasons.