impala的保留关键字,建表时慎用

在使用impala建kudu表时,如果使用了impala的保留关键字,在查询时,需要对关键字字段加上“符号,所以尽量不要使用的关键字。

例如:

select  timestamp from  kudu_test;  //会报错
select  `timestamp` from  kudu_test;  //正常

impala 保留关键字:
http://impala.apache.org/docs/build3x/html/topics/impala_reserved_words.html

hive 保留关键字列表:
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Keywords,Non-reservedKeywordsandReservedKeywords

abs             
acos                
add             
aggregate               
all             
allocate                
alter               
analytic                
and             
anti                
any             
api_version             
are             
array               
array_agg               
array_max_cardinality               
as              
asc             
asensitive              
asin                
asymmetric              
at              
atan                
atomic              
authorization               
avg             
avro                
backup              
begin               
begin_frame             
begin_partition             
between             
bigint              
binary              
blob                
block_size              
boolean             
both                
break               
browse              
bulk                
by              
cache               
cached              
call                
called              
cardinality             
cascade             
cascaded                
case                
cast                
ceil                
ceiling             
change              
char                
char_length             
character               
character_length                
check               
checkpoint              
class               
classifier              
clob                
close               
close_fn                
clustered               
coalesce                
collate             
collect             
column              
columns             
comment             
commit              
compression             
compute             
condition               
conf                
connect             
constraint              
contains                
continue            
  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值