Hi Prasad, >Does it mean that it stores the data in table as well as in key value cache? I meant to say that does it duplicates the data?
There's no data duplication, everything is stored in ignite cache only. SQL is just another way access to data. Plus SQL provides indices. >In which format does it store the table rows or column values? it stores everything as key/values pairs. >When I fire a sql on table using jdbc approach, does it require to de-serialize the data while doing index scan? no, it doesn't de-serialize data, ignite stores everything as bytes and can compare those data as bytes too without de-serialization to the original type. >If I do not map the table to Java pojo, does this store the key and value in Binary Object format in respective cache? right, anyway, it will store everything in cache, you don't need java objects for this, ignite will use, as you said, binary objects. >When I fire a sql (using SqlFieldsQuery) directly on a cache which sits on top of this table, does it require de-serialization of value? Ignite only will de-serialize only part of data that you specified in SELECT statement that needs to be returned to you. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
