Release Notes
- v2.5
- v2.4
- v2.3
- v2.2
- v2.1
- v2.0
- v1.19

StarRocks
Introduction to StarRocks
Quick Start
Table Design
Data Loading
Data Unloading
Query Data Sources
- Use catalogs to manage internal and external data
- External tables
Query Acceleration
Administration
- Deployment
- Management
- Data Recovery
  - Data recovery
  - Restore FEs
- User Privilege and Authentication
  - User privilege
  - Authentication
- Performance Tuning
Reference
- SQL Reference
- Function Reference
  - Java UDFs
  - Window functions
  - Aggregate Functions
  - Array Functions
  - Bit Functions
  - Bitmap Functions
  - Conditional Functions
  - Cryptographic Functions
  - Date Functions
  - Geographic Functions
  - JSON Functions
    - Overview of JSON functions and operators
    - JSON operators
    - JSON constructor functions
    - JSON query and processing functions
  - Math Functions
    - abs
    - acos
    - asin
    - atan
    - atan2
    - bin
    - ceil
    - ceiling
    - conv
    - cos
    - cosh
    - cot
    - degrees
    - divide
    - e
    - exp
    - floor
    - fmod
    - greatest
    - least
    - ln
    - log
    - log2
    - log10
    - mod
    - multiply
    - negative
    - pi
    - pmod
    - positive
    - pow
    - radians
    - rand
    - round
    - sign
    - sin
    - sinh
    - sqrt
    - square
    - tan
    - tanh
    - truncate
  - String Functions
  - Pattern Matching Functions
  - Percentile Functions
  - Scalar Functions
    - hll_cardinality
  - Utility Functions
  - cast function
  - hash function
- System variables
- Error code
- System limits
FAQ
- Deploy
- Data Migration
  - Data Loading
  - Data Unloading
- SQL
- Other FAQs
Benchmark
- SSB Benchmark
- TPC-H Benchmark

Developers
- Contribute to StarRocks
- Code Style Guides
  - protobuf style guides
  - thrift style guides
- Use the debuginfo file for debugging
- Development Environment
- Trace Tools
  - Trace
Integration
- Integrate with StarRocks
- Authenticate to AWS resources

Edit

array_sum

Description

Sums all values in an array.

Syntax

array_sum(array(type))

Examples

mysql> select array_sum([11, 11, 12]);
+-----------------------+
| array_sum([11,11,12]) |
+-----------------------+
| 34                    |
+-----------------------+

mysql> select array_sum([11.33, 11.11, 12.324]);
+---------------------------------+
| array_sum([11.33,11.11,12.324]) |
+---------------------------------+
| 34.764                          |
+---------------------------------+

Edit

In this article

array_sum