[SPARK-28065] ntile only accepting positive (>0) values

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.1.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Dylan Guedes
• Created: 16/Jun/19 14:03
• Updated: 12/Jan/21 09:28

Description

Currently, Spark does not accept null as an input for `ntile`, or zero, however Postgres supports it.
Example:

SELECT ntile(NULL) OVER (ORDER BY ten, four), ten, four FROM tenk1 LIMIT 2;