You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Pengcheng Xiong (JIRA)" <ji...@apache.org> on 2017/05/26 17:04:04 UTC

[jira] [Created] (HIVE-16773) Support non-equi join predicate in scalar subqueries with aggregate

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)