thank afedotov. personCache definition in this xml file.
<bean class="org.apache.ignite.configuration.CacheConfiguration"> <property name="name" value="personCache"></property> <property name="statisticsEnabled" value="true" /> <property name="indexedTypes" value="java.lang.Long, com.howfree.report.model.Person" /> <property name="onheapCacheEnabled" value="true"/> </bean> Used POJO class including spring-data-mongo annotation lilke @Field. @Document public class Person implements Serializable { @Id private String _id; @Field("id") @QuerySqlField(name = "id") private Long id; @Field("biz_date") @QuerySqlField(index = true, name = "biz_date") private Date bizDate; ................................................................... } -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Re-SQL-Syntax-error-in-cross-cache-query-tp15107p15115.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.