Thanks for your reply. Forgot to mention earlier that I am already using @QuerySqlField on each field of my Pojo class so all the fields are appearing as table columns but the hashmap doesn't. So how do i use @QuerySqlField on a hashmap so that each key of hashmap also behaves as a table column which I can use to do an "order by" in my sql.
Thanks Shaleen From: begineer Sent: Monday, 23 April, 3:53 pm Subject: Re: Ignite cache query To: user@ignite.apache.org e.g. public class Student { @QuerySqlField(index=true) int id; @QuerySqlField String name ; @QuerySqlField LocalDateTime dob; @QuerySqlField LocalDate dos; @QuerySqlField Map> map = new HashMap config = new CacheConfiguration cache = ignite.getOrCreateCache(config); DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd H:mm"); LocalDateTime time1= LocalDateTime.now(); String s = time1.format(formatter); LocalDateTime time = LocalDateTime.parse(s, formatter); Map> map = new HashMap query = new SqlQuery list = cache.query(query).getAll().stream().map(Cache.Entry::getValue).collect(Collectors.toList()); -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/