Appendix B. Reserved Keywords

The words in the following table are explicitly reserved in EPL, however certain keywords are allowed as event property names in expressions and as column names in the rename syntax of the select clause.

Most of the words in the table are forbidden by standard SQL as well. A few are reserved because EPL needs them.

Names of built-in functions and certain auxiliary keywords are permitted as identifiers for use either as event property names in expressions and for the column rename syntax. The second column in the table below indicates which keywords are acceptable. For example, count is acceptable.

An example of permitted use is:

select last, count(*) as count from MyEvent

This example shows an incorrect use of a reserved keyword:

// incorrect
select insert from MyEvent

The table of explicitly reserved keywords and permitted keywords:

Table B.1. Reserved Keywords

KeywordProperty Name and Rename Syntax
all-
and-
as-
asc-
avedevyes
avgyes
between-
by-
case-
castyes
coalesceyes
countyes
create-
current_timestamp-
delete-
desc-
distinct-
else-
end-
escapeyes
eventsyes
everyyes
exists-
firstyes
from-
full-
group-
having-
in-
insert-
instanceofyes
into-
irstream-
is-
istream-
join-
lastyes
lastweekdayyes
left-
like-
maxyes
medianyes
metadatasqlyes
minyes
minutesyes
not-
on-
or-
order-
outer-
output-
patternyes
prevyes
prioryes
regexp-
right-
rstream-
secondsyes
select-
set-
snapshotyes
sqlyes
stddevyes
sumyes
then-
unidirectionalyes
variableyes
weekdayyes
when-
where-
windowyes

© 2008 EsperTech Inc. All Rights Reserved