select query and criteria without join - kundera cassandra

[JoshiManjila]

Dear sir,

We are still testing kundera - cassandra as jpa provider for nosql . As far as we done, it didn't support join queries at both select query and criteria api. In our project we would really need some filters whose values depend on associated entities .

eg. select * from doctor where doctor.schedule.availability="Monday"

Please share your work around for the above if we are using kundera-cassandra as jpa provider.

Joshi

[karthikprasad13]

Hi @JoshiManjila

Kundera does not support join queries as of now. We definitely have this in our road map and will be implemented in our future releases.

-Karthik

[mevivs]

@JoshiManjila Do you really need joins? There is no direct support with Cassandra or NoSQL world. Probably that's the reason people moving to NoSQL powered solution rather than sticking to RDBMS.

Every such join support would require intensive in-memory operation and better to opt for external inverted indexing mechanism such as Solr powered block join or aggregation strategy with ES for the same.

Later, -Vivek

[karthikprasad13]

@JoshiManjila

You can achieve joins in Cassandra using Kundera-Spark-Cassandra module. Please refer Spark-Cassandra wiki for more info.

-Karthik

[idofmrsandeep]

Hi, Do Still kundera dont support joins without spark. We are planning to run kundera in Java layer (In weblogic server), so will we get any joins feature in this layer ?

[karthikprasad13]

Hi Sandeep,

There is no support for joins in Kundera, you can use spark or remodel your database entities.

-Karthik