通过数据工厂将多个动态参数传递给U-SQL脚本 [英] pass multiple dynamic parameters to U-SQL script via data factory
问题描述
当前,我可以在数据工厂工作流中将一个参数传递给u-sql脚本. 并使用该参数,我可以应用一些模式来生成文件路径. 有什么办法可以将datetimes参数的集合传递给u-sql和 应用模式来生成文件路径?
currently I can pass one parameter to u-sql script in data factory workflow. and with that parameter i can apply some pattern to generate files paths. is there any way to pass collection of datetimes parameters to u-sql and apply pattern to generate file paths?
推荐答案
您可以传递多个参数. U-SQL还允许SqlArray<>
类型的参数.我不确定ADF是否支持传递此类类型的值.我认为PowerShell API确实允许.
You can pass multiple parameters. U-SQL also allows parameters of type SqlArray<>
. I am not sure though if ADF supports passing in such typed values. I think the PowerShell APIs do allow it.
我认为将值作为文件传递是行不通的,因为您将无法使用它消除编译时分区.
I assume that passing the values as a file will not work, since you will not get compile time partition elimination with it.
这篇关于通过数据工厂将多个动态参数传递给U-SQL脚本的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!