如何计算基于时间戳作业的azure数据湖中的u-sql中的动态输出文件名 [英] how can we have dynamic output file name in u-sql in azure data lake based on timestamp job is excuted

问题描述

如何在执行作业时基于时间戳在azure数据湖中的u-sql中提供动态输出文件名.感谢帮助.我的代码如下:

how can we have dynamic output file name in u-sql in azure data lake based on timestamp when job is executed.Thanks for help.My code as below:

 OUTPUT @telDataResult
    TO 
    @"wasb://[e-mail]/**yyyymmdd**_TelDataOutput.Csv"

    USING Outputters.Csv(); 

推荐答案

此功能目前正在开发中，但尚不可用.随时对功能请求添加投票:

This feature is currently in development but not available yet. Feel free to add your vote to the feature request: https://feedback.azure.com/forums/327234-data-lake/suggestions/10550388-support-dynamic-output-file-names-in-adla

一旦可用，您将对EXTRACT执行与文件集语法相反的操作.假设您在行集@res中有一列称为eventdate的列.然后，以下OUTPUT语句将生成文件:

Once it becomes available, you would do the inverse of the fileset syntax on EXTRACT. Let's assume you have a column that is called eventdate in your rowset @res. Then the following OUTPUT statement would generate the files:

OUTPUT @res
TO "/{eventdate:yyyy}/{eventdate:MM}/{eventdate:dd}/result.csv"
USING Outputters.Csv();

这篇关于如何计算基于时间戳作业的azure数据湖中的u-sql中的动态输出文件名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！