Sathiya Kumar created SPARK-37475:
-------------------------------------
Summary: Add Scale Parameter to Floor and Ceil functions
Key: SPARK-37475
URL: https://issues.apache.org/jira/browse/SPARK-37475
Project: Spark
Issue Type: New Feature
Components: SQL
Affects Versions: 3.2.0
Reporter: Sathiya Kumar
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` :
{code:java}
FLOOR( <input_expr> [, <scale_expr> ] ){code}
REF:
[https://docs.snowflake.com/en/sql-reference/functions/floor.html]
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
