Yongzhi Chen created HIVE-11319:
-----------------------------------
Summary: CTAS with location qualifier overwrites directories
Key: HIVE-11319
URL: https://issues.apache.org/jira/browse/HIVE-11319
Project: Hive
Issue Type: Bug
Components: Parser
Affects Versions: 1.2.0, 1.0.0, 0.14.0
Reporter: Yongzhi Chen
Assignee: Yongzhi Chen
CTAS with location clause acts as an insert overwrite. This can cause problems
when there sub directories with in a directory.
This cause some users accidentally wipe out directories with very important
data. We should bind CTAS with location to a non-empty directory.
Reproduce:
create table ctas1
location '/Users/ychen/tmp'
as
select * from jsmall limit 10;
create table ctas2
location '/Users/ychen/tmp'
as
select * from jsmall limit 5;
Both creates will succeed. But value in table ctas1 will be replaced by ctas2
accidentally.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
