Use S3 Select

Contributors netapp-lhalbert

StorageGRID supports the following AWS S3 Select clauses, data types, and operators for the SelectObjectContent command.

Note Any items not listed are not 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 AWS 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