Amamzon ATHENA：在输入'create external'没有可行的替代方案

Question

我正在使用以下DDL查询来创建表

CREATE EXTERNAL TABLE IF NOT EXISTS poi_test1(  
'taxonomy_level_1' string,
'taxonomy_level_2' string,
'taxonomy_level_3' string,
'taxonomy_level_4' string,
'poi_name' string,
'mw_segment_name' string,
'latitude' double,
'longitude' double,
'city' string,
'state' string,
'country_code' string,
'default_radius' float
) 
ROW FORMAT DELIMITED 
FIELDS TERMINATED BY ','
STORED AS INPUTFORMAT 
'org.apache.hadoop.mapred.TextInputFormat' 
OUTPUTFORMAT 
'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION
's3://mw.test/jishan1/qa1/poi1';

错误：第1:8行：输入"创建外部"时没有可行的替代方案(服务：amazonathena；状态代码：400；错误代码：invalidrequestexception；请求id:5dbd0eb8-6842-45ca-8f60-9f17fd2e4c04(

Answer 1

如果存在保留关键字，则应删除列周围的单引号，或者将它们括在后引号中；如果列以数字开头，则应将它们括起来。阅读本文，了解与雅典娜一起使用的命名约定。

我通过删除单引号运行了您的查询，如下所示，它成功地创建了表

CREATE EXTERNAL TABLE poi_test1(  
taxonomy_level_1 string,
taxonomy_level_2 string,
taxonomy_level_3 string,
taxonomy_level_4 string,
poi_name string,
mw_segment_name string,
latitude double,
longitude double,
city string,
state string,
country_code string,
default_radius float
) 
ROW FORMAT DELIMITED 
FIELDS TERMINATED BY ',' 
STORED AS INPUTFORMAT 
'org.apache.hadoop.mapred.TextInputFormat' 
OUTPUTFORMAT 
'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION's3://mw.test/jishan1/qa1/poi1';