You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Carl Steinbach (JIRA)" <ji...@apache.org> on 2012/06/16 00:51:42 UTC
[jira] [Commented] (HIVE-3148) LOCATION clause is not honored when
adding multiple partitions
[ 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