[HIVE-13652] Import table change order of dynamic partitions

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.2.0, 1.2.1
• Fix Version/s: 3.0.0
• Component/s: Import/Export, repl
• Labels: DR TODOC3.0 replication
• Assignee: Sankar Hariappan
• Reporter: Lukas Waldmann
• Created: 29/Apr/16 10:06
• Updated: 22/May/18 23:58
• Resolved: 09/May/17 06:28

Description

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

Issue Links

• is related to: HIVE-16597 Replace use of Map<String, String> for partSpec with List<Pair<String, String>>
• links to: GitHub Pull Request #180