Presto Analytics : Getting Started with Presto Analytics
Getting Started with Presto Analytics
 
A Basic RAQL Query
Structure, Format and Access to Datasets with RAQL
The RAQL Query Syntax
Load Data with <directinvoke> and Filter Rows
Use Plain Functions to Update, Select or Sort Rows
Datatype Information for Loaded Datasets
The Stream/Document Boundary
Use an In-Memory Store to Store and Load Datasets for Presto Analytics
Group and Analyze Rows
Group and Analyze Rows with Row Detail
Where to Go Next
This topic presents basic examples to help you get comfortable with the features of Presto Analytics and the Real-Time Analytics Query Language (RAQL).
*About the Real-Time Analytics Query Language Examples
*A Basic RAQL Query
*Structure, Format and Access to Datasets with RAQL
*The RAQL Query Syntax
*Load Data with <directinvoke> and Filter Rows
*Use Plain Functions to Update, Select or Sort Rows
*Datatype Information for Loaded Datasets
*The Stream/Document Boundary
*Use an In-Memory Store to Store and Load Datasets for Presto Analytics
*Group and Analyze Rows
*Group and Analyze Rows with Row Detail
*Where to Go Next
Additional query techniques for RAQL are discussed in RAQL Queries and Working with Presto Analytics In-Memory Stores.
For some simple examples of mashups and information on the Mashup Samples project, see RAQL Samples.
About the Real-Time Analytics Query Language Examples
Many of the example datasets used in this topic or other topics illustrating RAQL are available as both:
*Files in the web-apps-home/presto/WEB-INF/classes folder in the Presto Server.
*Hosted resources at http://mdc.jackbe.com/prestodocs/data/file-name.
In a few cases, such as examples for snapshots, you must provide some initial configuration or perform some steps in Presto Hub to make the datasets used in the example available.
Note:  
The example datasets used in this topic do not necessarily represent actual load or throughput requirements. Base memory settings for Presto may require tuning to provide adequate performance for actual loads. For more information, see About BigMemory and the Presto Analytics In-Memory Stores.
First let’s take a look at a simple RAQL query.
Copyright © 2013-2015 Software AG, Darmstadt, Germany.
Product LogoContact Support   |   Community   |   Feedback