Xinyi Yu created SPARK-49318:
--------------------------------
Summary: Preempt low priority LCA internal error until the end of
check analysis
Key: SPARK-49318
URL: https://issues.apache.org/jira/browse/SPARK-49318
Project: Spark
Issue Type: Sub-task
Components: SQL
Affects Versions: 4.0.0
Reporter: Xinyi Yu
For queries like
{code:java}
|WITH group_counts AS (
| SELECT id, count(*) as Freq, CASE WHEN Freq <= 10 THEN "1" ELSE
"2" END AS Group
| FROM values (123) as data(id)
| GROUP BY id
|)
|SELECT Group, count(*) * 100.0 / (select count(*) from
group_counts) AS Percentage
|FROM group_counts
|Group BY Group
|ORDER BY Freq DESC;
{code}
The root cause error should be the 'Order By Freq', instead of the LCA internal
error. The LCA error should be preempted if there are other higher priority
errors occur.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
