LogoLogo
search
Ctrlk
Homechevron-downProductsDownload Community Edition
  • sidebarLenses DevX
  • plugKafka Connectors
  • right-leftKafka to Kafka Replicator
  • brain-circuitMCPs
  • terminalAPI Reference
GitBook Assistant
GitBook Assistant
Working...Thinking...
GitBook Assistant
Good evening

I'm here to help you with the docs.

Ctrli
AI Based on your contextquestion-circle
LogoLogo
  • Overview
  • Learn
  • What’s New?
  • Getting Started
    • Quick Start
    • Connecting Lenses to your environment
  • Deployment
    • Installation
    • Configuration
  • User Guide
    • Topics
    • Schemas
    • Connectors
    • Monitoring & Alerting
    • Self Service & Governance
    • Lenses SQL
      • SQL Studio
      • SQL Processors
      • SQL Reference
        • Expressions
        • Functions
          • Aggregate
            • AVG
            • BOTTOMK
            • COLLECT
            • COLLECT_UNIQUE
            • COUNT
            • FIRST
            • LAST
            • MAXK
            • MAXK_UNIQUE
            • MINK
            • MINK_UNIQUE
            • SUM
            • TOPK
          • Array
          • Conditions
          • Conversion
          • Date & Time
          • Headers
          • JSON
          • Numeric
          • Nulls
          • Obfuscation
          • Offsets
          • Schema
          • String
          • User Defined Functions
          • User Defined Aggregate Functions
        • Deserializers
        • Supported data formats
    • Topology
    • License
    • CLI
  • Resources
    • Support & Community
    • Tutorials
    • Downloads
    • API Reference
gitbookPowered by GitBook
block-quoteOn this pagechevron-down
  1. User Guidechevron-right
  2. Lenses SQLchevron-right
  3. SQL Referencechevron-right
  4. Functions

Aggregate

This section describes how to use AGGREGATE functions in Lenses SQL.

AVGchevron-rightBOTTOMKchevron-rightCOLLECTchevron-rightCOLLECT_UNIQUEchevron-rightCOUNTchevron-rightFIRSTchevron-rightLASTchevron-rightMAXKchevron-rightMAXK_UNIQUEchevron-rightMINKchevron-rightMINK_UNIQUEchevron-rightSUMchevron-rightTOPKchevron-right
PreviousFunctionschevron-leftNextAVGchevron-right

Last updated 1 year ago

Was this helpful?

LogoLogo

Resources

  • Privacy
  • Cookies
  • Terms & Conditions
  • Community EULA

2024 © Lenses.io Ltd. Apache, Apache Kafka, Kafka and associated open source project names are trademarks of the Apache Software Foundation.

Was this helpful?