Hello Authors,
As tested against latest Hive build and Hadoop 20.1. Kindly provide me the query or the list of queries for which this defect was tested against, as I see no test case in it and when I'm running queries assuming which were being run by He Yongqiang while testing the scenarios, I'm not able to re-produce the scenario. I'm ran queries in below sequence :- 1 . set hive.exec.drop.ignorenonexistent=false; 2 . create table page_test(view INT, userid INT, page_url STRING) PARTITIONED BY(dt STRING, country STRING) STORED AS A TEXTFILE; 3 . LOAD DATA LOCAL INPATH '/home/test.txt' OVERWRITE INTO TABLE page_test PARTITION(dt='10-10-2010',country='US'); 4 . LOAD DATA LOCAL INPATH '/home/test.txt' OVERWRITE INTO TABLE page_test PARTITION(dt='10-12-2010',country='IN'); // This query fails during semantic analysis, since it is invalid partition and don't belong to partition spec of page_test. 5 . ALTER TABLE page_test DROP PARTITION(invalid='23-02-2010',notexist='UK'); and when I turn ON the property hive.exec.drop.ignorenonexistent, hive is silent and OK. So far good, and no issues. //However there is another case, in which partition is a valid spec but doesn't exists, as I have only [dt='10-10-2010',country='US'] and [dt='10-12-2010',country='IN'] 6 . ALTER TABLE page_test DROP PARTITION (dt='23-02-2010',country='UK'); but it doesn't results in any exception, I'm getting OK response on console. As per this defect fix, it should actually fail with console error message Partition : [{dt='23-02-2010',country='UK'}] does not exist. I may be wrong, or not aware of enough user scenarior covering the scope of this defect, kindly help me providing some insights. -Mohit **************************************************************************** *********** This e-mail and attachments contain confidential information from HUAWEI, which is intended only for the person or entity whose address is listed above. Any use of the information contained herein in any way (including, but not limited to, total or partial disclosure, reproduction, or dissemination) by persons other than the intended recipient's) is prohibited. If you receive this e-mail in error, please notify the sender by phone or email immediately and delete it!