sdselect command overview
Note: The
sdselect command will be deprecated in an upcoming release. Use the Convert to SPL2 button to convert existing sdselect searches to SPL2 and use SPL2 for federated searches going forward. For more information, see Run federated searches over remote datasets with SPL2.
Use the sdselect command to run federated searches against Amazon S3 datasets that are referenced by AWS Glue Data Catalog tables.
Syntax
The required syntax is in bold.
| sdselect
[reuse_search_results=<bool>]
( <field-list> | <statistical-function> | <evaluation-function>), ...
FROM <from-dataset> [AS <alias>]
[JOIN <join-dataset> AS <alias> USING <field-list>]
[WHERE <evaluation-expression>]
[GROUPBY ((<field-list> | <evaluation-function>) [AS <alias>]... [span=[<unsigned_integer>]<timescale>])]
[ORDERBY (<field-list> | <evaluation-function>)...]
[LIMIT <unsigned_integer>]