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