Note: | This block supports many, but not all, aspects of RAQL. You cannot load data from a file, use snapshots as a dataset or load datasets from the Presto Analytics In-Memory Stores. See the From property (below) for more information on the types of datasets and access mechanisms that you can use with this block. |
Select | Use this property to define column selections and optional partition or windows in the Select and Over clauses for a RAQL query. You can also apply analytic functions in the Select clause if the query includes an Over or Group By clause. See Select Techniques and Over Techniques for a list of syntax options. See Built-In
RAQL
Functions for information on the built-in RAQL functions. Or click ![]() |
From | This clause is automatically completed when you connect the results of another block as the dataset input for ![]() ![]() ![]() ![]() ![]() ![]() In addition, the results that you connect as input must be a complex document with repeating items that fit the RAQL data model. See Structure, Format and Access to Datasets with
RAQL for more information. |
Where | Use this property to define filter conditions in a Where clause for a RAQL query. See Where Techniques for a list of syntax options. See Built-In
RAQL
Functions for information on the built-in RAQL functions. Or click ![]() |
Order By | Use this property to define sort criteria in an Order By clause for a RAQL query. See Order By Techniques for a list of syntax options. See Built-In
RAQL
Functions for information on the built-in RAQL functions. Or click ![]() |
Group By | Use this property to define grouping and aggregation criteria in a Group By clause for a RAQL query. See Group By Techniques for a list of syntax options. See Built-In
RAQL
Functions for information on the built-in RAQL functions. Or click ![]() |