Jack Chen created SPARK-48557:
---------------------------------
Summary: Support scalar subquery with group-by on column equal to
constant
Key: SPARK-48557
URL: https://issues.apache.org/jira/browse/SPARK-48557
Project: Spark
Issue Type: Sub-task
Components: SQL
Affects Versions: 4.0.0
Reporter: Jack Chen
For example, this query is currently unsupported but can be allowed, because
the filter y2 = 1 guarantees that the group-by has only one value.
{code:java}
select *, (select count(*) from y where x1 = y1 and y2 = 1 group by y2) from x;
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
