usql icon indicating copy to clipboard operation
usql copied to clipboard

LAG with WHEN-Clause

Open marxxxx opened this issue 8 years ago • 1 comments

Hi,

i'm terribly missing the WHEN-Clause when using the LAG Function as we need to selectively calculate time differences between certain rows in our result sets.

Stream Analytics handles this just fine with the WHEN-Clause: https://msdn.microsoft.com/en-us/library/azure/dn966240.aspx

Is this on the road map for U-SQL as well? Or do you have any suggestions on achieving a similar result using the existing functions in U-SQL?

Thank you very much! Kind regards Markus

marxxxx avatar May 18 '17 12:05 marxxxx

Dear Markus

My apologies for the late reply. We currently have no near-term plan to add WHEN with LAG. Can I kindly ask you to file a feature request at http://aka.ms/adlfeedback?

Best regards Michael

MikeRys avatar Oct 20 '17 08:10 MikeRys