hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Harsh J (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-3576) Regression: ALTER TABLE DROP IF EXISTS PARTITION throws a SemanticException if Partition is not found
Date Sun, 14 Oct 2012 18:39:03 GMT

    [ https://issues.apache.org/jira/browse/HIVE-3576?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13475878#comment-13475878
] 

Harsh J commented on HIVE-3576:
-------------------------------

Sorry, let me explain with an example:

On 0.7.1:

{code}
hive> create table test(a string) partitioned by (dt string);
OK
Time taken: 21.049 seconds
hive> alter table test drop if exists partition(dt=2007);
OK
Time taken: 1.297 seconds
{code}

On 0.9.0:

{code}
hive> create table test(a string) partitioned by (dt string);
OK
Time taken: 2.133 seconds
hive> alter table test drop if exists partition(dt=2007);
FAILED: SemanticException [Error 10006]: Partition not found dt = 2007
{code}

Again, if we make sure to use 'strings', on 0.9.0, it works:

{code}
hive> alter table test drop if exists partition(dt='2007');
OK
Time taken: 0.684 seconds
{code}
                
> Regression: ALTER TABLE DROP IF EXISTS PARTITION throws a SemanticException if Partition
is not found
> -----------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-3576
>                 URL: https://issues.apache.org/jira/browse/HIVE-3576
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.9.0
>            Reporter: Harsh J
>
> Doing a simple "{{ALTER TABLE testtable DROP IF EXISTS PARTITION(dt=NONEXISTENTPARTITION)}}"
fails with a SemanticException of the 10006 kind (INVALID_PARTITION).
> This does not respect the {{hive.exec.drop.ignorenonexistent}} condition either, since
there are no if-check-wraps around this area, when fetching partitions from the store.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message