Re: Collect function
From: ddf <oratune_at_msn.com>
Date: Wed, 16 Sep 2009 04:49:00 -0700 (PDT)
Message-ID: <a307e64e-c689-497e-82c1-3dffa01a7cb3_at_y20g2000vbk.googlegroups.com>
On Sep 15, 9:47 pm, Sashi <small..._at_gmail.com> wrote:
> HI all, I'm trying to use the collect() function (mentioned in my
> earlier post in this ng) but it, well, collects all values. Is there
> any way of avoiding duplicates?
> What I'm trying to do is this:
>
> select collect(a1), a2, a3, a4
> from A
> group by a2, a3, a4.
>
> Thanks,
> Sashi
Date: Wed, 16 Sep 2009 04:49:00 -0700 (PDT)
Message-ID: <a307e64e-c689-497e-82c1-3dffa01a7cb3_at_y20g2000vbk.googlegroups.com>
On Sep 15, 9:47 pm, Sashi <small..._at_gmail.com> wrote:
> HI all, I'm trying to use the collect() function (mentioned in my
> earlier post in this ng) but it, well, collects all values. Is there
> any way of avoiding duplicates?
> What I'm trying to do is this:
>
> select collect(a1), a2, a3, a4
> from A
> group by a2, a3, a4.
>
> Thanks,
> Sashi
Provide some sample data so we can test this ourselves.
David Fitzjarrell Received on Wed Sep 16 2009 - 06:49:00 CDT