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