Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Overview of the Event Processing Language (EPL)

• 1.1 Overview of the EPL Language
• 1.2 Event Representation
  • 1.2.1 Event Objects
  • 1.2.2 Plain Old Java Object Events
  • 1.2.3 Map Events
  • 1.2.4 Event Properties
  • 1.2.5 Dynamic Event Properties
  • 1.2.6 Handling Other Event Properties Using a User-Defined Function
  • 1.2.7 Event Sinks
• 1.3 Processing Model
  • 1.3.1 Event Streams
  • 1.3.2 Sliding Windows
    • 1.3.2.1 Row-Based Sliding Windows
    • 1.3.2.2 Time-Based Sliding Windows
  • 1.3.3 Batched Windows
    • 1.3.3.1 Time-Based Batched Windows
    • 1.3.3.2 Row-Based Batched Windows
  • 1.3.4 Subqueries and WHERE Clauses
  • 1.3.5 Aggregation
• 1.4 Use Cases
  • 1.4.1 Computing Rates per Feed
  • 1.4.2 Computing Highest Priced Stocks
  • 1.4.3 Segmenting Location Data
  • 1.4.4 Detecting Rapid Fall-off
  • 1.4.5 Finding Network Anomalies
  • 1.4.6 Detecting Absence of Event
  • 1.4.7 Summarizing Terminal Activity Data
  • 1.4.8 Reading Sensor Data
  • 1.4.9 Combining Transaction Events
  • 1.4.10 Monitoring Real-time Performance
  • 1.4.11 Finding Dropped Transaction Events

2 EPL Reference: Clauses

• 2.1 Overview of the Clauses You Can Use in an EPL Statement
• 2.2 SELECT
  • 2.2.1 Choosing Specific Event Properties
  • 2.2.2 Using Expressions
  • 2.2.3 Aliasing Event Properties
  • 2.2.4 Choosing All Event Properties
  • 2.2.5 Selecting New and Old Events With ISTREAM and RSTREAM Keywords
• 2.3 FROM
  • 2.3.1 Inner Joins
  • 2.3.2 Outer Joins
  • 2.3.3 Subquery Expressions
  • 2.3.4 Parameterized SQL Queries
• 2.4 RETAIN
  • 2.4.1 Keeping All Events
  • 2.4.2 Specifying Window Size
  • 2.4.3 Specifying Batched Versus Sliding Windows
  • 2.4.4 Specifying Time Interval
    • 2.4.4.1 BASED ON Clause
  • 2.4.5 Specifying Property Name
  • 2.4.6 Using PARTION BY Clause to Partition Window
  • 2.4.7 Using WITH Clause to Keep Largest/Smallest/Unique Values
• 2.5 MATCHING
  • 2.5.1 FOLLOWED BY Operator
  • 2.5.2 AND Operator
  • 2.5.3 OR Operator
  • 2.5.4 NOT Operator
  • 2.5.5 EVERY Operator
  • 2.5.6 WITHIN Operator
  • 2.5.7 Event Structure for Matched Pattern
• 2.6 WHERE
• 2.7 GROUP BY
• 2.8 HAVING
  • 2.8.1 Interaction With MATCHING, WHERE and GROUP BY Clauses
• 2.9 ORDER BY
• 2.10 OUTPUT
  • 2.10.1 Interaction With GROUP BY and HAVING Clauses
• 2.11 INSERT INTO
• 2.12 Simple and Correlated Subqueries
• 2.13 Parameterized Queries
  • 2.13.1 General Usage
  • 2.13.2 Using a Parameterized EPL Statement in the Processor Configuration File
  • 2.13.3 Programmatically Using a Prepared EPL Statement

3 EPL Reference: Operators

• 3.1 Overview of EPL Operators
• 3.2 Arithmetic Operators
• 3.3 Logical and Comparison Operators
• 3.4 Concatenation Operators
• 3.5 Binary Operators
• 3.6 Array Definition Operator
• 3.7 List and Range Operators
  • 3.7.1 IN Operator
  • 3.7.2 BETWEEN Operator
• 3.8 String Operators
  • 3.8.1 LIKE Operator
  • 3.8.2 REGEXP Operator
• 3.9 Temporal Operators
  • 3.9.1 FOLLOWED BY Operator
  • 3.9.2 WITHIN Operator
  • 3.9.3 EVERY Operator

4 EPL Reference: Functions

• 4.1 Single-row Functions
  • 4.1.1 The MIN and MAX Functions
  • 4.1.2 The COALESCE Function
  • 4.1.3 The CASE Control Flow Function
  • 4.1.4 The PREV Function
    • 4.1.4.1 Previous Event Per Group
    • 4.1.4.2 Restrictions
  • 4.1.5 The PRIOR Function
    • 4.1.5.1 Comparison to the PREV Function
  • 4.1.6 The INSTANCEOF Function
  • 4.1.7 The CAST Function
  • 4.1.8 The EXISTS Function
• 4.2 Aggregate functions
• 4.3 User-Defined functions

5 Programmatic Interface to EPL

• 5.1 Java Programming Interfaces

Index