Which version of spark are you using?
From: Stephen Boesch [mailto:[email protected]]
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
^
