CODEWITHSUNDEEP
azureazure-data-lakeu-sql
Art
Art

Reputation: 21

Dynamic file name with custom outputter

I'm trying to process images (create thumbnail images) using u-sql with custom outputter and trying to output files with dynamic file name.

My u-sql code look like this.

REFERENCE ASSEMBLY [USQLAssemblies];

@image_out =
SELECT USQLAssemblies.ImageOps.scaleImageTo(ImgData, 480, 480) AS thumbnail_image,
       FileName + "480" AS FileName
FROM dbo.ThumbnailImages;


OUTPUT @image_out
TO @"D:\Test\{FileName}.gif"
USING new USQLAssemblies.ImageOutputter();

The script returned an error.

Error: Data partitioned output is not supported for user-defined outputters.

Does u-sql support custom outputter with dynamic file name? or is it in preview? Any suggestion for workaround?

Upvotes: 1

Views: 194

Answers (1)

Jorge Ribeiro
Jorge Ribeiro

Reputation: 1138

To use partitioned output you need to activate this on preview functions.

You can try to add this line to beginning of your code. 

SET @@FeaturePreviews = "DataPartitionedOutput:on";

If not works, you will need to contact usql team to activate it on your account.

Upvotes: 1

Related Questions