[
https://issues.apache.org/jira/browse/HIVE-13652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15272635#comment-15272635
]
Lukas Waldmann commented on HIVE-13652:
---------------------------------------
I just wonder how come there is no definition of order of partitions - when you
create table you define order in "partition by" clause, when you do "describe
table" than you get the partitioning columns in right order (even after "wrong"
import).
If you are worried about external tables than lets use your b) option from
other solutions, even though I don't fully comprehend how would it not help
existing export/import cases
In any case current behaviour is the worst possible as it leaves partitioning
on "higher will"
> 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)
