[ https://issues.apache.org/jira/browse/HIVE-28321?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ramesh Kumar Thangarajan resolved HIVE-28321. --------------------------------------------- Fix Version/s: 4.1.0 Resolution: Fixed > Support select 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 > Labels: pull-request-available > Fix For: 4.1.0 > > > 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)