hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lin Liu (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-13382) Dynamic partitioning for INSERT OVERWRITE Query is slow
Date Wed, 30 Mar 2016 06:31:25 GMT

     [ https://issues.apache.org/jira/browse/HIVE-13382?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Lin Liu updated HIVE-13382:
---------------------------
    Description: 
Recently we upgraded Hive from 0.13.1 to Hive 1.2.1.
Then we found that one of our production queries that updates the data for a multi-level partitioned
table using INSERT OVERWRITE becomes dramatically slower than in Hive0.13.1 version (e.g.
from 2 hours to more than 14 hours and slower and slower).
Note that the MR jobs finished pretty quickly, but the move stage took a very long time.

Currently we are using Hive 1.2.1 and HIVE-11940 has been applied.

  was:
In our case we execute a query to update the data for a multi-level partitioned table. The
MR jobs are finished pretty quickly, but the move stage took a very long time.

Currently we are using Hive 1.2.1 and HIVE-11940 has been applied.


> Dynamic partitioning for INSERT OVERWRITE Query is slow
> -------------------------------------------------------
>
>                 Key: HIVE-13382
>                 URL: https://issues.apache.org/jira/browse/HIVE-13382
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>            Reporter: Lin Liu
>            Priority: Blocker
>
> Recently we upgraded Hive from 0.13.1 to Hive 1.2.1.
> Then we found that one of our production queries that updates the data for a multi-level
partitioned table using INSERT OVERWRITE becomes dramatically slower than in Hive0.13.1 version
(e.g. from 2 hours to more than 14 hours and slower and slower).
> Note that the MR jobs finished pretty quickly, but the move stage took a very long time.
> Currently we are using Hive 1.2.1 and HIVE-11940 has been applied.



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

Mime
View raw message