ClickHouse logo
  • English
  • Japanese
  • Products
    • ClickHouse CloudClickHouse Cloud
      The best way to use ClickHouse.
      Available on AWS, GCP, and Azure.
    • ClickHouse BYOCBring Your Own Cloud
      A fully managed ClickHouse Cloud service,
      deployed in your own AWS account.
    • ClickHouseClickHouse
      Spin up a database with open-
      source ClickHouse.
    • chDBView 100+ integrations
    View 100+ integrations ->->
  • Use cases
    • Real-time analytics
    • Machine learning and GenAI
    • Data warehousing
    • Observability
    • All use cases
    All use cases ->->
  • Docs
  • Resources
    • User stories
    • Blog
    • Events
    • News
    • Learning and certification
    • Comparisons
      • BigQuery
      • PostgreSQL
      • Redshift
      • Snowflake
    • Videos
    • Demos
  • Pricing
  • Contact us
  • English
  • Japanese
42.2kSign in

Videos / ClickHouse

A function that runs queries in an infinite loop

Mark Needham Product Marketing Engineer

In this video, we will learn about the loop function, which runs queries in an infinite loop. It sounds strange, but is useful!

https://clickhouse.com/docs/en/sql-reference/table-functions/loop

Recent videos

YouTube Video: UAgYxbqz6XIYouTube Video: UAgYxbqz6XI
ClickHouse Cloud, ClickHouse

Milliseconds Matter: Best Practices for Real-Time Analytics

Learn best practices for architecting scalable, low-latency analytics with ClickHouse.

YouTube Video: y9biAm_FkqwYouTube Video: y9biAm_Fkqw
ClickHouse

The ClickHouse MCP Server

Mark Needham

YouTube Video: mJCo_wszNicYouTube Video: mJCo_wszNic
ClickHouse

The ClickHouse monitoring dashboard

Mark Needham, Product Marketing Engineer

Follow us
X imageBluesky imageSlack image
GitHub imageTelegram imageMeetup image
Rss image

Products

  • ClickHouse Cloud
  • ClickHouse
  • Bring Your Own Cloud
  • ClickHouse Government
  • ClickHouse Keeper
  • ClickStack
  • ClickPipes
  • Integrations
  • chDB
  • Trust center
  • Pricing

Resources

  • Documentation
  • Training
  • Support
  • Benchmarks
  • Use cases
  • Videos
  • Demos
  • Real-time data warehouse
  • Open House videos

Company

  • Blog
  • Our story
  • Careers
  • Contact us
  • Events
  • News
  • Media

Join our community

  • GitHub
  • Slack
  • LinkedIn
  • X
  • Bluesky
  • Telegram
  • Meetup

Comparisons

  • BigQuery
  • PostgreSQL
  • Redshift
  • Snowflake
  • Partners

  • AWS
  • Azure
ClickHouse logo
Stay informed on feature releases, product roadmap, support, and cloud offerings!
Loading form...
© 2025 ClickHouse, Inc. HQ in the Bay Area, CA and Amsterdam, NL.
TrademarkPrivacySecurityLegalCookie policy