[SPARK-18170] Confusing error message when using rangeBetween without specifying an "orderBy"

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Incomplete
• Component/s: SQL
• Labels: bulk-closed
• Assignee: Unassigned
• Reporter: Weiluo Ren
• Created: 30/Oct/16 06:53
• Updated: 12/Dec/22 18:10
• Resolved: 21/May/19 04:11

Description

spark.range(1,3).select(sum('id) over Window.rangeBetween(0,1)).show

throws runtime exception:

Non-Zero range offsets are not supported for windows with multiple order expressions.

which is confusing in this case because we don't have any order expression here.

How about add a check on

orderSpec.isEmpty

at https://github.com/apache/spark/blob/master/sql/core/src/main/scala/org/apache/spark/sql/execution/window/WindowExec.scala#L141
and throw an exception saying "no order expressions is specified"?