hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "fangkun cao" <caofang...@gmail.com>
Subject Re: Review Request: enhance TRUNCATE syntex to drop data of external table
Date Thu, 18 Apr 2013 08:19:02 GMT

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/10600/
-----------------------------------------------------------

(Updated April 18, 2013, 8:19 a.m.)


Review request for hive.


Changes
-------

add truncate_table_force.q 
and import org.stringtemplate.v4.ST;


Description
-------

https://issues.apache.org/jira/browse/HIVE-4367


This addresses bug HIVE-4367.
    https://issues.apache.org/jira/browse/HIVE-4367


Diffs (updated)
-----

  http://svn.apache.org/repos/asf/hive/trunk/common/src/java/org/apache/hadoop/hive/conf/HiveConf.java
1469218 
  http://svn.apache.org/repos/asf/hive/trunk/conf/hive-default.xml.template 1469218 
  http://svn.apache.org/repos/asf/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java
1469218 
  http://svn.apache.org/repos/asf/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/DDLSemanticAnalyzer.java
1469218 
  http://svn.apache.org/repos/asf/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/HiveLexer.g
1469218 
  http://svn.apache.org/repos/asf/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/HiveParser.g
1469218 
  http://svn.apache.org/repos/asf/hive/trunk/ql/src/test/queries/clientpositive/truncate_table_force.q
PRE-CREATION 
  http://svn.apache.org/repos/asf/hive/trunk/ql/src/test/results/clientpositive/truncate_table_force.q.out
PRE-CREATION 

Diff: https://reviews.apache.org/r/10600/diff/


Testing
-------

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;


Thanks,

fangkun cao


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message