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