[ https://issues.apache.org/jira/browse/SPARK-18863?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Apache Spark reassigned SPARK-18863: ------------------------------------ Assignee: Apache Spark > Output non-aggregate expressions without GROUP BY in a subquery does not > yield an error > ---------------------------------------------------------------------------------------- > > Key: SPARK-18863 > URL: https://issues.apache.org/jira/browse/SPARK-18863 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 2.0.0 > Reporter: Nattavut Sutyanyong > Assignee: Apache Spark > > [~smilegator] has found that the following query does not raise a syntax > error (note the GROUP BY clause is commented out): > {code:sql} > SELECT pk, cv > FROM p, c > WHERE p.pk = c.ck > AND c.cv = (SELECT max(avg) > FROM (SELECT c1.cv, avg(c1.cv) avg > FROM c c1 > WHERE c1.ck = p.pk > -- GROUP BY c1.cv > )) > {code} > There could be multiple values of {{c1.cv}} for each value of {{avg(c1.cv)}}. -- This message was sent by Atlassian JIRA (v6.3.4#6332) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org