New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ENH: Reduction to get the first non-null value in a column #1230

cpcloud opened this Issue Nov 22, 2017 · 1 comment


1 participant

cpcloud commented Nov 22, 2017

Some of the big SQL engines have explicit support for this.

  • Presto: ARBITRARY
  • Clickhouse: any/anyLast
  • BigQuery: ANY_VALUE

There are probably others that support this behavior.

Let's start with arbitrary and we can see about adding a string option 'first' or 'last' or another method arbitrary_last for backends that don't explicitly support it possibly using window functions.

@cpcloud cpcloud added the enhancement label Nov 22, 2017

@cpcloud cpcloud added this to the 0.13 milestone Nov 22, 2017

cpcloud added a commit that referenced this issue Feb 9, 2018

Arbitrary operation
Relates to #1230

Author: Krisztián Szűcs <>

Closes #1309 from kszucs/arbitrary and squashes the following commits:

427e82c [Krisztián Szűcs] document heavy modifier of arbitrary
45d2db0 [Krisztián Szűcs] review issues
bd53ece [Krisztián Szűcs] test arbitrary arguments
4aea76c [Krisztián Szűcs] arbitrary how argument; clickhouse and pandas implementation
e2d9883 [Krisztián Szűcs] revert expr api
672c053 [Krisztián Szűcs] arbitrary operation

This comment has been minimized.


cpcloud commented Feb 14, 2018

Added in #1309

@cpcloud cpcloud closed this Feb 14, 2018

New Operations and Types automation moved this from To do to Done Feb 14, 2018

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment