MashZone NextGen 10.2 | Appendix | Legacy Presto components | MashZone NextGen Analytics | RAQL Queries | RAQL Reserved Keywords
 
RAQL 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. See Literal Values in Conditions or Expressions for more information.
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

Copyright © 2013-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release