Map JSON CDC data in cache value to Ignite sqlline thin client tables

117 Views Asked by At

Basically, I am trying to send CDC JSON data via connectors from Kafka topics to Ignite Cache. And for transformation purpose I want to look up this JSON data in table view in Ignite. How can I map these JSON fields to ignite SQLline table's columns?

1

There are 1 best solutions below

2
On

If I understood your question correctly it should be pretty straightforward. It's possible to leverage Java classes for that. You can specify a structure that would correspond to your JSON structure. Along with the additional cache configuration (CacheConfiguration.setIndexedTypes(…​)) property it will make it SQL-enabled.