Loop

View as MarkdownEdit this pageReport an issueSet up docs MCP

Autogenerated from ClickHouse system tables

Reads from an inner table or table function repeatedly, returning its rows in an infinite loop. It is the backing engine for the loop table function and is mainly useful for testing and generating continuous streams of data.

Syntax

SELECT * FROM loop(database, table)