Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs

stream_like_* session settings

These settings are available in system.settings and are autogenerated from source.

stream_like_engine_allow_direct_select

Type
Bool
Default
0
Version history
VersionDefault valueComment
21.120Do not allow direct select for Kafka/RabbitMQ/FileLog by default

Allow direct SELECT query for Kafka, RabbitMQ, FileLog, Redis Streams, S3Queue, AzureQueue and NATS engines. In case there are attached materialized views, SELECT query is not allowed even if this setting is enabled. If there are no attached materialized views, enabling this setting allows to read data. Be aware that usually the read data is removed from the queue. In order to avoid removing read data the related engine settings should be configured properly.

stream_like_engine_insert_queue

When stream-like engine reads from multiple queues, the user will need to select one queue to insert into when writing. Used by Redis Streams and NATS.

Navigation