AWS Athena Prepare Statements for Sub Query- SYNTAX_ERROR: line 1:1: Incorrect number of parameters: expected 1 but found 2

0

I am using AWS Athena, I have a subquery like this.

select * from (WITH dataset (json_str) AS (
    VALUES (
            json '{
            "address":{
               "streetAddress":"101",
               "city":"abc",
               "state":"",
               "phoneNumbers":[
                  {
                     "type":"home",
                     "number":"11"
                  },
                  {
                     "type":"city",
                     "number":"4"
                  }
               ]
            }
         }'
        )
) -- query
select street_address,
    city
from (
        select JSON_EXTRACT_SCALAR(json_str, '$.address.streetAddress') as street_address,
            JSON_EXTRACT_SCALAR(json_str, '$.address.city') as city,
            cast(
                JSON_EXTRACT(json_str, '$.address.phoneNumbers') as array(json)
            ) phones
        from dataset
    )
where
    cardinality(
        filter(
            phones,
            js->json_extract_scalar(js, '$.type') = ?    **-- Parameter 1**
                and json_extract_scalar(js, '$.number') = '4'
        )
    ) > 0 ) as  t where t.city =?    **-- Parameter 2**

When in AWS console, it gives me the error: Please find the screenshot

Error Message: SYNTAX_ERROR: line 1:1: Incorrect number of parameters: expected 1 but found 2

enter image description here

질문됨 2년 전96회 조회
답변 없음

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인