shuaiqi.guo created HIVE-26559: ---------------------------------- Summary: Skip unnecessary get all partition operations when where condition with 1=0 in CBO. Key: HIVE-26559 URL: https://issues.apache.org/jira/browse/HIVE-26559 Project: Hive Issue Type: Improvement Components: CBO Affects Versions: All Versions Reporter: shuaiqi.guo Assignee: shuaiqi.guo Fix For: All Versions Attachments: HIVE-26559.patch
In some cases, queries may get executed with where condition mentioning to "1=0" to get schema. E.g {noformat} SELECT * FROM table_with_millions_of_partitions WHERE 1=0 {noformat} When the cbo optimizer optimizes the execution plan of this query, the cbo optimizer will get all the partitions of table_with_millions_of_partitions. This seems useless and causes hiveserver to fail when the number of partitions is very high. Use this patch to skip unnecessary get all partition operation when pruneNode is always false. -- This message was sent by Atlassian Jira (v8.20.10#820010)