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.5kSign 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: VrfRoU8sGyw
ClickHouse, ClickHouse Cloud

Introdução ao ClickHouse: Análises em Real-Time em Larga Escala

Aprenda sobre o ClickHouse, um banco de dados colunar open-source construído para analytics em tempo real em escala, neste webinar sob demanda cobrindo opções de deployment e aplicações de IA/ML.

YouTube Video: QvKj8-gtP1Q
ClickHouse, ClickHouse Cloud

Cyber in Real Time: How Seemplicity & Reco Supercharged Their Security Analytics

Watch a live webinar with Seemplicity & Reco on building the future of cybersecurity with ClickHouse.

YouTube Video: UAgYxbqz6XI
ClickHouse Cloud, ClickHouse

Milliseconds Matter: Best Practices for Real-Time Analytics

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

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