MashZone NextGen
10.2
|
Appendix
|
Legacy Presto components
|
MashZone NextGen Analytics
|
RAQL Queries
RAQL
Queries
Techniques to Load Data
Select Techniques
Over Techniques
From Techniques
Where Techniques
Group By Techniques
Having Techniques
Order By Techniques
Multi-DataSet Operations
Escape Characters for RAQL Queries
Load Data with <sql>
Load Data with <invoke>
Load Snapshot Data with <snapshot> or <raql>
Select Distinct Values
Alias Names for Columns or Calculations
Plain Functions on Select Columns
Dataset Paths, Locators, Names, and Datatypes
Valid Names for Datasets, Columns, Aliases, Paths and Functions
RAQL Reserved Keywords
From Subqueries
Limit the Rows Returned
Where Complex Conditions
Where Text Like Patterns
Where in Sets
Where Between a Range
Parameters in Where Clauses
Literal Values in Conditions or Expressions
Plain Functions in Where
Sort Directions and Multi-Level Sorts
Plain Functions in Sorts
Multi-Level Group Calculations
Having Clause to Filter Groups
Partitions and Windows
Running Aggregates
Number or Rank Rows
Analytic Functions for Partitions and Windows
Joins and Other Multiple-Dataset Operations
Creating Dynamic RAQL Queries
Migrate RAQL Queries from Version 3.7 to 3.8
RAQL Datatypes and Data Formats
RAQL Operators
Built-In RAQL Functions
Create and Add User-Defined Functions for RAQL Queries
RAQL Query Syntax Reference
The basics of using
RAQL
to query and analyze large datasets is discussed in
Getting Started with MashZone NextGen Analytics
. For specific techniques on loading large datasets or using specific
RAQL
query clauses, see the links in these sections:
Techniques to Load Data
Select Techniques
From Techniques
Over Techniques
Where Techniques
Group By Techniques
Having Techniques
Order By Techniques
Multi-DataSet Operations
See also
Escape Characters for RAQL Queries
,
RAQL Operators
,
RAQL Datatypes and Data Formats
,
Built-In RAQL Functions
and
Create and Add User-Defined Functions for RAQL Queries
.
Copyright ©
2013
-2018
| Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release