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)
