hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Carl Steinbach (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-3148) LOCATION clause is not honored when adding multiple partitions
Date Fri, 15 Jun 2012 22:51:42 GMT

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

Carl Steinbach commented on HIVE-3148:
--------------------------------------

The ability to specify the location of partitions on a per-partition basis was added in HIVE-91.
Unfortunately, if you specify more than one partition in the same statement, the second partition
and all subsequent partitions will have the same storage location as the first partition:

{noformat}
hive> CREATE TABLE t(x INT) PARTITIONED BY (p INT);
OK
hive> ALTER TABLE t ADD
        PARTITION (p=1) LOCATION '/Users/carl/1'
        PARTITION (p=2) LOCATION '/Users/carl/2';
OK
hive> DESCRIBE FORMATTED t PARTITION(p=1);
OK
...
Location:           	file:/Users/carl/1  	 
...
hive> DESCRIBE FORMATTED t PARTITION(p=2);
OK
Location:           	file:/Users/carl/1     <----- WRONG!
hive>
{noformat}

                
> LOCATION clause is not honored when adding multiple partitions
> --------------------------------------------------------------
>
>                 Key: HIVE-3148
>                 URL: https://issues.apache.org/jira/browse/HIVE-3148
>             Project: Hive
>          Issue Type: Bug
>          Components: Metastore, Query Processor
>    Affects Versions: 0.4.0, 0.5.0, 0.6.0, 0.7.0, 0.8.0, 0.9.0
>            Reporter: Carl Steinbach
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message