Review Board 1.7.22


enhance TRUNCATE syntex to drop data of external table

Review Request #10600 - Created April 18, 2013 and updated

fangkun cao
hive-trunk
HIVE-4367
Reviewers
hive
hive
https://issues.apache.org/jira/browse/HIVE-4367
create external table external1 (a int, b int) partitioned by (ds string);
load data local inpath '../data/files/kv1.txt' into table external1 partition (ds='2008-04-08');
load data local inpath '../data/files/kv1.txt' into table external1 partition (ds='2008-04-09');

-- trucate EXTERNAL table
TRUNCATE TABLE external1 PARTITION (ds='2008-04-08') FORCE;
select * from external1  where ds='2008-04-08'; 
select * from external1  where ds='2008-04-09';

TRUNCATE TABLE external1 FORCE;
select * from external1;
Total:
2
Open:
0
Resolved:
2
Dropped:
0
Status:
From:
Description From Last Updated Status
Review request changed
Updated (April 18, 2013, 8:19 a.m.)
add truncate_table_force.q 
and import org.stringtemplate.v4.ST;