数据湖-U SQL我们需要创建具有UTC时间错误输出表达式的out Pramater( Outout )

Question

我们需要使用文件名(例如"filename_utctime“)来生成输出文件。

我们从ADF运行USQL

以下是USQL

    @Orders=
EXTRACT
 OrderID int,
    CustomerID int,
    OrderDetailID int,
    OrderTotal double,
    OrderDate DateTime

 FROM @IN
      USING Extractors.Csv();

@GetLatest=
SELECT 
      OrderID,
    CustomerID,
    OrderDetailID,
    OrderTotal,
    OrderDate,
    ROW_NUMBER() OVER(PARTITION BY OrderID,CustomerID,OrderDetailID ORDER BY OrderDate DESC) AS Rid FROM @Orders;
@FinalOrder=
SELECT 
      OrderID,
    CustomerID,
    OrderDetailID,
    OrderTotal,
    OrderDate
    FROM @GetLatest WHERE Rid==1;
OUTPUT  @FinalOrder 
    TO @OUT
    USING Outputters.Csv();

现在在民主同盟军，我通过了两个Paramters

  "parameters": {
                    "IN": "/OrderDump/Orders.csv",
                    "OUT": {
                        **"value": "/OrderDump/formatDateTime(utcnow(), 'yyyyMMdd')",**
                        "type": "Expression"
                    }
                }

但它不起作用而且会产生错误。我希望当输出文件与当前日期时间相关联时

{ "errorCode": "2703", 
  "message": "Error Id: VertexFailedFast, Error Message: Vertex failed with a fail-fast error. ", 
"failureType": "UserError", 
"target": "Delata" }

Answer 1

在ADF中，您应该使用@concat函数。所以你的表情应该像

@concat('/OrderDump/',formatDateTime(utcnow(),'yyyyMMdd'),'.csv')