does spark support all sql syntax

Asked Mar 03 '16 at 07:55

Active Mar 03 '16 at 08:17

Viewed 22 times

I use ROW_NUMBER() OVER(PARTITION BY COL1 ORDER BY COL2) in my pyspark script, but running with error:

java.lang.RuntimeException: [1.26] failure: ``union'' expected but `(' found SELECT *, MAX(cctry) OVER(PARTITION by ei) maxcc from tmp1

does spark support PARTITION keyword?

edited Mar 03 '16 at 08:17

Raviteja

asked Mar 03 '16 at 07:55

user3132300

Show us your whole query – Mar 03 '16 at 07:57
Thanks, i found the right answer http://stackoverflow.com/questions/31786912/spark-failure-union-expected-but-found – user3132300 Mar 06 '16 at 14:46

0 Answers0