SELECT_ONE implementation

User 3218 | 3/3/2016, 1:42:44 AM

Does aggregate.SELECT_ONE(), in practice, always pick the first one or does it pick a row uniformly at random? If it is not uniformly at random, is there a way to make that happen?


User 1359 | 3/3/2016, 7:12:57 PM

The aggregate.SELECT_ONE() function does not currently have a defined behavior for which row in the aggregate that it returns.

For a random draw, the best way to proceed would be to use aggregate.CONCAT() and apply(lambda x: random.choice(x))