Description
As per floor definition,it should get BIGINT return value
-floor(DOUBLE a)
-Returns the maximum BIGINT value that is equal to or less than a.
But in current Spark implementation, it got wrong value type.
e.g.,
select floor(2642.12) from udf_test_web_sales limit 1;
2642.0
In hive implementation, it got return value type like below:
hive> select ceil(2642.12) from udf_test_web_sales limit 1;
OK
2642
Attachments
Issue Links
- is duplicated by
-
SPARK-10724 SQL's floor() returns DOUBLE
- Resolved
- relates to
-
SPARK-28135 ceil/ceiling/floor/power returns incorrect values
- In Progress
- links to