[ 
https://issues.apache.org/jira/browse/HIVE-17084?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16751679#comment-16751679
 ] 

Ashutosh Chauhan commented on HIVE-17084:
-----------------------------------------

Sorry I missed it initially but I noticed that plans for load_dyn_part* tests 
have changed. These tests are no longer doing doing SPDO optimization of extra 
sort. That decision is based on stats. We shall restore those tests to do 
original plan especially since [~vgarg] is making active changes in that area. 
It won't be necessary to unset stats config, we can perhaps lower the stats 
threshold to make SPDO run on those queries.

> Turn on hive.stats.fetch.column.stats configuration flag
> --------------------------------------------------------
>
>                 Key: HIVE-17084
>                 URL: https://issues.apache.org/jira/browse/HIVE-17084
>             Project: Hive
>          Issue Type: Task
>          Components: Statistics
>            Reporter: Vineet Garg
>            Assignee: Zoltan Haindrich
>            Priority: Major
>             Fix For: 4.0.0
>
>         Attachments: HIVE-17084.08.patch, HIVE-17084.09.patch, 
> HIVE-17084.1.patch, HIVE-17084.10.patch, HIVE-17084.11.patch, 
> HIVE-17084.12.patch, HIVE-17084.13.patch, HIVE-17084.14.patch, 
> HIVE-17084.15.patch, HIVE-17084.16.patch, HIVE-17084.17.patch, 
> HIVE-17084.18.patch, HIVE-17084.19.patch, HIVE-17084.20.patch, 
> HIVE-17084.21.patch, HIVE-17084.22.patch, HIVE-17084.23.patch, 
> HIVE-17084.24.patch, HIVE-17084.25.patch, HIVE-17084.26.patch, 
> HIVE-17084.27.patch, HIVE-17084.28.patch, HIVE-17084.29.patch, 
> HIVE-17084.30.patch, HIVE-17084.31.patch, HIVE-17084.31.patch, 
> HIVE-17084.31.patch, HIVE-170884.4.patch, HIVE-170884.5.patch, 
> HIVE-170884.7.patch
>
>
> This flag is off by default and could result in bad plans due to missing 
> column statistics.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to