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)

Reply via email to