This way if we insert gnite.binary().builder("ANY_STRING_HERE"); builder.setField("id", 1); builder.setField("name", "John");
We wont be able to retrieve the data thru SQL API. I did the same, but I dont see the records which I inserted thru Binary API by using the above. We get this error while inserting it [2020-12-29 12:04:47,862][WARN ][sys-stripe-7-#8][GridQueryProcessor] Key-value pair is not inserted into any SQL table [cacheName=TEST_STATS_NAVEEN_NO_VAL, expValType=SQL_PUBLIC_TEST_STATS_NAVEEN_NO_VAL_532f9920_b7a2_43de_b6a2_2f45ad8d5c2a, actualValType=TestStatsNaveen] It does expects the same value_type which Ignite has assigned when the table was created. However ScanQuery returns all the rows, guess it does the table scan. Am i missing something or its fair understanding on how this work Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/