Ignite2.7 Affinity Key in SQL

[Ajay]

Hi, 

I want to know scenarios, 

1)I want to use ignite affinity key logic to keep homogeneous data in one
place, for this i created bean like

     public class RowID {
        private int id;
        @AffinityKeyMapped
        private int regid;
        ...
        
}

and configured  in xml like,
.....
<property name="queryEntities">
<list>
<bean class="org.apache.ignite.cache.QueryEntity">
<property name="keyType" value="com.sixdee.ignite.RowID"></property>
<property name="valueType" value="persons"></property>
<property name="fields">
<map>
<entry key="subscriber" value="java.lang.String"></entry>
<entry key="orgId" value="java.lang.String"></entry>
<entry key="birthday" value="java.lang.String"></entry>
<entry key="name" value="java.lang.String"></entry>
<entry key="salary" value="java.lang.String"></entry>
<entry key="gender" value="java.lang.String"></entry>
<entry key="key" value="com.sixdee.ignite.RowID"></entry>
</map>
</property>
<property name="keyFields">
<set>
<value>key</value>
</set>
</property>
</bean>
</list>
</property>
......

Now, how i can query the cache with an affinity key in SQL to get the data
directly from the node where it resides.

Note: Actually i want to use affinity key like row key in HBase.


2)Do we need to maintain key also as an entry in map tag? 

3)How I can query(through JDBC) the cache with the fields in RowID(Above
example) in ignite.

Thanks,
Ajay.


Thanks, 
Ajay.



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/