Thanks Carl, will surely file a bug. Right Carl; agreed; test case(s) not required, well actually I was looking out for queries which He Yongqiang used locally to test it. Just to ensure that we are in sync regarding this defect, because defect description is somewhat vague.
-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! -----Original Message----- From: Carl Steinbach [mailto:c...@cloudera.com] Sent: Friday, February 25, 2011 10:15 AM To: u...@hive.apache.org; mohitsi...@huawei.com Cc: hive-...@hadoop.apache.org Subject: Re: FW: Query Regarding HIVE-1535. Hi Mohit, The fix for HIVE-1535 did not include a testcase. See the discussion in the ticket for an explanation of why this was the case. The steps you outlined in your email seem to indicate that HIVE-1535 was not actually fixed, or that the problem was reintroduced later. Please file a JIRA ticket against this problem, and if possible please also link this ticket to HIVE-1535. Thanks. Carl On Thu, Feb 24, 2011 at 8:19 PM, Mohit <mohitsi...@huawei.com> wrote: > > > > > > **************************************************************************** *********** > 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! > ------------------------------ > > *From:* Mohit [mailto:mohitsi...@huawei.com] > *Sent:* Thursday, February 24, 2011 3:37 PM > *To:* 'heyongqiang...@gmail.com'; 'c...@cloudera.com' > *Cc:* 'dev@hive.apache.org' > *Subject:* Query Regarding HIVE-1535. > > > > 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! > > >
