Re: Mathematical functions in spark sql

2015-01-27 Thread Cheng Lian
Hey Alexey, You need to use |HiveContext| in order to access Hive UDFs. You may try it with |bin/spark-sql| (|src| is a Hive table): |spark-sql> select key / 3 from src limit 10; 79.33 28.668 103.67 9.0 55.0 136.34 85.0 92.67 32.6

Re: Mathematical functions in spark sql

2015-01-27 Thread Ted Yu
Created SPARK-5427 for the addition of floor function. On Mon, Jan 26, 2015 at 11:20 PM, Alexey Romanchuk < alexey.romanc...@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 wrote: > >> Have you tried floor() or ceil

Re: Mathematical functions in spark sql

2015-01-26 Thread Alexey Romanchuk
I have tried "select ceil(2/3)", but got "key not found: floor" On Tue, Jan 27, 2015 at 11:05 AM, Ted Yu 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, 1

Re: Mathematical functions in spark sql

2015-01-26 Thread Ted Yu
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 wrote: > Hello everyone! > > I try execute "select 2/3" and I get "0.". Is there any way > to cast double