Sample ICombiner

[RemekH]

Would be possible to add some example showing how to make custom JOIN using ICombiner?
E.g. JOIN two data sets using BETWEEN or x>=z && y<=z

[MikeRys]

Hi Remek.... I don't think that a custom Combiner would be a great example for a BETWEEN scenario. That you should probably express as a CROSS JOIN with the BETWEEN in the WHERE clause.

Writing example Combiners is on our backlog though, although it would have to be one that shows a good use case :).

[RemekH]

Hi Mike,

I was looking for any example not necessary related to BETWEEN. I agree with you that in most cases CROSS APPLY would be better solution then COMBINE.
My first approach was to used CROSS APPLY, but it took 25min to process, then when I eventually figure out how to use COMBINE it took only 5min.
So I guess there are cases when COMBINE come handy when you need to do JOIN BETWEEN

[MikeRys]

I assume you mean a CROSS JOIN? :) And yes, custom Combiners can be more efficient than the generic CROSS JOIN/WHERE. If you feel yours is a good example and you are willing to share it, please let me know and I can add it.

[RemekH]

Yes, I meant CROSS JOIN. I’m working on article to explain how to use COMBINE. I will let you know when ready so you can decide if it’s worth to add it as example and if so I will send you all source codes

[MikeRys]

Thanks. Looking forward to the example!

From: RemekH [mailto:notifications@github.com]
Sent: Wednesday, August 10, 2016 6:27 AM
To: Azure/usql usql@noreply.github.com
Cc: Michael Rys michaelrys@hotmail.com; Assign assign@noreply.github.com
Subject: Re: [Azure/usql] Sample ICombiner (#53)

Yes, I meant CROSS JOIN. I’m working on article to explain how to use COMBINE. I will let you know when ready so you can decide if it’s worth to add it as example and if so I will send you all source codes

—
You are receiving this because you were assigned.
Reply to this email directly, view it on GitHub #53 (comment) , or mute the thread https://github.com/notifications/unsubscribe-auth/ALNzJPMLdB1o6bbmFaT-udc2pU5rU_9xks5qedGWgaJpZM4JfK9o . https://github.com/notifications/beacon/ALNzJLXnHDfyWKkaIpX0bFZtv3q8kb5xks5qedGWgaJpZM4JfK9o.gif

[RemekH]

Hi Mike,
Here is link to the post I mentioned: http://remekh.blogspot.com/2016/08/azure-data-lake-analytics-process-web.html

[MikeRys]

Thanks I already tweeted it out :).

[MikeRys]

We now have the U-SQL C# Programmability guide with samples for all UDOs at https://docs.microsoft.com/en-us/azure/data-lake-analytics/data-lake-analytics-u-sql-programmability-guide.