SYSTEM Statements

```
SYSTEM WAIT VIEW [db.]name
```

### SYSTEM CANCEL VIEW[​](#cancel-view "Direct link to SYSTEM CANCEL VIEW")

If there's a refresh in progress for the given view on the current replica, interrupt and cancel it. Otherwise do nothing.

```
SYSTEM CANCEL VIEW [db.]name
```

## SYSTEM FLUSH OBJECT STORAGE QUEUE[​](#flush-object-storage-queue "Direct link to SYSTEM FLUSH OBJECT STORAGE QUEUE")

Blocks until the given file has been processed or permanently failed by the given [S3Queue](/docs/engines/table-engines/integrations/s3queue) or [AzureQueue](/docs/engines/table-engines/integrations/azure-queue) table. Returns immediately if the file was already processed. Raises an error if the file has permanently failed (all retries exhausted).

```
SYSTEM FLUSH OBJECT STORAGE QUEUE [db.]table_name PATH 'path'
```

- [SYSTEM RELOAD EMBEDDED DICTIONARIES](#reload-embedded-dictionaries)- [SYSTEM RELOAD DICTIONARIES](#reload-dictionaries)- [SYSTEM RELOAD DICTIONARY](#reload-dictionary)- [SYSTEM RELOAD MODELS](#reload-models)- [SYSTEM RELOAD MODEL](#reload-model)- [SYSTEM RELOAD FUNCTIONS](#reload-functions)- [SYSTEM RELOAD ASYNCHRONOUS METRICS](#reload-asynchronous-metrics)- [SYSTEM CLEAR|DROP DNS CACHE](#drop-dns-cache)- [SYSTEM CLEAR|DROP MARK CACHE](#drop-mark-cache)- [SYSTEM CLEAR|DROP ICEBERG METADATA CACHE](#drop-iceberg-metadata-cache)- [SYSTEM DROP PARQUET METADATA CACHE](#drop-parquet-metadata-cache)- [SYSTEM CLEAR|DROP TEXT INDEX CACHES](#drop-text-index-caches)- [SYSTEM DROP REPLICA](#drop-replica)- [SYSTEM DROP DATABASE REPLICA](#drop-database-replica)- [SYSTEM CLEAR|DROP UNCOMPRESSED CACHE](#drop-uncompressed-cache)- [SYSTEM CLEAR|DROP COMPILED EXPRESSION CACHE](#drop-compiled-expression-cache)- [SYSTEM CLEAR|DROP QUERY CONDITION CACHE](#drop-query-condition-cache)- [SYSTEM CLEAR|DROP QUERY CACHE](#drop-query-cache)- [SYSTEM CLEAR|DROP FORMAT SCHEMA CACHE](#system-drop-schema-format)- [SYSTEM FLUSH LOGS](#flush-logs)- [SYSTEM RELOAD CONFIG](#reload-config)- [SYSTEM RELOAD USERS](#reload-users)- [SYSTEM SHUTDOWN](#shutdown)- [SYSTEM KILL](#kill)- [SYSTEM INSTRUMENT](#instrument)
                                                  - [SYSTEM INSTRUMENT ADD](#instrument-add)- [SYSTEM INSTRUMENT REMOVE](#instrument-remove)- [Managing Distributed Tables](#managing-distributed-tables)
                                                    - [SYSTEM STOP DISTRIBUTED SENDS](#stop-distributed-sends)- [SYSTEM FLUSH DISTRIBUTED](#flush-distributed)- [SYSTEM START DISTRIBUTED SENDS](#start-distributed-sends)- [SYSTEM STOP LISTEN](#stop-listen)- [SYSTEM START LISTEN](#start-listen)- [Managing MergeTree Tables](#managing-mergetree-tables)
                                                      - [SYSTEM STOP MERGES](#stop-merges)- [SYSTEM START MERGES](#start-merges)- [SYSTEM STOP TTL MERGES](#stop-ttl-merges)- [SYSTEM START TTL MERGES](#start-ttl-merges)- [SYSTEM STOP MOVES](#stop-moves)- [SYSTEM START MOVES](#start-moves)- [SYSTEM SYSTEM UNFREEZE](#query_language-system-unfreeze)- [SYSTEM WAIT LOADING PARTS](#wait-loading-parts)- [Managing ReplicatedMergeTree Tables](#managing-replicatedmergetree-tables)
                                                        - [SYSTEM STOP FETCHES](#stop-fetches)- [SYSTEM START FETCHES](#start-fetches)- [SYSTEM STOP REPLICATED SENDS](#stop-replicated-sends)- [SYSTEM START REPLICATED SENDS](#start-replicated-sends)- [SYSTEM STOP REPLICATION QUEUES](#stop-replication-queues)- [SYSTEM START REPLICATION QUEUES](#start-replication-queues)- [SYSTEM STOP PULLING REPLICATION LOG](#stop-pulling-replication-log)- [SYSTEM START PULLING REPLICATION LOG](#start-pulling-replication-log)- [SYSTEM SYNC REPLICA](#sync-replica)- [SYNC DATABASE REPLICA](#sync-database-replica)- [SYSTEM RESTART REPLICA](#restart-replica)- [SYSTEM RESTORE REPLICA](#restore-replica)- [SYSTEM RESTORE DATABASE REPLICA](#restore-database-replica)- [SYSTEM RESTART REPLICAS](#restart-replicas)- [SYSTEM CLEAR|DROP FILESYSTEM CACHE](#drop-filesystem-cache)- [SYSTEM SYNC FILE CACHE](#sync-file-cache)- [SYSTEM LOAD PRIMARY KEY](#load-primary-key)- [SYSTEM UNLOAD PRIMARY KEY](#unload-primary-key)- [Managing Refreshable Materialized Views](#managing-refreshable-materialized-views)
                                                          - [SYSTEM STOP [REPLICATED] VIEW, STOP VIEWS](#stop-view-stop-views)- [SYSTEM START [REPLICATED] VIEW, START VIEWS](#start-view-start-views)- [SYSTEM REFRESH VIEW](#refresh-view)- [SYSTEM WAIT VIEW](#wait-view)- [SYSTEM CANCEL VIEW](#cancel-view)- [SYSTEM FLUSH OBJECT STORAGE QUEUE](#flush-object-storage-queue)

Was this page helpful?