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 morning

I'm here to help you with the docs.

⌘Ctrli
AI Based on your contextquestion-circle
LogoLogo
  • Overview
  • What's New?
  • Getting Started
    • Setting Up Community Edition
    • Connecting Lenses to your Kafka environment
  • Deployment
    • Installation
    • Configuration
    • Upgrade to Lenses 6.1
  • User Guide
    • Environments
    • Lenses Resource Names (LRNs)
    • Identity & Access Management
    • Topics
    • SQL Studio
    • Applications
    • Schemas
    • Monitoring & Alerting
    • Self Service & Governance
    • Topology
    • Tutorials
    • 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
  • Resources
    • Downloads
    • CLI
gitbookPowered by GitBook
block-quoteOn this pagechevron-down
  1. User Guidechevron-right
  2. SQL Referencechevron-right
  3. 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 3 months 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?