You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Vineet Garg (JIRA)" <ji...@apache.org> on 2018/05/28 23:47:00 UTC

[jira] [Created] (HIVE-19724) Show partitions showing partition after running truncate table

Vineet Garg created HIVE-19724:
----------------------------------

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


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)