Use S3 Select
StorageGRID supports the following Amazon S3 Select clauses, data types, and operators for the SelectObjectContent command.
Any items not listed aren't supported. |
For syntax, see SelectObjectContent. For more information about S3 Select, see the AWS documentation for S3 Select.
Only tenant accounts that have S3 Select enabled can issue SelectObjectContent queries. See the considerations and requirements for using S3 Select.
Clauses
-
SELECT list
-
FROM clause
-
WHERE clause
-
LIMIT clause
Data types
-
bool
-
integer
-
string
-
float
-
decimal, numeric
-
timestamp
Operators
Logical operators
-
AND
-
NOT
-
OR
Comparison operators
-
<
-
>
-
<=
-
>=
-
=
-
=
-
<>
-
!=
-
BETWEEN
-
IN
Pattern matching operators
-
LIKE
-
_
-
%
Unitary operators
-
IS NULL
-
IS NOT NULL
Math operators
-
+
-
-
-
*
-
/
-
%
StorageGRID follows the Amazon S3 Select operator precedence.
Aggregate functions
-
AVG()
-
COUNT(*)
-
MAX()
-
MIN()
-
SUM()
Conditional functions
-
CASE
-
COALESCE
-
NULLIF
Conversion functions
-
CAST (for supported datatype)
Date functions
-
DATE_ADD
-
DATE_DIFF
-
EXTRACT
-
TO_STRING
-
TO_TIMESTAMP
-
UTCNOW
String functions
-
CHAR_LENGTH, CHARACTER_LENGTH
-
LOWER
-
SUBSTRING
-
TRIM
-
UPPER