HI all, having the hardest time trying to consume ...
# troubleshooting
r
HI all, having the hardest time trying to consume this message from Kafka using flink-sql. What would the declaration for the source table look like for the following json:
Copy code
[
  {
    "BankID": "B0136",
    "LoanNumber": 331751,
    "SpvType": "SNR",
    "Workflow": 1,
    "TerminationDate": "2024-05-13T15:00:48.702424-04:00"
  }
]
Thanks in advance for any help.
p
is it always an array? If so, do you want to get only the first elements?
r
It is always an array. No, I want to get all elements. It is not working with flink sql Array<Row(.... It only works if the array is prefix with a name. It is not my event, I can't have them change it. Is there a way to get it sort of anonymously, in other words without a column name.