[SPARK-19428] Ability to select first row of groupby

• Type: Brainstorming
• Status: Resolved
• Priority: Minor
• Resolution: Incomplete
• Affects Version/s: 2.1.0
• Component/s: SQL
• Labels: bulk-closed
• Assignee: Unassigned
• Reporter: Luke Miner
• Created: 01/Feb/17 18:37
• Updated: 12/Dec/22 18:10
• Resolved: 21/May/19 04:13

Description

It would be nice to be able to select the first row from GroupedData. Pandas has something like this:

df.groupby('group').first()

It's especially handy if you can order the group as well.