[ 
https://issues.apache.org/jira/browse/HIVE-21572?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Vineet Garg updated HIVE-21572:
-------------------------------
    Description: 
HIVE-21231 caused the pattern of scalar subqueries to change a bit causing 
HiveRemoveSqCountCheck rule to not kick in anymore.

Queries for which this has regressed are the ones which contain group by with 
constant keys. getRelMdMaxRowCount needs to be improved for this to work.
Ref: CALCITE-2991
 

  was:
HIVE-21231 caused the pattern of scalar subqueries to change a bit causing 
HiveRemoveSqCountCheck rule to not kick in anymore.
T


> HiveRemoveSqCountCheck rule could be enhanced to capture more patterns 
> -----------------------------------------------------------------------
>
>                 Key: HIVE-21572
>                 URL: https://issues.apache.org/jira/browse/HIVE-21572
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Planning
>    Affects Versions: 4.0.0
>            Reporter: Vineet Garg
>            Assignee: Vineet Garg
>            Priority: Major
>         Attachments: HIVE-21572.1.patch, HIVE-21572.2.patch, 
> HIVE-21572.3.patch
>
>
> HIVE-21231 caused the pattern of scalar subqueries to change a bit causing 
> HiveRemoveSqCountCheck rule to not kick in anymore.
> Queries for which this has regressed are the ones which contain group by with 
> constant keys. getRelMdMaxRowCount needs to be improved for this to work.
> Ref: CALCITE-2991
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to