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

Chaoyu Tang updated HIVE-12053:
-------------------------------
    Attachment: HIVE-12053.patch

[~sseth] I provided a patch reverting HIVE-11786 here, please review it. 
Though separating the big query to two parts like that done in getPartition in 
MetaStoreDirect may help to mitigate the performance impact in this case, we 
might have other performance issues with JDO. So probably we can leave these 
column stats tables unnormalized at this moment as a trade-off to the better 
performance. Thank you for the help.

> Stats performance regression caused by HIVE-11786
> -------------------------------------------------
>
>                 Key: HIVE-12053
>                 URL: https://issues.apache.org/jira/browse/HIVE-12053
>             Project: Hive
>          Issue Type: Bug
>          Components: Metastore
>            Reporter: Chaoyu Tang
>            Assignee: Chaoyu Tang
>         Attachments: HIVE-12053.patch
>
>
> HIVE-11786 tried to normalize table TAB_COL_STATS/PART_COL_STATS but caused 
> performance regression.



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

Reply via email to