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. 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. |
Where | Use this property to define filter conditions in a Where clause for a RAQL query. Or click ![]() |
Order By | Use this property to define sort criteria in an Order By clause for a RAQL query. Or click ![]() |
Group By | Use this property to define grouping and aggregation criteria in a Group By clause for a RAQL query. Or click ![]() |