ClickHouse announces Series C extension and key leadership hires ->->
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 service,
      deployed in your own AWS and GCP account.
    • ClickHouseClickHouse
      Spin up a database with open-
      source ClickHouse.
    • chDBView 100+ integrations
    View 100+ integrations ->->
  • Solutions

    Use cases

    • Real-time analytics
    • Machine learning and GenAI
    • Data warehousing
    • Observability
    • All use cases
    All use cases ->->

    Industries

    • Cybersecurity
    • Gaming and entertainment
    • E-commerce and retail
    • Automotive
    • Energy
    • All industries
    All industries ->->
  • Docs
  • Resources
    • User stories
    • Blog
    • Events
    • News
    • Learning and certification
    • Comparisons
      • BigQuery
      • PostgreSQL
      • Redshift
      • Snowflake
      • Elastic For observability
    • Videos
    • Demos
  • Pricing
  • Contact us
  • English
  • Japanese
43.7kSign in
  • Videos
  • /
  • ClickHouse

Deriving columns from other columns

Mark Needham Product Marketing Engineer, ClickHouse

In this video, we're going to learn how to use the DEFAULT, MATERIALIZED, and ALIAS modifiers to derive the value of one column from another one.

Recent videos

YouTube Video: dvq14Fjcvko
ClickHouse

Moderniser l’observabilité avec ClickStack : simplifier, accélérer, innover

L’observabilité n’a jamais été aussi critique… ni aussi complexe. Êtes-vous prêt à transformer votre manière de gérer la complexité des systèmes distribués ? Découvrez comment ClickHouse révolutionne l’observabilité moderne en combinant rapidité, efficacité et ouverture.

YouTube Video: gozW72845XM
ClickHouse, ClickHouse Cloud

Apresentando o ClickStack: O Futuro da Observabilidade com ClickHouse

Descubra como o ClickStack — com ClickHouse, HyperDX e OpenTelemetry — transforma a observabilidade ao unificar logs, métricas e traces em uma única plataforma open-source.

YouTube Video: UfOZoYH-_1E
ClickHouse

Introducing ClickStack: Live Demo & Q&A - APJ

Mike Shi, Principal Product Manager @ 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
  • Engineering resources

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
  • Elastic
  • 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