Sheng Wang created IMPALA-10400:
-----------------------------------
Summary: Floor/Ceil/Trunc should return BIGINT instead of DOUBLE
Key: IMPALA-10400
URL: https://issues.apache.org/jira/browse/IMPALA-10400
Project: IMPALA
Issue Type: Improvement
Reporter: Sheng Wang
Floor/Ceil/Trunc returns BIGINT in version 2.12.0, but change to DOUBLE in
IMPALA-6230. I think these functions should use BIGINT as return value type
instead of DOUBLE. We compared severals systems:
*mysql*：
floor(num): BIGINT
ceil(num): BIGINT
truncate(num, d): d>0 DOUBLE,d=0 BIGINT,d<0 0
*hive 2.1.1*：
floor(num): BIGINT
ceil(num): BIGINT
trunc(date, format): truncate date
*clickhouse*：
floor(num): BIGINT
ceil(num): BIGINT
truncate(num, [d])，d>0 DOUBLE,d=0 BIGINT,d<0 0
*greenplum*：
floor(num): BIGINT
ceil(num): BIGINT
truncate(num, [d])，d>0 DOUBLE,d=0 BIGINT,d<0 0
*spark*：
floor(num): BIGINT
ceil(num): BIGINT
trunc(date, format): truncate date
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
