Skip to content

Latest commit

 

History

History
111 lines (81 loc) · 1.76 KB

use-s3-select.adoc

File metadata and controls

111 lines (81 loc) · 1.76 KB
Raw
permalink sidebar keywords summary
s3/use-s3-select.html
sidebar
use S3 Select, S3 Select
StorageGRID supports the following AWS S3 Select clauses, data types, operators, and reserved keywords for the SELECT Object content command.

Use S3 Select

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