HI Ivan, thanks for the quick reply. Yes it perfectly works as needed with the fix.
Person.Address.Street will not work because person.getPerson().getAddress().getStreet() does not exist. It has to be person.getAddress().getStreet(). So column name should be "Address.street" Any other name does the trick as long as there is alias option provided in SQL, but in SQLFieldQuery I cannot provide alias option so the only option that we are left with is use field name as alias name by default. That way we will be able to rejoin the node. Also just creating field name as "street" will not work as with the same name there could be another column Ex: Person.Address.Street and Person.College.Address.Street. If we use street here then which street we we are referring to ? This fix will take the whole name and use it query to avoid complete ambiguity Please follow the instructions that I have mentioned in my previous email. If you execute those two programs with and with out fix, you can get better idea. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
