Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive, mail # dev - Review Request: enhance TRUNCATE syntex to drop data of external table


+
fangkun cao 2013-04-18, 06:25
Copy link to this message
-
Re: Review Request: enhance TRUNCATE syntex to drop data of external table
fangkun cao 2013-04-18, 08:19

-----------------------------------------------------------
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

+
Teddy Choi 2013-04-18, 07:24