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 > > ^ > >