You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@spark.apache.org by "Dai, Kevin" <yu...@ebay.com> on 2014/12/05 05:22:20 UTC

Window function by Spark SQL

Hi, ALL

How can I group by one column and order by another one, then select the first row for each group (which is just like window function doing) by SparkSQL？

Best Regards,
Kevin.

Re: Window function by Spark SQL

Posted by Cheng Lian <li...@gmail.com>.

Window functions are not supported yet, but there is a PR for it: 
https://github.com/apache/spark/pull/2953

On 12/5/14 12:22 PM, Dai, Kevin wrote:
>
> Hi, ALL
>
> How can I group by one column and order by another one, then select 
> the first row for each group (which is just like window function 
> doing) by SparkSQL？
>
> Best Regards,
>
> Kevin.
>