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, 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-2016 Software AG, Darmstadt, Germany.
Product LogoContact Support   |   Community   |   Feedback