Amazon Simple Storage Service
Developer Guide (API Version 2006-03-01)

Aggregate Functions (Amazon S3 Select only)

Amazon S3 Select supports the following aggregate functions.

Note

Amazon Glacier Select does not support aggregate functions.

Function Argument Type Return Type
AVG(expression) INT, FLOAT, DECIMAL DECIMAL for an INT argument, FLOAT for a floating-point argument; otherwise the same as the argument data type.
COUNT - INT
MAX(expression) INT, DECIMAL Same as the argument type.
MIN(expression) INT, DECIMAL Same as the argument type.
SUM(expression) INT, FLOAT, DOUBLE, DECIMAL INT for INT argument, FLOAT for a floating-point argument; otherwise, the same as the argument data type.