CODEWITHSUNDEEP
ignitegridgainin-memory-data-grid
Bitan Biswas
Bitan Biswas

Reputation: 51

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

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?

enter image description here

Upvotes: 0

Views: 145

Answers (1)

Denis Mekhanikov
Denis Mekhanikov

Reputation: 3591

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.

Upvotes: 1

Related Questions