spark-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ted Yu <yuzhih...@gmail.com>
Subject Re: Mathematical functions in spark sql
Date Tue, 27 Jan 2015 14:11:40 GMT
Created SPARK-5427 for the addition of floor function.

On Mon, Jan 26, 2015 at 11:20 PM, Alexey Romanchuk <
alexey.romanchuk@gmail.com> wrote:

> I have tried "select ceil(2/3)", but got "key not found: floor"
>
> On Tue, Jan 27, 2015 at 11:05 AM, Ted Yu <yuzhihong@gmail.com> wrote:
>
>> Have you tried floor() or ceil() functions ?
>>
>> According to http://spark.apache.org/sql/, Spark SQL is compatible with
>> Hive SQL.
>>
>> Cheers
>>
>> On Mon, Jan 26, 2015 at 8:29 PM, 1esha <alexey.romanchuk@gmail.com>
>> wrote:
>>
>>> Hello everyone!
>>>
>>> I try execute "select 2/3" and I get "0.6666666666666666". Is there any
>>> way
>>> to cast double to int or something similar?
>>>
>>> Also it will be cool to get list of functions supported by spark sql.
>>>
>>> Thanks!
>>>
>>>
>>>
>>> --
>>> View this message in context:
>>> http://apache-spark-user-list.1001560.n3.nabble.com/Mathematical-functions-in-spark-sql-tp21383.html
>>> Sent from the Apache Spark User List mailing list archive at Nabble.com.
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: user-unsubscribe@spark.apache.org
>>> For additional commands, e-mail: user-help@spark.apache.org
>>>
>>>
>>
>

Mime
View raw message