ClickHouse v20.10 Documentation
首页 白天 夜间 下载 阅读记录
  • 书签 我的书签
  • 添加书签 添加书签 移除书签 移除书签
编辑文档

SimpleAggregateFunction

来源 1 浏览 868 扫码 打印 2020-10-28 08:08:26

    SimpleAggregateFunction

    The following aggregate functions are supported:

    • any
    • sumWithOverflow
    • groupBitOr
    • groupUniqArrayArray
    • minMap

    Parameters

    • Types of the aggregate function arguments.

    Original article

    上一篇:
    下一篇:
    • 书签
    • 添加书签 移除书签
    • Introduction
      • Adopters
      • Information support
      • Overview
      • Distinctive Features
      • Performance
      • History
    • F.A.Q.
      • General
      • Integration
      • Use Cases
      • Operations
    • What’s New
      • What’s New in ClickHouse?
      • Changelog
        • Security Changelog
        • Roadmap
        • 2020
          • 2017
          • 2018
          • 2019
    • Getting Started
      • Tutorial
      • Installation
      • Example Datasets
        • Playground
        • Introduction
          • Star Schema Benchmark
          • Yandex.Metrica Data
          • Terabyte Click Logs from Criteo
          • New York Taxi Data
          • OnTime
          • AMPLab Big Data Benchmark
          • WikiStat
    • Interfaces
      • Introduction
        • Input and Output Formats
        • Command-Line Client
        • HTTP Interface
        • C++ Client Library
        • JDBC Driver
        • ODBC Driver
        • Native Interface (TCP)
        • MySQL Interface
      • Third-Party
        • Third-Party Interfaces
          • Client Libraries
          • Integrations
          • Visual Interfaces
          • Proxies
    • Engines
      • Table Engines
        • Introduction
        • MergeTree Family
          • Introduction
            • VersionedCollapsingMergeTree
            • Custom Partitioning Key
            • AggregatingMergeTree
            • Data Replication
            • SummingMergeTree
            • MergeTree
            • CollapsingMergeTree
            • GraphiteMergeTree
            • ReplacingMergeTree
        • Log Family
          • Introduction
            • TinyLog
            • StripeLog
            • Log
          • Table Engines for Integrations
          • Integrations
            • JDBC
            • HDFS
            • MySQL
            • RabbitMQ
            • Kafka
            • ODBC
        • Special
          • Special Table Engines
            • Merge
            • Dictionary
            • External Data
            • Buffer
            • Memory
            • MaterializedView
            • URL
            • View
            • Set
            • Join
            • File
            • Distributed
            • GenerateRandom
            • Null
      • Database Engines
        • Introduction
          • Lazy
          • MySQL
    • SQL Reference
      • Operators
        • Operators
          • IN Operators
        • ANSI Compatibility
      • Statements
        • Syntax
        • Distributed DDL
        • SELECT
          • Overview
            • WHERE
            • LIMIT
            • PREWHERE
            • GROUP BY
            • WITH
            • FROM
            • UNION ALL
            • INTO OUTFILE
            • LIMIT BY
            • SAMPLE
            • JOIN
            • ORDER BY
            • FORMAT
            • DISTINCT
            • HAVING
            • ARRAY JOIN
          • INSERT INTO
        • CREATE
          • Overview
            • DATABASE
            • VIEW
            • USER
            • DICTIONARY
            • ROLE
            • TABLE
            • ROW POLICY
            • SETTINGS PROFILE
            • QUOTA
        • ALTER
          • CHECK
          • SHOW
          • USE
          • OPTIMIZE
          • REVOKE
          • TRUNCATE
          • DETACH
          • ALTER
            • INDEX
            • SETTINGS PROFILE
            • TTL
            • COLUMN
            • SAMPLE BY
            • QUOTA
            • ROW POLICY
            • ROLE
            • PARTITION
            • DELETE
            • UPDATE
            • USER
            • CONSTRAINT
            • ORDER BY
          • GRANT
          • SET ROLE
          • DROP
          • EXISTS
          • DESCRIBE
          • ATTACH
          • SET
          • RENAME
          • KILL
          • SYSTEM
      • Functions
        • Introduction
          • Splitting and Merging Strings and Arrays
          • Nullable
          • Encoding
          • URLs
          • Hash
          • arrayJoin
          • Other
          • JSON
          • Machine Learning
          • Arrays
          • Dates and Times
          • Type Conversion
          • Pseudo-Random Numbers
          • Bit
          • Strings
          • For Searching in Strings
          • Comparison
          • Logical
          • Introspection
          • Bitmap
          • Working with maps
          • Mathematical
          • External Dictionaries
          • Conditional
          • UUID
          • Arithmetic
          • Yandex.Metrica Dictionaries
          • IP Addresses
          • For Replacing in Strings
          • Rounding
          • IN Operator
          • Geo
            • H3 Indexes
            • Geohash
            • Geographical Coordinates
      • Aggregate Functions
        • Introduction
          • Parametric
          • Combinators
          • Reference
            • categoricalInformationValue
            • any
            • kurtPop
            • argMax
            • timeSeriesGroupSum
            • count
            • groupArrayInsertAt
            • sumWithOverflow
            • uniqCombined64
            • quantileTDigestWeighted
            • sum
            • simpleLinearRegression
            • avgWeighted
            • groupArrayMovingAvg
            • groupBitAnd
            • argMin
            • groupArraySample
            • stochasticLogisticRegression
            • uniq
            • corr
            • stddevSamp
            • groupBitXor
            • quantileDeterministic
            • groupArray
            • min
            • quantileExact
            • uniqHLL12
            • stochasticLinearRegression
            • quantileExactWeighted
            • quantile
            • quantileTDigest
            • groupArrayMovingSum
            • timeSeriesGroupRateSum
            • kurtSamp
            • median
            • minMap
            • covarSamp
            • avg
            • groupBitmapOr
            • covarPop
            • uniqCombined
            • skewPop
            • groupUniqArray
            • varPop(x)
            • varSamp
            • maxMap
            • groupBitmap
            • sumMap
            • groupBitmapXor
            • groupBitOr
            • max
            • quantileTimingWeighted
            • stddevPop
            • quantileTiming
            • topK
            • anyHeavy
            • topKWeighted
            • skewSamp
            • quantiles
            • groupBitmapAnd
            • anyLast
            • uniqExact
      • Table Functions
        • Introduction
          • merge
          • numbers
          • remote
          • file
          • input
          • url
          • cluster
          • odbc
          • jdbc
          • mysql
          • generateRandom
          • view
          • hdfs
      • Dictionaries
        • Introduction
          • Internal Dictionaries
          • External Dictionaries
            • Sources of External Dictionaries
            • Configuring an External Dictionary
            • Hierarchical dictionaries
            • General Description
            • Dictionary Key and Fields
            • Dictionary Updates
            • Storing Dictionaries in Memory
      • Data Types
        • Introduction
          • Array(T)
          • Decimal
          • Tuple(T1, T2, …)
          • Date
          • Boolean
          • AggregateFunction
          • Enum
          • Nullable
          • String
          • DateTime
          • UInt8, UInt16, UInt32, UInt64, UInt256, Int8, Int16, Int32, Int64, Int128, Int256
          • LowCardinality
          • Float32, Float64
          • DateTime64
          • UUID
          • FixedString(N)
          • Nested Data Structures
            • Nested(Name1 Type1, Name2 Type2, …)
          • Special Data Types
            • Interval
            • Expression
            • Set
            • Nothing
        • Domains
          • Overview
            • IPv4
            • IPv6
          • SimpleAggregateFunction
    • Guides
      • Overview
        • Applying CatBoost Models
    • Operations
      • Introduction
        • ClickHouse Update
        • Data Backup
        • Configuration Files
        • Requirements
        • Troubleshooting
        • Monitoring
        • Access Control and Account Management
        • Quotas
        • Optimizing Performance
          • Query Profiling
      • System Tables
        • System Tables
          • system.licenses
          • system.current_roles
          • system.roles
          • system.detached_parts
          • system.numbers_mt
          • system.databases
          • system.role_grants
          • system.row_policies
          • system.enabled_roles
          • system.settings_profiles
          • system.replicas
          • system.quota_usage
          • system.functions
          • system.settings_profile_elements
          • system.grants
          • system.merge_tree_settings
          • system.quota_limits
          • system.trace_log
          • system.events
          • system.storage_policies
          • system.metric_log
          • system.contributors
          • system.numbers
          • system.mutations
          • system.table_engines
          • system.one
          • system.graphite_retentions
          • system.quotas
          • system.time_zones
          • system.processes
          • system.settings
          • system.asynchronous_metric_log
          • system.query_log
          • system.columns
          • system.quotas_usage
          • system.part_log
          • system.metrics
          • system.crash_log
          • system.asynchronous_metrics
          • system.text_log
          • system.disks
          • system.data_type_families
          • system.users
          • system.query_thread_log
          • system.stack_trace
          • system.tables
          • system.zookeeper
          • system.parts
          • system.merges
          • system.dictionaries
          • system.clusters
      • Server Configuration Parameters
        • Testing Hardware
        • Introduction
          • Server Settings
      • Settings
        • Introduction
          • Constraints on Settings
          • Settings
          • Settings Profiles
          • Restrictions on Query Complexity
          • User Settings
          • Permissions for Queries
      • Utilities
        • Usage Recommendations
        • Overview
          • clickhouse-copier
          • clickhouse-local
          • clickhouse-odbc-bridge
          • clickhouse-benchmark
          • ClickHouse obfuscator
          • ClickHouse compressor
        • OpenTelemetry Support
    • Development
      • Third-Party Libraries Used
      • Continuous Integration Checks
      • Build on Linux
      • Source Code Browser
      • Build on Linux for AARCH64 (ARM64)
      • Architecture Overview
      • C++ Guide
      • Build on Mac OS X
      • Testing
      • For Beginners
      • CMake in ClickHouse
      • Build on Linux for Mac OS X
    • Commercial
      • Introduction
        • Cloud
        • Support
    暂无相关搜索结果！

      本文档使用 全库网 构建

      展开/收起文章目录

      思维导图备注

      文章二维码

      手机扫一扫，轻松掌上读

      文档下载

      请下载您需要的格式的文档，随时随地，享受汲取知识的乐趣！
      PDF文档 EPUB文档 MOBI文档

      书签列表

        阅读记录

        阅读进度: 0.00% ( 0/0 ) 重置阅读进度