Reserved keywords

The following SQL keywords are reserved words for RAQL queries. Keywords are shown in lower case. Matching is not case sensitive.

Column and function names in queries that match reserved keywords must be delimited with double quote marks ( " ) to prevent errors in query execution.

Note: Single quote marks ( ' ) are used to delimit literal values that are string, and thus are not valid to delimit names.

Reserved keywords

abs

false

natural

then

all

first

not

to

and

first_value

now

trailing

any

float

nth_value

trim

array

floor

ntile

true

as

following

null

trunc

asc

for

nulls

truncate

avg

from

on

unbounded

between

full

or

union

big_decimal

group

order

unknown

blob

grouping

outer

upper

boolean

having

over

using

by

hour

partition

variance

byte

hours

pattern

var_pop

case

in

power

var_samp

cast

inner

preceding

week

ceil

integer

range

weeks

ceiling

intersect

rank

when

character

is

recursive

where

character_length

join

ref

window

char_length

lag

regr_intercept

with

clob

last

regr_slope

within

corr

last_value

relative

year

count

lead

right

years

covar

leading

round

 

covar_pop

left

row

 

covar_samp

like

rows

 

cross

limit

row_number

 

cube

ln

seconds

 

cume_dist

long

seconds

 

current

lower

select

 

date

matching

sets

 

day

max

shift

 

days

measures

short

 

default

millisecond

slide

 

define

milliseconds

sql_date

 

dense_rank

min

sql_time

 

desc

minus

sql_timestamp

 

distinct

minute

sqrts

 

do

minutes

stddev

 

double

mod

stddev_pop

 

duration

month

stddev_samp

 

else

months

string

 

end

 

struct

 

except

 

substring

 

exp

 

sum

 

explain