Re: Failed to Scan query data by partition index after insert data using DML

2021-05-13 Thread Ilya Kasnacheev
Hello! You need to either use .withKeepBinary(), or provide a Java class with same fields as your table value has, so that it can be natively mapped. Please see https://www.gridgain.com/docs/latest/developers-guide/SQL/sql-key-value-storage Regards, -- Ilya Kasnacheev сб, 8 мая 2021 г. в 03:0

Re: Failed to Scan query data by partition index after insert data using DML

2021-05-11 Thread Taras Ledkov
Hi, Please provide steps to reproduce. I don't catch a case by the stacktrace. On 08.05.2021 3:02, Henric wrote: Hi, Thanks for replay I tried to used cache_name, but I still get Exception as below, I have specify the cache name, I don't know why I still get this error. I tried to set WRAP_VALU

Re: Failed to Scan query data by partition index after insert data using DML

2021-05-07 Thread Henric
Hi, Thanks for replay I tried to used cache_name, but I still get Exception as below, I have specify the cache name, I don't know why I still get this error. I tried to set WRAP_VALUE to false, but it only works for single column. Did I miss something important? Caused by: class org.apache.ignite.

Re: Failed to Scan query data by partition index after insert data using DML

2021-05-07 Thread Taras Ledkov
Hi, Please take a look at the documentation of the CREATE TABLE [1] Use: CREATE TABLE tableName (id LONG PRIMARY KEY, name VARCHAR) WITH "|CACHE_NAME=|cacheName" Please pay attention to other options. Its may be useful to use cache API & SQL together. Also be careful when you use cache API &

Failed to Scan query data by partition index after insert data using DML

2021-05-07 Thread Henric
I tried to query data by partition index, when I insert data using cache API, I can get data successfully, when I insert data using DML, I can't get data. *I can get data by partition index using cache API* IgniteCache cache = ignite.getOrCreateCache("cacheName"); cache.put(1, "v1"); ScanQuery sq