代码之家  ›  专栏  ›  技术社区  ›  Abdelmoamen

在数据工厂管道中运行DataLakeAnalyticsU SQL脚本

  •  0
  • Abdelmoamen  · 技术社区  · 6 年前

    脚本路径 但是我得到了一个错误,我搜索了它,我发现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"
            }
        }
    
    1 回复  |  直到 6 年前
        1
  •  0
  •   Joel Cochran    6 年前

    将U-SQL脚本存储在Blob存储中,并通过Blob存储链接服务引用它。