[SPARK-37475] Add Scale Parameter to Floor and Ceil functions

• Type: New Feature
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.2.0
• Fix Version/s: 3.3.0
• Component/s: SQL
• Epic Link: New functions in Spark SQL 3.3
• Assignee: Sathiya Kumar
• Reporter: Sathiya Kumar
• Created: 27/Nov/21 20:01
• Updated: 04/Apr/22 09:27
• Resolved: 21/Feb/22 06:28

Description

This feature is proposed in the PR : https://github.com/apache/spark/pull/34593

Currently we support Decimal RoundingModes : HALF_UP (round) and HALF_EVEN (bround). But we have use cases that needs RoundingMode.UP and RoundingMode.DOWN.

https://stackoverflow.com/questions/34888419/round-down-double-in-spark/40476117

https://stackoverflow.com/questions/54683066/is-there-a-rounddown-function-in-sql-as-there-is-in-excel

https://stackoverflow.com/questions/48279641/oracle-sql-round-half

 

Floor and Ceil functions helps to do this but it doesn't support the position of the rounding. Adding scale parameter to the functions would help us control the rounding positions. 

 

Snowflake supports `scale` parameter to `floor`/`ceil` :

FLOOR( <input_expr> [, <scale_expr> ] )

REF:

https://docs.snowflake.com/en/sql-reference/functions/floor.html

 

 

 

 

Issue Links

• links to: [Github] Pull Request #34729 (sathiyapk)