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 night

I'm here to help you with the docs.

Ctrli
AI Based on your contextquestion-circle
  • Overview
  • What's New?chevron-right
  • Getting Started
    • Setting Up Community Editionchevron-right
    • Connecting Lenses to your Kafka environmentchevron-right
  • Deployment
    • Installationchevron-right
    • Configurationchevron-right
    • Upgrade to Lenses 6.1chevron-right
  • User Guide
    • Environments
    • Lenses Resource Names (LRNs)
    • Identity & Access Managementchevron-right
    • Topicschevron-right
    • SQL Studiochevron-right
    • Applicationschevron-right
    • Schemas
    • Monitoring & Alertingchevron-right
    • Self Service & Governancechevron-right
    • Topology
    • Tutorialschevron-right
    • SQL Referencechevron-right
      • Expressions
      • Functionschevron-right
        • Aggregatechevron-right
          • AVG
          • BOTTOMK
          • COLLECT
          • COLLECT_UNIQUE
          • COUNT
          • FIRST
          • LAST
          • MAXK
          • MAXK_UNIQUE
          • MINK
          • MINK_UNIQUE
          • SUM
          • TOPK
        • Arraychevron-right
        • Conditions
        • Conversion
        • Date & Timechevron-right
        • Headerschevron-right
        • JSONchevron-right
        • Numericchevron-right
        • Nullschevron-right
        • Obfuscationchevron-right
        • Offsets
        • Schemachevron-right
        • Stringchevron-right
        • User Defined Functions
        • User Defined Aggregate Functions
      • Deserializers
      • Supported data formatschevron-right
  • 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 2 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?