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:
- 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
CQSor an underscore (