Yi Zhou created SPARK-10866: ------------------------------- Summary: [Spark SQL] [UDF] the floor function got wrong return value type Key: SPARK-10866 URL: https://issues.apache.org/jira/browse/SPARK-10866 Project: Spark Issue Type: Bug Components: SQL Affects Versions: 1.5.0 Reporter: Yi Zhou
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 -- This message was sent by Atlassian JIRA (v6.3.4#6332) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org