[ 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)