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.


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.


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