[
https://issues.apache.org/jira/browse/HIVE-25698?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17447400#comment-17447400
]
Zoltan Haindrich commented on HIVE-25698:
-----------------------------------------
most likely column stats are being updated - I think you are changing the
columns of the table but to be on the same page you should give an example as a
set of sql statements;
if you indeed changing the columns some related tickets could be: HIVE-23806
HIVE-23959
I think you should ask for help from your vendor.
> Hive column update performance too low when table partition over 700
> --------------------------------------------------------------------
>
> Key: HIVE-25698
> URL: https://issues.apache.org/jira/browse/HIVE-25698
> Project: Hive
> Issue Type: Bug
> Components: Clients, Server Infrastructure
> Affects Versions: 3.1.1
> Environment: CentOS 7.8
> Hadoop 3.1.1
> Impala 3.4.0
> Reporter: JungHyun An
> Priority: Minor
> Fix For: All Versions
>
>
> Now we using hive 3.1.1
>
> Currently in our hive we have tables with hundreds of partitions and hundreds
> of gigabytes of data.
>
> When updating the column information of the corresponding table, it was
> confirmed that the performance was several tens of times slower than the Hive
> 1.1 version of the existing CDH.
>
> I would like to ask if there is any architectural change that makes column
> updates slower than Hive 1 in Hive 3 and later versions.
>
> Thank you.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
