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.romanc...@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-unsubscr...@spark.apache.org > For additional commands, e-mail: user-h...@spark.apache.org > >
