But to focus the attention properly: I had already tried out 1.5.2. 2015-11-18 19:46 GMT-08:00 Stephen Boesch <java...@gmail.com>:
> Checked out 1.6.0-SNAPSHOT 60 minutes ago > > 2015-11-18 19:19 GMT-08:00 Jack Yang <j...@uow.edu.au>: > >> Which version of spark are you using? >> >> >> >> *From:* Stephen Boesch [mailto:java...@gmail.com] >> *Sent:* Thursday, 19 November 2015 2:12 PM >> *To:* user >> *Subject:* Do windowing functions require hive support? >> >> >> >> >> >> The following works against a hive table from spark sql >> >> >> >> hc.sql("select id,r from (select id, name, rank() over (order by name) >> as r from tt2) v where v.r >= 1 and v.r <= 12") >> >> >> >> But when using a standard sql context against a temporary table the >> following occurs: >> >> >> >> >> >> Exception in thread "main" java.lang.RuntimeException: [3.25] >> >> failure: ``)'' expected but `(' found >> >> >> >> rank() over (order by name) as r >> >> ^ >> >> >