LATEST VERSION: 8.2.7 - CHANGELOG
Pivotal GemFire® v8.2

Reserved Words

Reserved Words

Reserved Words

These words are reserved for the query language and may not be used as identifiers. The words with asterisk (*) after them 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