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)

Reply via email to