hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sushanth Sowmyan (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-13652) Import table change order of dynamic partitions
Date Mon, 16 May 2016 19:07:13 GMT

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

Sushanth Sowmyan commented on HIVE-13652:
-----------------------------------------

> In any case current behaviour is the worst possible as it leaves partitioning on "higher
will"

I laughed at this, and you're definitely right about this.

The rest is merely context behind why this problem has not been tackled earlier (since we
break it for some users at the very least), and honestly, if we don't tackle it now, we simply
kick the ball further down the road, and it will need tackling one way or another, which we
have been doing so far.

> Import table change order of dynamic partitions
> -----------------------------------------------
>
>                 Key: HIVE-13652
>                 URL: https://issues.apache.org/jira/browse/HIVE-13652
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 1.2.0, 1.2.1
>            Reporter: Lukas Waldmann
>
> Table with multiple dynamic partitions like year,month, day exported using "export table"
command is imported (using "import table") such a way that order of partitions is changed
to day, month, year.
> Export DB:  Hive 0.14
> Import DB:  Hive 1.2.1000.2.4.0.0-169
> Tables created as:
> create table T1
> ( ... ) PARTITIONED BY (period_year string, period_month string, period_day string) STORED
AS ORC TBLPROPERTIES ("orc.compress"="SNAPPY");
> export command:
> export table t1 to 'path'
> import command:
> import table t1 from 'path'
> HDFS file structure on both original table location and export path keeps the original
partition order ../year/month/day
> HDFS file structure after import is .../day/month/year



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message