cache-load-store.emml

Cache initialization logic using <storeto/> and <loadfrom/> for subsequent RAQL queries.

correlate1.emml

RAQL query to correlate 2 column values (stock volume & closing price) grouped by months.

Uses group aggregation to get only summary values;

Uses windows aggregation to get summary values along-with record details.

correlate2.emml

Correlation of Stock Closing price & Volume over 3-month Periods.

covariance.emml

Computes Covariance of 2 columns(Stock closing price, volume) for each stock symbol.

cube-rollup.emml

Usage of ROLLUP, CUBE and GROUPING SETS to aggregate data on multiple levels

date-num-funcs.emml

Showcases Conversion and Locale-based Formatting functions :

Currency formatting, Number formatting, Percent formatting, Integer formatting with group separators, Data to/from Epoc conversions. Date Formatting.

datefmts.emml

Use of to_date(...) date conversion function

di-cache-stream.emml

Invokes REST service URL endpoint and stores data into a BigMemory declarative cache.

dom-cache.emml

Stores XML DOM in cache using <storeto/>; then retrieves this DOM from Cache using <loadfrom/> for querying using RAQL .

except.emml

Usage of RAQL except operator to find difference between 2 datasets

hierarchy-agg.emml

Chained RAQL queries to compute Monthly, Quarterly and Yearly Aggregations

intersect.emml

RAQL intersect operator to find intersection of 2 datasets

join-raql.emml

Various RAQL Join queries to illustrate Join of two Stream Sources; two DOM Sources; and a Stream Source with DOM source.

join2-raql.emml

RAQL Join cross diverse data formats - joins XML and CSV datasources.

RAQL Join on columns transformed using functions and cast functions.

joinBigMemory.emml

RAQL Joins 2 BigMemory cache sources; Also illustrates join between BigMemory and Stream/DOM sources.

kmeans1.emml

RAQL query for K-Means clustering using Euclidean and Manhattan measures

kmeans2.emml

RAQL K-Means centroids computation using Euclidean and SquaredEuclidean measures

legislators.emml

Diverse RAQL queries to illustrate usage of - select columns; limit results; distinct records; filter expressions; like search; group aggregations; order by.

linear_regression_1.emml

Use of RAQL Linear Regression analytic function

load-decl-cache.emml

Loads 'Legislators' sample data into cache; for subsequent analysis using assorted queries from query-decl-cache.emml

load-stocks-cache.emml

Loads 'Stocks' data into cache; for subsequent analysis using assorted queries from query-stock-cache.emml

math1.emml

Use of basic arithmetic operators in RAQL queries

mfgplants-cache.emml

Loads 'mfgPlants.csv' CSV dataset into cache; for subsequent analysis using query-mfgplants-cache.emml

mfgplants.emml

Various RAQL queries (Group by, Filter, Sub-query) on CSV dataset

mysql-raql.emml

Use of SQL with RAQL. SQL does base query and sends results to RAQL for windows aggregation.

parallel-query1.emml

ForEach parallel statement to perform RAQL queries in parallel and then combine results using <fuse/> statement

percent-change-subquery.emml

RAQL query to calculate Volume Mean Percentage change over a certain threshold value, across each quarter. This is done using Sub Query.

percent-change.emml

RAQL query to calculate Volume Mean Percentage change over a certain threshold value, across each quarter. This is done using Chained Query.

query-decl-cache.emml

see load-decl-cache.emml

query-mfgplants-cache.emml

see load-mfgplants-cache.emml

query-stocks-cache.emml

see load-stocks-cache.emml

schema2.emml

EMML In-line Schema definition for RAQL datasources

snapshot.emml

Query Presto Snapshot data using RAQL

snapshot2.emml

Use of alternate pattern to query Presto Snapshots using RAQL

stocks-group-avg.emml

Group avg aggregation of stocks by month, quarter, year

stocks-group-count.emml

Group count aggregation stocks by month, quarter , year

stocks-group-max.emml

Group max aggregation of stocks by month, quarter , year

stocks-group-min.emml

Group min aggregation of stocks by month, quarter , year

stocks-group-stddev.emml

Group stddev of stocks by month, quarter, year

stocks-group-sum.emml

Group sum aggregation by month, quarter, year

stocks-group-variance.emml

Group variance of stocks by month, quarter, year

stocks-price-chg.emml

Using RAQL chained queries compute min and max opening price change between weeks.

stocks-running-avg.emml

Running avg of stocks by month, quarter, year

stocks-running-count.emml

Running count by month, quarter, year

stocks-running-max.emml

Running max of stocks by month, quarter, year

stocks-running-min.emml

Running min of stocks by month, quarter, year

stocks-running-stddev.emml

Running stddev of stocks by month, quarter, year

stocks-running-sum.emml

Running sum of stocks by month, quarter, year

stocks-running-variance.emml

Running variance of stocks by month, quarter, year

subquery1.emml

RAQL query to calculate mean percentage chagne in stock volume over 5% between quarters; implemented using RAQL Sub Query

udf-sample.emml

RAQL query using User-defined Functions

union.emml

RAQL union operator illustrates combining datasets with following properties

window-functions-using-cache.emml

Query against BigMemory cache using Window functions - rank, dense_rank, lag, lead, first_value, last_value, row_number

window-functions.emml

Query against file datasource using Window functions - rank, dense_rank, lag, lead, first_value, last_value, row_number