我试图根据嵌套在数组中的对象的值来过滤Kafka Lenses中的记录。我想查找所有带有工程师“id”的记录：数组中的“555”。这是两个示例记录，我想获得工程师的索引与“id”：“555”在每个记录中可能不同
记录A

{
  "payload": {
    "Data": {
      "project": "A"
    },
    "engineer": [
      {
        "name": "Jerry",
        "id": "111",
        "join_date":"12-10-2020"
      },
      {
        "name": "Fanny",
        "id": "555",
        "join_date":"11-23-2020"
      }
    ]
  }
}

记录B

{
  "payload": {
    "Data": {
      "project": "B"
    },
    "engineer": [
      {
        "name":"Fanny",
        "id": "555",
        "join_date":"10-18-2021"
      },
      {
        "name":"Terry",
        "id": "999",
        "join_date":"10-26-2020"
      }
    ]
  }
}

很明显，我不能执行像ARRAY_CONTAINS或

SELECT * 
FROM topic_name
WHERE payload.engineer[*].id = "555" 
LIMIT 10