Can we do group by and join on Predicate or Distributed SQL under hazelcast

[mukul panwar]

Hi 

Please suggest , Can we do group by and join on Predicate or Distributed SQL under hazelcast ?

Thanks

[mukul panwar]

Would you suggest about this ?

[Jaromir Hamala]

Hi Mukui,

there is no support for Join/Group by in Hazelcast Query Language. My recommendation is to denormalize your data. This is a great book on this subject, some key points are available online at http://martinfowler.com/articles/nosqlKeyPoints.html

You can use aggregations if you want, but I'd still try to simplify your data model. 

Cheers,

Jaromir

[mukul panwar]

ok thanks for suggestion, in future , can we expect like this :).