Do windowing functions require hive support?

2015-11-18 Thread Stephen Boesch
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"

Re: Do windowing functions require hive support?

2015-11-18 Thread Stephen Boesch
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 > *Su

Re: Do windowing functions require hive support?

2015-11-18 Thread Stephen Boesch
e 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 fol

Re: Do windowing functions require hive support?

2015-11-18 Thread Michael Armbrust
tes 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:*

RE: Do windowing functions require hive support?

2015-11-18 Thread Jack Yang
ago 2015-11-18 19:19 GMT-08:00 Jack Yang <j...@uow.edu.au<mailto:j...@uow.edu.au>>: Which version of spark are you using? From: Stephen Boesch [mailto:java...@gmail.com<mailto:java...@gmail.com>] Sent: Thursday, 19 November 2015 2:12 PM To: user Subject: Do windowing functions requ

RE: Do windowing functions require hive support?

2015-11-18 Thread Jack Yang
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,

Re: Do windowing functions require hive support?

2015-11-18 Thread Stephen Boesch
-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: