Data Selection Examples

Event Stream Processor includes several data selection examples that demonstrate a range of functionality, including how to apply GROUP BY, AGING, and WHERE clauses to data.

• AGING Column
  Use the AGING clause to set an age column for an output window.
• AGING Column with Time Option
  Use the AGING clause to set an age column with time option for an input window.
• Data Aggregation
  Read data from a comma-separated value (.csv) file, and aggregate the data using a volume-weighted average price (vwap) function.
• Data Aggregation with Filter
  Use the HAVING clause to place a filter on a window.
• GROUP BY Clause with last() Function
  Use the last function with SELECT clause results. Refer to the results of the SELECT clause in a HAVING clause.
• KEEP Clause
  Place a KEEP clause on an output window.
• KEEP Clause with AGING Clause
  Place KEEP and AGING clauses on an output window.
• KEEP ALL Clause
  Use the KEEP ALL clause with an output window.
• KEEP LAST clause
  Place a KEEP LAST clause on an input window.
• KEEP PER Clause
  Use the KEEP PER clause with an input window, derived window, or an unnamed window.
• KEEP UNTIL Clause
  Use a KEEP UNTIL clause with a Jumping Window.
• Filter with WHERE Clause
  Use the WHERE clause as a filter on an output window.
• MATCHING clause
  Place a MATCHING clause on an output stream.
• Matching a Sequence of Events
  Place MATCHING and WHERE clauses on output streams to produce a set of sequenced data.
• Matching Non-Events
  Place a MATCHING clause with a not (!) condition on an output stream.
• Row Time
  Use the bigdatetime system column to retrieve row-insertion times.
• AUTOGENERATE Clause
  Use the AUTOGENERATE clause in an input window to automatically generate values that function as primary keys for input data that does not have a natural primary key.