Mailing-List: contact issues-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Mon, 16 May 2016 19:07:13 +0000 (UTC)
From: "Sushanth Sowmyan (JIRA)" <jira@apache.org>
To: issues@hive.apache.org
Message-ID: <JIRA.12963811.1461924377000.199924.1463425632999@Atlassian.JIRA>
In-Reply-To: <JIRA.12963811.1461924377000@Atlassian.JIRA>
References: <JIRA.12963811.1461924377000@Atlassian.JIRA> <JIRA.12963811.1461924377679@arcas>
Subject: [jira] [Commented] (HIVE-13652) Import table change order of
 dynamic partitions
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Mon, 16 May 2016 19:07:14 -0000


    [ 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)