Dear team,
I was attempting to update the Health Events Dashboard from v2.1.0 to v3.0.0 and got the following error several times, even while trying with cid-cmd update --force.
This issue is present in stack v4.4.11 (v4.4.12 could not yet be tested as we have another issue deploying it - see issue #1484 )
Athena query status failed : line 37:10: Unexpected parameters (array(varchar), varchar(4)) for function json_extract_scalar. Expected: json_extract_scalar(varchar(x), jsonpath), json_extract_scalar(json, jsonpath)
Looking at the health_events_detail_data table, it appears that the "personas" column is already of type array(varchar) and not json text, so the json_extract_scalar doesn't seem to be needed.
Replacing code in the lines 37-40 with the equivalent TRY(("personas")[X]) "persona_0X" expressions fixed the issue for me.
I will submit a PR with the fix.
Thanks and best regards,
Cédric
Dear team,
I was attempting to update the Health Events Dashboard from v2.1.0 to v3.0.0 and got the following error several times, even while trying with cid-cmd update --force.
This issue is present in stack v4.4.11 (v4.4.12 could not yet be tested as we have another issue deploying it - see issue #1484 )
Athena query status failed : line 37:10: Unexpected parameters (array(varchar), varchar(4)) for function json_extract_scalar. Expected: json_extract_scalar(varchar(x), jsonpath), json_extract_scalar(json, jsonpath)
Looking at the health_events_detail_data table, it appears that the "personas" column is already of type array(varchar) and not json text, so the json_extract_scalar doesn't seem to be needed.
Replacing code in the lines 37-40 with the equivalent TRY(("personas")[X]) "persona_0X" expressions fixed the issue for me.
I will submit a PR with the fix.
Thanks and best regards,
Cédric