如何确保AWS Step Function正确执行参数化Athena查询？

我正在尝试在AWS状态机中执行带日期变量的Athena查询，通过Lambda生成%Y-%m-%d格式的日期字符串，用于查询的多个WHERE条件。直接在Athena中执行EXECUTE prepared-statement USING 'date', 'date', 'date';能得到预期结果，但状态机执行时触发如下语法错误：

SYNTAX_ERROR: line 19:37: Unexpected parameters (integer) for function date. Expected: date(varchar(x)) , date(timestamp) , date(timestamp with time zone)

我推测是参数传递方式有误，状态机中已确保将Lambda生成的日期传递给相关状态。状态机流程为：Lambda生成日期 → 获取命名查询 → 创建预处理语句 → 执行带参数的EXECUTE查询（用States.Array生成参数数组），完整配置如下：

{
    "StartAt": "calculate_date",
    "States": {
        "calculate_date": {
            "Type": "Task",
            "Resource": "arn:aws:states:::lambda:invoke",
            "Parameters": {
                "Payload.$": "$",
                "FunctionName": "arn:aws:lambda:::function:calculate_date:$LATEST"
            },
            "Retry": [
                {
                "ErrorEquals": [
                    "Lambda.ServiceException",
                    "Lambda.AWSLambdaException",
                    "Lambda.SdkClientException",
                    "Lambda.TooManyRequestsException"
                ],
                "IntervalSeconds": 2,
                "MaxAttempts": 6,
                "BackoffRate": 2
                }
            ],
            "Next": "get_query",
            "ResultSelector": {
                "ExecDate.$": "$.Payload.body.exec_date"
            }
        },
        "get_query": {
            "Type": "Task",
            "Next": "prepare_query",
            "Parameters": {
                "NamedQueryId": "abc123"
            },
            "Resource": "arn:aws:states:::aws-sdk:athena:getNamedQuery",
            "ResultPath": "$.Payload"
        },
        "prepare_query": {
            "Type": "Task",
            "Next": "execute_query",
            "Parameters": {
                "QueryStatement.$": "$.Payload.NamedQuery.QueryString",
                "StatementName": "PreparedStatementName",
                "WorkGroup": "athena-workgroup"
            },
            "Resource": "arn:aws:states:::aws-sdk:athena:createPreparedStatement",
            "ResultPath": "$.Payload"
        },
        "execute_query": {
            "Type": "Task",
            "Resource": "arn:aws:states:::athena:startQueryExecution",
            "Parameters": {
                "ExecutionParameters.$": "States.Array($.ExecDate, $.ExecDate, $.ExecDate)",
                "QueryExecutionContext": {
                    "Catalog": "catalog_name",
                    "Database": "database_name"
                },
                "QueryString": "EXECUTE PreparedStatementName",
                "WorkGroup": "athena-workgroup",
                "ResultConfiguration": {
                    "OutputLocation": "s3://bucket"
                }
            },
            "End": true
        }
    }
}

状态机执行成功，但查询未将结果导出到指定S3桶，查看Athena查询详情时看到上述错误。请问：

• 我通过States.Array($.ExecDate, $.ExecDate, $.ExecDate)生成ExecutionParameters的方式是否有误？
• 使用createPreparedStatement创建预处理语句时，是否需要特定的查询参数语法？

内容的提问来源于stack exchange，提问作者Andy