401 lines
4.1 KiB
Plaintext
401 lines
4.1 KiB
Plaintext
arccosine
|
|
arcsine
|
|
# SQL_INFO_SQL_KEYWORDS
|
|
# Source: https://github.com/influxdata/influxdb_iox/blob/4f9c901dcfece5fcc4d17cfecb6ec45a0dccda5a/flightsql/src/sql_info
|
|
absolute
|
|
action
|
|
add
|
|
all
|
|
allocate
|
|
alter
|
|
and
|
|
any
|
|
are
|
|
as
|
|
asc
|
|
assertion
|
|
at
|
|
authorization
|
|
avg
|
|
begin
|
|
between
|
|
bit
|
|
bit_length
|
|
bitwise
|
|
both
|
|
by
|
|
cascade
|
|
cascaded
|
|
case
|
|
cast
|
|
catalog
|
|
char
|
|
char_length
|
|
character
|
|
character_length
|
|
check
|
|
close
|
|
coalesce
|
|
collate
|
|
collation
|
|
column
|
|
commit
|
|
connect
|
|
connection
|
|
constraint
|
|
constraints
|
|
continue
|
|
convert
|
|
corresponding
|
|
count
|
|
create
|
|
cross
|
|
current
|
|
current_date
|
|
current_time
|
|
current_timestamp
|
|
current_user
|
|
cursor
|
|
date
|
|
day
|
|
deallocate
|
|
dec
|
|
decimal
|
|
declare
|
|
default
|
|
deferrable
|
|
deferred
|
|
delete
|
|
desc
|
|
describe
|
|
descriptor
|
|
diagnostics
|
|
disconnect
|
|
distinct
|
|
domain
|
|
double
|
|
drop
|
|
else
|
|
end
|
|
end-exec
|
|
escape
|
|
except
|
|
exception
|
|
exec
|
|
execute
|
|
exists
|
|
external
|
|
extract
|
|
false
|
|
fetch
|
|
first
|
|
float
|
|
for
|
|
foreign
|
|
found
|
|
from
|
|
full
|
|
get
|
|
global
|
|
go
|
|
goto
|
|
grant
|
|
group
|
|
having
|
|
hour
|
|
identity
|
|
immediate
|
|
in
|
|
indicator
|
|
initially
|
|
inner
|
|
input
|
|
insensitive
|
|
insert
|
|
int
|
|
integer
|
|
intersect
|
|
interval
|
|
into
|
|
is
|
|
isolation
|
|
join
|
|
key
|
|
language
|
|
last
|
|
leading
|
|
left
|
|
level
|
|
like
|
|
local
|
|
locf
|
|
lower
|
|
match
|
|
max
|
|
min
|
|
minute
|
|
module
|
|
month
|
|
names
|
|
national
|
|
natural
|
|
nchar
|
|
next
|
|
no
|
|
not
|
|
null
|
|
nullif
|
|
numeric
|
|
octet_length
|
|
of
|
|
on
|
|
only
|
|
open
|
|
option
|
|
or
|
|
order
|
|
outer
|
|
output
|
|
overlaps
|
|
pad
|
|
partial
|
|
position
|
|
precision
|
|
prepare
|
|
preserve
|
|
primary
|
|
prior
|
|
privileges
|
|
procedure
|
|
public
|
|
read
|
|
real
|
|
references
|
|
relative
|
|
restrict
|
|
revoke
|
|
right
|
|
rollback
|
|
rows
|
|
schema
|
|
scroll
|
|
second
|
|
section
|
|
select
|
|
session
|
|
session_user
|
|
set
|
|
size
|
|
smallint
|
|
some
|
|
space
|
|
sql
|
|
sqlcode
|
|
sqlerror
|
|
sqlstate
|
|
substring
|
|
sum
|
|
system_user
|
|
table
|
|
temporary
|
|
then
|
|
time
|
|
timestamp
|
|
timezone_hour
|
|
timezone_minute
|
|
to
|
|
trailing
|
|
transaction
|
|
translate
|
|
translation
|
|
trim
|
|
true
|
|
union
|
|
unique
|
|
unknown
|
|
update
|
|
upper
|
|
usage
|
|
user
|
|
using
|
|
value
|
|
values
|
|
varchar
|
|
varying
|
|
view
|
|
when
|
|
whenever
|
|
where
|
|
with
|
|
work
|
|
write
|
|
year
|
|
zone
|
|
|
|
# SQL_INFO_NUMERIC_FUNCTIONS
|
|
# Source: https://github.com/influxdata/influxdb_iox/blob/4f9c901dcfece5fcc4d17cfecb6ec45a0dccda5a/flightsql/src/sql_info
|
|
abs
|
|
acos
|
|
asin
|
|
atan
|
|
atan2
|
|
ceil
|
|
cos
|
|
exp
|
|
floor
|
|
ln
|
|
log
|
|
log10
|
|
log2
|
|
pow
|
|
power
|
|
round
|
|
signum
|
|
sin
|
|
sqrt
|
|
tan
|
|
trunc
|
|
|
|
# SQL_INFO_STRING_FUNCTIONS
|
|
# Source: https://github.com/influxdata/influxdb_iox/blob/4f9c901dcfece5fcc4d17cfecb6ec45a0dccda5a/flightsql/src/sql_info
|
|
arrow_typeof
|
|
ascii
|
|
bit_length
|
|
btrim
|
|
char_length
|
|
character_length
|
|
chr
|
|
concat
|
|
concat_ws
|
|
digest
|
|
from_unixtime
|
|
initcap
|
|
left
|
|
length
|
|
lower
|
|
lpad
|
|
ltrim
|
|
md5
|
|
octet_length
|
|
random
|
|
regexp_match
|
|
regexp_replace
|
|
repeat
|
|
replace
|
|
reverse
|
|
right
|
|
rpad
|
|
rtrim
|
|
sha224
|
|
sha256
|
|
sha384
|
|
sha512
|
|
split_part
|
|
starts_with
|
|
strpos
|
|
substr
|
|
to_hex
|
|
translate
|
|
trim
|
|
upper
|
|
uuid
|
|
|
|
# SQL_INFO_DATE_TIME_FUNCTIONS
|
|
# Source: https://github.com/influxdata/influxdb_iox/blob/4f9c901dcfece5fcc4d17cfecb6ec45a0dccda5a/flightsql/src/sql_info
|
|
current_date
|
|
current_time
|
|
date_bin
|
|
date_part
|
|
date_trunc
|
|
datepart
|
|
datetrunc
|
|
from_unixtime
|
|
now
|
|
to_timestamp
|
|
to_timestamp_micros
|
|
to_timestamp_millis
|
|
to_timestamp_seconds
|
|
|
|
# SQL_DATE_TIME_KEYWORDS
|
|
dow
|
|
doy
|
|
|
|
# SQL_INFO_SYSTEM_FUNCTIONS
|
|
# Source: https://github.com/influxdata/influxdb_iox/blob/4f9c901dcfece5fcc4d17cfecb6ec45a0dccda5a/flightsql/src/sql_info
|
|
array
|
|
arrow_typeof
|
|
struct
|
|
|
|
# is_scalar_math_function
|
|
# Source: https://github.com/influxdata/influxdb_iox/blob/4f9c901dcfece5fcc4d17cfecb6ec45a0dccda5a/influxdb_influxql_parser/src/functions.rs
|
|
abs
|
|
sin
|
|
cos
|
|
tan
|
|
asin
|
|
acos
|
|
acosh
|
|
asinh
|
|
atan
|
|
atanh
|
|
atan2
|
|
cbrt
|
|
exp
|
|
gcd
|
|
isnan
|
|
iszero
|
|
lcm
|
|
log
|
|
ln
|
|
log2
|
|
log10
|
|
nanvl
|
|
sqrt
|
|
pow
|
|
floor
|
|
ceil
|
|
round
|
|
|
|
# InfluxQL operators
|
|
bitfield
|
|
|
|
# is_aggregate_function
|
|
# Source: https://github.com/influxdata/influxdb_iox/blob/4f9c901dcfece5fcc4d17cfecb6ec45a0dccda5a/influxdb_influxql_parser/src/functions.rs
|
|
approx_distinct
|
|
approx_median
|
|
approx_percentile_cont
|
|
approx_percentile_cont_with_weight
|
|
covar
|
|
cumulative_sum
|
|
derivative
|
|
difference
|
|
elapsed
|
|
moving_average
|
|
non_negative_derivative
|
|
non_negative_difference
|
|
bottom
|
|
first
|
|
last
|
|
max
|
|
min
|
|
percentile
|
|
sample
|
|
top
|
|
count
|
|
integral
|
|
mean
|
|
median
|
|
mode
|
|
spread
|
|
stddev
|
|
sum
|
|
holt_winters
|
|
holt_winters_with_fit
|
|
chande_momentum_oscillator
|
|
exponential_moving_average
|
|
double_exponential_moving_average
|
|
kaufmans_efficiency_ratio
|
|
kaufmans_adaptive_moving_average
|
|
triple_exponential_moving_average
|
|
triple_exponential_derivative
|
|
relative_strength_index |