[Doris基本-1] SQL中全部的保留字列表

数据分析

2021-01-21

8

0

在编写SQL时, 应当避免SQL语句中出现Doris的保留字

全部保留字(0.12.21)

&&
add
admin
after
aggregate
all
alter
and
anti
as
asc
authors
backend
backends
backup
begin
between
bigint
bitmap
bitmap_union
boolean
both
broker
buckets
builtin
by
cancel
case
cast
chain
char
character
charset
check
cluster
clusters
collate
collation
column
columns
comment
commit
committed
config
connection
connection_id
consistent
count
create
cross
cube
current
current_user
data
database
databases
date
datetime
day
decimal
decommission
default
delete
desc
describe
distinct
distinctpc
distinctpc
distinctpcsa
distinctpcsa
distributed
distribution
dynamic
div
double
drop
dropp
duplicate
else
end
engine
engines
enter
errors
events
except
exists
explain
export
external
extract
false
file
first
float
follower
following
for
format
free
from
frontend
frontends
full
function
functions
global
grant
grants
group
grouping
hash
having
help
hll
hll_union
hour
hub
identified
if
in
index
indexes
infile
inner
insert
int
integer
intermediate
intersect
interval
into
is
isnull
isolation
install
join
key
keys
kill
label
largeint
last
left
less
level
like
limit
link
load
local
location
max
maxvalue
merge
migrate
migrations
min
minus
minute
modify
month
name
names
negative
no
not
null
nulls
observer
offset
on
only
open
or
order
outer
outfile
over
partition
partitions
password
path
pause
plugin
plugins
preceding
primary
proc
procedure
processlist
properties
property
query
quota
random
range
range
read
real
recover
regexp
release
rename
repair
repeatable
replace
replace_if_not_null
replica
repositories
repository
resource
resources
restore
resume
returns
revoke
right
rlike
role
roles
rollback
rollup
routine
row
rows
schema
schemas
second
select
semi
serializable
session
set
sets
show
smallint
snapshot
soname
split
start
status
stop
storage
string
sum
superuser
sync
system
table
tables
tablet
task
temporary
terminated
than
then
timestamp
tinyint
to
transaction
triggers
trim
true
truncate
type
types
unbounded
uncommitted
union
unique
unsigned
use
user
using
uninstall
value
values
varchar
variables
view
materialized
warnings
week
whitelist
when
where
whitelist
with
work
write
year
||

欢迎添加微信,互相学习↑↑↑ -_-

发表评论

全部评论:0条

白老虎

programming is not only to solve problems, ways to think