Hey John, What exactly are you looking for this function to do? -- C
> On Jun 8, 2020, at 1:18 PM, John Omernik <[email protected]> wrote: > > Hey all, > > I know it's been a while I was in a job where there was no Drill to be > found, just a bunch of Hive. In that role, I got very used to using the > hive collect_set function. It allowed you to return in a single list, all > the unique values based on an aggregate. Curious, is there anything like > that in Drill? I remember something like that, and when I query > sys.functions there is collect_list and collect_to_list neither of which > work in this context... (collect_list gave me an array index out of bounds, > and collect_to_list told me the column I was collecting wasn't in the > aggregate) > > Any UDFs that will achieve this? Even if you've seen them on git hub etc, > (i.e. not built into Drill) > > Thanks! > > John Omernik
