drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ted Dunning <ted.dunn...@gmail.com>
Subject Re: Opposite of FLATTEN
Date Tue, 30 Jun 2015 22:30:40 GMT
I could write a custom Hive aggregator, but I want to use Drill and get all
the performance possible.



On Mon, Jun 29, 2015 at 7:02 PM, Venky Kandaswamy <venky@adisya.com> wrote:

> Couldn¹t you write a custom aggregate function in Hive? (I don¹t have
> one).
> Thanks, Venky
>
> On 6/29/15, 6:41 PM, "Ted Dunning" <ted.dunning@gmail.com> wrote:
>
> >Like array_agg in postgres:
> >
> >http://www.craigkerstiens.com/2013/04/17/array-agg/
> >
> >
> >
> >On Mon, Jun 29, 2015 at 2:23 PM, Jim Scott <jscott@maprtech.com> wrote:
> >
> >> Given a data set:
> >> 'ndb_no','description'
> >> '02001','SPICE OR HERB (US CFR)'
> >> '02001','ALLSPICE'
> >> '02001','FINELY GROUND'
> >> '02001','NOT HEAT-TREATED'
> >> '02001','COOKING METHOD NOT APPLICABLE'
> >> '02001','WATER REMOVED'
> >> '02001','NATURALLY DRIED'
> >> '02001','SUN DRIED'
> >>
> >> I'm seeking the capability to be able execute a query like:
> >> SELECT primary_key, CONCAT(description, ', ') from mytable group by
> >> primary_key
> >> (regardless of what the function name is, concat, array_aggregate,
> >>etc..)
> >>
> >> to yield results like:
> >> '02001','SPICE OR HERB (US CFR), ALLSPICE, FINELY GROUND, NOT
> >>HEAT-TREATED,
> >> COOKING METHOD NOT APPLICABLE, WATER REMOVED, NATURALLY DRIED, SUN
> >>DRIED'
> >>
> >> Does any functionality like this exist? If not, do we have any JIRA
> >>tickets
> >> that are asking for this?
> >>
> >> Thanks,
> >> Jim
> >>
>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message