Re: SQL Query to Value

2021-02-17 Thread Pavel Tupitsyn
Copying my reply from StackOveflow [1] here. Use `_key` and `_val` keywords to retrieve the entire key and/or value objects. IgniteCache cache = ignite.cache("Person"); SqlFieldsQuery sql = new SqlFieldsQuery( "select _val from Person where age > ?", 28); try (QueryCursor> cursor = cach

SQL Query to Value

2021-02-17 Thread PunxsutawneyPhil3
I have a Postgres database configured as my persistence layer and would like to execute SQL queries against the Postgres tables cached in Ignite. Ideally I'd like to execute a query on these caches and be returned the Value objects t represented by these tables. SqlQuery gives me the functionalit