Clear schema cache for streaming ingestion
Cluster nodes cache schema of the databases that receive data via streaming ingestion. This process optimizes performance and utilization of cluster resources, but can cause propagation delays when the schema change. Clear the cache to guarantee that subsequent streaming ingestion requests incorporate database or table schema changes. For more information, see Streaming ingestion and schema changes.
Clear schema cache
The .clear cache streamingingestion schema command flushes cached schema from all cluster nodes.
Syntax
.clear table <table name> cache streamingingestion schema
.clear database cache streamingingestion schema
Returns
This command returns a table with the following columns:
| Column | Type | Description |
|---|---|---|
| NodeId | string |
Identifier of the cluster node |
| Status | string |
Succeeded/Failed |
Example
.clear database cache streamingingestion schema
.show table T1 cache streamingingestion schema
| NodeId | Status |
|---|---|
| Node1 | Succeeded |
| Node2 | Failed |
Note
If the command fails or one of the rows in the returned table contains Status=Failed the command can be safely retried.