[ https://issues.apache.org/jira/browse/HIVE-26618?focusedWorklogId=815550&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-815550 ]
ASF GitHub Bot logged work on HIVE-26618: ----------------------------------------- Author: ASF GitHub Bot Created on: 11/Oct/22 08:55 Start Date: 11/Oct/22 08:55 Worklog Time Spent: 10m Work Description: kasakrisz opened a new pull request, #3659: URL: https://github.com/apache/hive/pull/3659 ### What changes were proposed in this pull request? * Add config setting to control whether to remove parts of query plan produces empty result. * Query the value of the setting from the config stored in session when creating `HiveRelBuilder` instance. ### Why are the changes needed? * add feature switch ### Does this PR introduce _any_ user-facing change? New config setting is introduced. Based on the values of the config query execution plan may changes. ### How was this patch tested? ``` mvn test -Dtest.output.overwrite -Dtest=TestMiniLlapLocalCliDriver -Dqfile=empty_result.q -pl itests/qtest -Pitests ``` Issue Time Tracking ------------------- Worklog Id: (was: 815550) Remaining Estimate: 0h Time Spent: 10m > Add setting to turn on/off removing sections of a query plan known never > produces rows > -------------------------------------------------------------------------------------- > > Key: HIVE-26618 > URL: https://issues.apache.org/jira/browse/HIVE-26618 > Project: Hive > Issue Type: Improvement > Components: CBO > Reporter: Krisztian Kasa > Assignee: Krisztian Kasa > Priority: Major > Time Spent: 10m > Remaining Estimate: 0h > > HIVE-26524 introduced an optimization to remove sections of query plan known > never produces rows. > Add a setting into hive conf to turn on/off this optimization. > When the optimization is turned off restore the legacy behavior: > * represent empty result operator with {{HiveSortLimit}} 0 > * disable {{HiveRemoveEmptySingleRules}} -- This message was sent by Atlassian Jira (v8.20.10#820010)