Hello, 

SQL tables are meant to be flat, why do you need to use nested objects, what
is your goal?

You will have 
Anyway, you can properly flatten your table and get rid of redundant
homeaddress field using  CacheConfiguration.setIndexedTypes
<https://ignite.apache.org/releases/latest/javadoc/org/apache/ignite/configuration/CacheConfiguration.html#setIndexedTypes-java.lang.Class...->
  
or utilize  QueryEntity
<https://apacheignite.readme.io/docs/cache-queries#section-query-configuration-using-queryentity>
  
like this: queryEntity.addQueryField("homeAddress.zip", "java.lang.String",
"ha_zip") and refer to flattened nested column by it's alias ha_zip.

Another approach is to use  BinaryObject
<https://apacheignite.readme.io/docs/binary-marshaller>  .

Here are drawbacks for your reference: 
https://issues.apache.org/jira/browse/IGNITE-6266
https://issues.apache.org/jira/browse/IGNITE-6265



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

Reply via email to