[
https://issues.apache.org/jira/browse/HIVE-19724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16493090#comment-16493090
]
Ashutosh Chauhan commented on HIVE-19724:
-----------------------------------------
This is expected. Truncate is suppose to remove all data but not suppose to
remove partitions itself. This behavior is same as truncate column.
> Show partitions showing partition after running truncate table
> --------------------------------------------------------------
>
> Key: HIVE-19724
> URL: https://issues.apache.org/jira/browse/HIVE-19724
> Project: Hive
> Issue Type: Bug
> Affects Versions: 3.1.0
> Reporter: Vineet Garg
> Priority: Major
>
> SHOW PARTITION is showing partitions even after running TRUNCATE TABLE
> *Reproducer*
> {code:sql}
> CREATE TABLE table1_n15 (name string, age int) PARTITIONED BY (country
> string, state string);
> INSERT INTO table1_n15 values ('John Doe', 23, 'USA', 'CA'), ('Jane Doe', 22,
> 'USA', 'TX');
> SHOW PARTITIONS table1_n15;
> >OK
> >country=USA/state=CA
> >country=USA/state=TX
> TRUNCATE TABLE table1_n15;
> SHOW PARTITIONS table1_n15;
> >OK
> >country=USA/state=CA
> >country=USA/state=TX
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
