Search code examples
apache-kafkaksqldb

Kafka sql, structure with key as dot notation

enter image description here

I am having some trouble when trying to access the key with dot notation inside a struct. enter image description here

When I do that, It gives this error.

Solution

  • SOLVED! enter image description here After looking up the JSON structure with "PRINT <topic_name> FROM BEGINNING, I just had to create the structure according to the object in the key "value:".

    I got confused with the data type that was generated with apache avro and forgot that I changed it to JSON, this way it modified the structure.