附录C - Impala 保留关键字（翻译）

2019独角兽企业重金招聘Python工程师标准>>>

附录 C - Impala 保留关键字

下面是 Cloudera Impala 1.2.3 中的保留关键字。保留关键字不能直接用于标识符；你必须使用添加反引号(backticks)。例如，语句 CREATE TABLE select (x INT) 会失败，而 CREATE TABLE `select` (x INT) 则会成功。Impala 保留了聚合函数的名字，而不是正常的内置函数的(Impala reserves the names of aggregate functions, but not regular built-in functions)。

因为不同的数据库系统据有不同的保留关键字集合，并且不同版本之间会发生变化，请仔细的检查数据库、表、列的名称以确保在不同的产品和版本之间最大兼容性。

add
aggregate
all
alter
and
as
asc
avg
avro
between
bigint
boolean
by
case
cast
change
char
column
columns
comment
compute
count
create
cross
data
database
databases
date
datetime
delimited
desc
describe
distinct
distinctpc
distinctpcsa
div
double
drop
else
end
escaped
exists
explain
external
false
fields
fileformat
finalize_fn
first
float
format
formatted
from
full
function
functions
group
group_concat
having
if
in
init_fn
inner
inpath
insert
int
integer
intermediate
interval
into
invalidate
is
join
last
left
like
limit
lines
load
location
max
merge_fn
metadata
min
ndv
not
null
nulls
offset
on
or
order
outer
overwrite
parquet
parquetfile
partition
partitioned
rcfile
real
refresh
regexp
rename
replace
returns
right
rlike
row
schema
schemas
select
semi
sequencefile
serdeproperties
serialize_fn
set
show
smallint
stats
stored
straight_join
string
sum
symbol
table
tables
tblproperties
terminated
textfile
then
timestamp
tinyint
to
true
union
update_fn
use
using
values
view
when
where
with

转载于:https://my.oschina.net/weiqingbin/blog/194659