Not getting the column access in Ignite Cache created and loaded from Oracle

Question

I am doing a POC to ingest data from Oracle to Ignite cluster and Fetch the data from Ignite in another application. When I created the Model and Cache, I specified the Key as String and value as Custom Object. Data loaded to cluster but then I querying "SELECT * FROM TB_USER" I am getting only two column, i.e. _KEY and _VAL. I am trying to get all the column from the TB_USER. What are the configuration required for this?

Answer 1

There are three ways of configuring SQL tables in Ignite:

1. DDL statements (create table). As far as I can see, you used something else.
2. QueryEntities. You should enlist all columns that you want to see in your table in the QueryEntity#fields property. All names should correspond to field names of your Java objects.
3. Annotations. Fields, that are annotated as @QuerySqlField will become columns in your table.