drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Charles Givre <cgi...@gmail.com>
Subject Re: Hello - and collect_set UDF?
Date Fri, 12 Jun 2020 14:41:01 GMT
Hey John, 
What exactly are you looking for this function to do?
-- C



> On Jun 8, 2020, at 1:18 PM, John Omernik <john@omernik.com> 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


Mime
View raw message