LiveView Reserved Words

LiveView inherits the reserved word lists from StreamSQL and the StreamBase expression language, and also adds a few of its own. When you name fields and other identifiers in LiveView queries, do not use words from any of these lists.

StreamSQL Reserved Words

The terms in the following list of are sorted alphabetically across, then down.

advance always and apply as asc between bsort
by constant create declare default delete desc duplicate
error every except extends false foreach from gather
group having heartbeat if implements import index input
insert into join key limit lock lockset materialized
merge metronome not null offset on or order
outer output parallel parameters partition pattern predicate primary
private public replace returning schema secondary select set
size slack stream table then time timeout true
truncate tuples union unlock update using valid vjoin
where window with within        
StreamBase Expression Language Reserved Words

The StreamBase expression language has the following reserved words:

and as between
else false function
if or not
null then true

Most of these reserved words duplicate words in the StreamSQL list. The following expression language reserved words are reserved in LiveView in addition to the StreamSQL reserved words:

else function
LiveView Additional Reserved Words

LiveView has the following additional reserved words:

command for key
old pivot publisherid
publishersn values  

Finally, no LiveView column name can begin with CQS or an underscore (_).