Reserved Words

This topic lists the words reserved for the VMware Tanzu GemFire query language.

Reserved Words

These words are reserved for the query language and may not be used as identifiers. The words followed with an asterisk (*) are not currently used by GemFire, but are reserved for future implementation.

abs*
all
and 
andthen* 
any* 
array 
as 
asc 
avg* 
bag* 
boolean 
by 
byte 
char 
collection
count 
date 
declare* 
define*
desc

dictionary 
distinct 
double 
element 
enum* 
except* 
exists* 
false 
first* 
flatten* 
float 
for* 
from 
group* 
having* 
import 
in 
int 
intersect* 
interval*

is_defined 
is_undefined 
last* 
like
limit
list* 
listtoset* 
long 
map 
max* 
min* 
mod 
nil 
not 
null 
nvl 
octet 
or 
order

orelse* 
query* 
select 
set 
short 
some* 
string 
struct* 
sum* 
time 
timestamp 
to_date 
true 
type 
undefine* 
undefined 
union* 
unique* 
where

To access any method, attribute, or named object that has the same name as a query language reserved word, enclose the name within double quotation marks.

Examples:

SELECT DISTINCT "type" FROM /portfolios WHERE status = 'active'

SELECT DISTINCT * FROM /region1 WHERE emps."select"() < 100000