Re: [Spark SQL] ceil and floor functions on doubles

2017-05-22 Thread Vadim Semenov
Yes, it was done on purpose to match the behavior of Hive ( https://issues.apache.org/jira/browse/SPARK-10865). And I believe Hive returns `Long`s because they adopted the definition used in MySQL (https://issues.apache.org/jira/browse/HIVE-615). On Fri, May 19, 2017 at 10:51 AM, Anton Okolnychyi

Re: [Spark SQL] ceil and floor functions on doubles

2017-05-19 Thread Anton Okolnychyi
Hi Dongjoon, yeah, it seems to be the same. So, was it done on purpose to match the behavior of Hive? Best regards, Anton 2017-05-19 16:39 GMT+02:00 Dong Joon Hyun : > Hi, Anton. > > > > It’s the same result with Hive, isn’t it? > > > > hive> select 9.223372036854786E20, ceil(9.223372036854786E

Re: [Spark SQL] ceil and floor functions on doubles

2017-05-19 Thread Dong Joon Hyun
Hi, Anton. It’s the same result with Hive, isn’t it? hive> select 9.223372036854786E20, ceil(9.223372036854786E20); OK _c0 _c1 9.223372036854786E20 9223372036854775807 Time taken: 2.041 seconds, Fetched: 1 row(s) Bests, Dongjoon. From: Anton Okolnychyi Date: Friday, May 19, 2017 a