[ https://issues.apache.org/jira/browse/HIVE-28321?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ramesh Kumar Thangarajan updated HIVE-28321: -------------------------------------------- Description: fname=limit_pushdown_negative.q {code:sql} explain select value, sum(key) as sum from src group by value having sum > 100 limit 20 {code} {noformat} org.apache.hadoop.hive.ql.optimizer.calcite.CalciteSemanticException: Encountered Select alias 'sum' in having clause 'sum > 100' This non standard behavior is not supported with cbo on. Turn off cbo for these queries. {noformat} > Support alias in the having clause for CBO > ------------------------------------------ > > Key: HIVE-28321 > URL: https://issues.apache.org/jira/browse/HIVE-28321 > Project: Hive > Issue Type: Sub-task > Reporter: Ramesh Kumar Thangarajan > Assignee: Ramesh Kumar Thangarajan > Priority: Major > > fname=limit_pushdown_negative.q > {code:sql} > explain select value, sum(key) as sum from src group by value having sum > > 100 limit 20 > {code} > {noformat} > org.apache.hadoop.hive.ql.optimizer.calcite.CalciteSemanticException: > Encountered Select alias 'sum' in having clause 'sum > 100' This non standard > behavior is not supported with cbo on. Turn off cbo for these queries. > {noformat} -- This message was sent by Atlassian Jira (v8.20.10#820010)