Pengcheng Xiong created HIVE-16773: -------------------------------------- Summary: Support non-equi join predicate in scalar subqueries with aggregate Key: HIVE-16773 URL: https://issues.apache.org/jira/browse/HIVE-16773 Project: Hive Issue Type: Sub-task Reporter: Pengcheng Xiong
query41.q {code} [5e84b202-205a-4fea-a457-94f28e63f0b4 main] ql.Driver: FAILED: SemanticException [Error 10250]: org.apache.hadoop.hive.ql.optimizer.calcite.CalciteSubquerySemanticException: Line 8:13 Invalid SubQuery expression ''medium'': Scalar subqueries with aggregate cannot have non-equi join predicate org.apache.hadoop.hive.ql.parse.SemanticException: org.apache.hadoop.hive.ql.optimizer.calcite.CalciteSubquerySemanticException: Line 8:13 Invalid SubQuery expression ''medium'': Scalar subqueries with aggregate cannot have non-equi join predicate at org.apache.hadoop.hive.ql.parse.CalcitePlanner.genOPTree(CalcitePlanner.java:466) {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)