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
- is duplicated by
-
SPARK-10724 SQL's floor() returns DOUBLE
-
- Resolved
-
- relates to
-
-
- In Progress
-
- links to
