Filter rows in partitioned dataset

Kawtar

Hi All,

I have a partitioned dataset which is partitioned by column 'current' and each partitioned contains 2000000 rows. That's why I want to filter rows in the attached dataset so that whenever there is a value in column 'current', I will return its whole corresponding row and all rows located 1 minute before the row where there is a value in column 'current' using DATE_TIME column.

I want to use prepare recipe but it seems like it is not possible with prepare recipe.

Thanks.

Regards,

Kaoutar