Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Pig >> mail # user >> Get field from bag with constraints from same relation


Copy link to this message
-
Re: Get field from bag with constraints from same relation
On Tue, Jan 22, 2013 at 12:55:22PM +0100, Thomas Bach wrote:
> Hi there,
>
> I have the following data
>
> 4 {(1,abc),(2,cde),(5,efg)}
> 2 {(1,foo),(2,bar),(5,baz)}
> 7 {(1,bounce),(2,frotz),(5,trotz)}
>
> what I finally want to achieve is a list of all strings related to the
> largest number in the tuple that is less-equal the first number in
> the row. i.e.:
>
> (4,cde)
> (2,bar)
> (5,trotz)
>

This should be

(4,cde)
(2,bar)
(7,trotz)

of course.

Regards,
Thomas Bach.