CODEWITHSUNDEEP
ignite
Liu Jingyuan
Liu Jingyuan

Reputation: 11

how to add query for simple cache in ignite web console

I am a new developer for apache ignite, When I use web console to query cache. but report the table *** not found. steps as below:

step 1, I start a ignite server node with default port 47500, then create a cache "vapp_user" without dbfactory/dbstore, then put 10000 records to this cache, the key type is Long, value type is User pojo.

step 2, I run the mongodb, the web console agent, web console backend and frontend with dev mode

step 3, in the configuration page, I created the cluster with static ip, and created the cache vapp_user with the domain model with User. the screen as below: model screen

step 4, then add a query with sql "select * from vapp_user" or "select * from User", system reported the error "table *** not found." but I can query related result with Adding Scan. Query Screen

I didn't use import from database to create model, the table need to how to create? use which database?

How to execute the query for the simple cache without any db?

Upvotes: 0

Views: 481

Answers (1)

Evgenii Zhuravlev
Evgenii Zhuravlev

Reputation: 3017

Check that in your cache configuration you have IndexedTypes. Something like:

    userCacheCfg.setIndexedTypes(Long.class, User.class);

In this case query "select * from User" should work.

Check this example.

Upvotes: 1

Related Questions