Clearing cached schema for streaming ingestion

This article describes management command for clearing cached database schema.

Nodes cache schema of the databases that receive data via streaming ingestion. This process optimizes performance and utilization of 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.

Permissions

You must have at least Database Ingestor permissions to run this command.

Syntax

.clear table TableName cache streamingingestion schema

.clear database cache streamingingestion schema

Parameters

NameTypeRequiredDescription
TableNamestring✔️The name of the table for which to clear the cache.

Returns

This command returns a table with the following columns:

ColumnTypeDescription
NodeIdstringIdentifier of the node
StatusstringSucceeded/Failed

Example

.clear database cache streamingingestion schema

.clear table T1 cache streamingingestion schema
NodeIdStatus
Node1Succeeded
Node2Failed