Created SPARK-5427 for the addition of floor function. On Mon, Jan 26, 2015 at 11:20 PM, Alexey Romanchuk < [email protected]> 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 <[email protected]> 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 <[email protected]> >> 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: [email protected] >>> For additional commands, e-mail: [email protected] >>> >>> >> >
