[SPARK-28506] not handling usage of group function and window function at some conditions

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Cannot Reproduce
• Affects Version/s: 3.1.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Dylan Guedes
• Created: 24/Jul/19 17:15
• Updated: 30/Nov/20 11:53
• Resolved: 30/Nov/20 11:53

Description

Hi,

looks like SparkSQL is not able to handle this query:

SELECT rank() OVER (ORDER BY 1), count(*) FROM empsalary GROUP BY 1;

PgSQL, on the other hand, does.