Dell ObjectScale 1.3 Administration Guide

S3 API

See the ObjectScale Rest API .zip file on Dell Support at https://www.dell.com/support/home/en-us/product-support/product/objectscale/docs for a complete list of the supported S3 APIs.

S3 Select

ObjectScale supports S3 Select. See https://docs.aws.amazon.com/AmazonS3/latest/userguide/s3-glacier-select-sql-reference-select.html for details on the S3 Select usages supported on ObjectScale.

The S3 Select API allows applications to retrieve a subset of data of an object by using SQL expressions. S3 Select saves on both the bandwidth and client-side processing. For example, without S3 Select applications must download the entire object and then do the processing on that data. With S3 Select, an application instead issues a SQL select command and gets only a small subset of the object data. Further, an application does not have to do any additional processing.

S3 Select can be used for objects in the following formats:

• CVS
• Json
• Parquet

S3 Select supports querying gzip and bzip2 compressed objects of the above file types.

You can use S3 Select API on its own or with a query engine, like presto. A connector in presto can determine if a particular query can be sent directly to the storage, for example s3 select pushdown.