Analyze Datasets with RAQL Queries

You can use the

RAQL block to query and analyze large datasets using Presto Analytics and the Real-Time Analytics Query Language (RAQL). RAQL allows you to work with large datasets to perform analysis and combine that with other information or transform it in a mashup.

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 to open the Path Selector list and provide this clause dynamically from an input parameter or other result. See Dynamic RAQL Queries in Wires and Select Fields or Paths for Block Properties with the Path Selector for more information.
From	This clause is automatically completed when you connect the results of another block as the dataset input for RAQL. The results you connect as input determine whether the block uses streaming to load data. Streaming helps performance with large datasets. If you connect: DirectInvoke, the block uses streaming. SQL, the block uses streaming. A mashable, mashup or any other Wires block, this block does not use streaming. 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 to open the Path Selector list and provide this clause dynamically from an input parameter or other result. See Dynamic RAQL Queries in Wires and Select Fields or Paths for Block Properties with the Path Selector for more information.
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 to open the Path Selector list and provide this clause dynamically from an input parameter or other result. See Dynamic RAQL Queries in Wires and Select Fields or Paths for Block Properties with the Path Selector for more information.
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 to open the Path Selector list and provide this clause dynamically from an input parameter or other result. See Select Fields or Paths for Block Properties with the Path Selector for more information.