创建外部表时删除亚马逊S3上的文件夹

Question

在我们的S3 Bucket上，我们得到了非常不寻常的行为，并且这种行为并不一致。因此，我们无法指出问题所在。现在谈到问题，我触发了一个查询(创建外部表)。这会导致删除我在外部表中指向的文件夹。这种情况在我们身上已经发生了3-4次。所以，你能解释一下这种行为吗。为了方便起见，我附上了正在S3存储桶上执行的外部表查询和日志。

查询：

create table apr_2(date_local string, time_local string,s_computername string,c_ip string,s_ip string,s_port string,s_sitename string, referer string, localfile string, TimeTakenMS string, status string, w3status string, sc_substatus string, uri string, qs string, sc_bytes string, cs_bytes string, cs_username string, cs_User_Agent string, s_proxy string, c_protocol string, cs_version string, cs_method string, cs_Cookie string, cs_Host string, w3wpbytes string, RequestsPerSecond string, CPU_Utilization string, BeginRequest_UTC string, EndRequest_UTC string, time string, logdate string)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' location 's3://logs/apr_2_com'

日志：

 REST.DELETE.OBJECT logs/apr_2_com/000002.tar.gz 
 REST.DELETE.OBJECT logs/apr_2_com/000001.tar.gz 

Answer 1

试着使用这个语法-

    create external table if not exists apr_2(date_local string, time_local string,s_computername string,c_ip string,s_ip string,s_port string,s_sitename string, referer string, localfile string, TimeTakenMS string, status string, w3status string, sc_substatus string, uri string, qs string, sc_bytes string, cs_bytes string, cs_username string, cs_User_Agent string, s_proxy string, c_protocol string, cs_version string, cs_method string, cs_Cookie string, cs_Host string, w3wpbytes string, RequestsPerSecond string, CPU_Utilization string, BeginRequest_UTC string, EndRequest_UTC string, time string, logdate string)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' location 's3://logs/apr_2_com'