Interesting question

[Ron Gonzalez]

Question:

I have multiple data that looks like the following

ID            LastUpdatedDate   Value1

1              10/21/2015               a

1              10/22/2015               b

1              10/22/2015               c

2              10/23/2015               d

2              10/22/2015               e

3              10/22/2015               f

3              10/24/2015               g

3              10/22/2015               h

3              10/21/2015               i

I basically want to do a partition by ID and pick the last item item in the partition ordered by LastUpdatedDate, so the data will look like the following:

ID            LastUpdatedDate   Value1

1             10/22/2015               b (or c)

2             10/23/2015               d

3             10/24/2015               g

I'll start reading up on the different things I can do with a GroupBy, but if someone's solved this with native Cascading operations, please give me a holler...

Thanks,

Ron

[Andre Kelpe]

You could use a GroupBy, provide a sortingKey and then use Last or First, depending on your sorting order:

http://docs.cascading.org/cascading/3.0/javadoc/cascading-core/cascading/operation/aggregator/First.html
http://docs.cascading.org/cascading/3.0/javadoc/cascading-core/cascading/operation/aggregator/Last.html

- André

--
You received this message because you are subscribed to the Google Groups "cascading-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cascading-use...@googlegroups.com.
To post to this group, send email to cascadi...@googlegroups.com.
Visit this group at http://groups.google.com/group/cascading-user.
To view this discussion on the web visit https://groups.google.com/d/msgid/cascading-user/4fbc3372-4e1d-48dc-b1e4-acbaa8bdd547%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

André Kelpe
an...@concurrentinc.com
http://concurrentinc.com

[Ron Gonzalez]

Thanks Andre...

You received this message because you are subscribed to a topic in the Google Groups "cascading-user" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/cascading-user/oBnBoesqqjE/unsubscribe.
To unsubscribe from this group and all its topics, send an email to cascading-use...@googlegroups.com.

To post to this group, send email to cascadi...@googlegroups.com.
Visit this group at http://groups.google.com/group/cascading-user.

To view this discussion on the web visit https://groups.google.com/d/msgid/cascading-user/CAA2tiYLpp9pFyU7vgneyR_O7z9P81WpbCPkrbvWvJVooKgTTUQ%40mail.gmail.com.