脚本路径
但是我得到了一个错误,我搜索了它,我发现ADL在管道中不受支持,所以我想在管道中使用
财产。我试着用这个脚本来做这个,但我得到了一个错误,我不能部署它,所以任何人都可以帮助这样做?
以下是我的管道脚本:
{
"name": "RG-GatherData",
"properties": {
"description": "description",
"activities": [
{
"name": "DataLakeAnalyticsUSqlActivityTemplate",
"type": "DataLakeAnalyticsU-SQL",
"linkedServiceName": "AzureDataLakeAnalyticsLinkedService",
"typeProperties": {
"script": "
@log = EXTRACT ["VersionID"] int,
["NodeName"] string,
["UpdateIng Area"] string,
["ActionDate"] string,
["UserName"] string,
["Code part Type"] string,
["DocCode"] string,
["Header Entity Id"] string,
["Common Entity Id"] string,
["Attribute Name"] string,
["Latest Update Value"] string,
["Previous Update Value"] string
FROM @in
USING Extractors.Csv(skipFirstNRows: 1);
OUTPUT @log
TO @out
USING Outputters.Csv();
,
"degreeOfParallelism": 3,
"priority": 100,
"parameters": {
"in": "/RowLogs/InPut/RoyalGardens/{*}.csv",
"out": "/RowLogs/OutPut/RoyalGardens/Alllog.csv"
}
},
"policy": {
"concurrency": 1,
"executionPriorityOrder": "OldestFirst",
"retry": 3,
"timeout": "10:00:00"
},
"scheduler": {
"frequency": "Day",
"interval": 1
}
}
],
"start": "2018-09-20T00:06:00Z",
"end": "2099-12-30T22:00:00Z"
}
}