I haven't run solr with Cassandra myself. I just meant to run elasticsearch as a completely separate service and write there as well.
> On 12 Jun 2017, at 09:45, @Nandan@ <nandanpriyadarshi...@gmail.com> wrote: > > Do you mean to use Elastic Search with Cassandra? > Even I am thinking to use Apache Solr With Cassandra. > In that case I have to create distributed tables such as:- > 1) video_by_title, video_by_actor, video_by_year etc.. > 2) After creating Tables , will have to configure solr core on all tables. > > Is it like this ? > > > > > >> On Mon, Jun 12, 2017 at 3:19 PM, Oskar Kjellin <oskar.kjel...@gmail.com> >> wrote: >> Why not elasticsearch for this use case? It will make your life much simpler >> >> > On 12 Jun 2017, at 04:40, @Nandan@ <nandanpriyadarshi...@gmail.com> wrote: >> > >> > Hi, >> > >> > Currently, I am working on data modeling for Video Company in which we >> > have different types of users as well as different user functionality. >> > But currently, my concern is about Search video module based on different >> > fields. >> > >> > Query patterns are as below:- >> > 1) Select video by actor. >> > 2) select video by producer. >> > 3) select video by music. >> > 4) select video by actor and producer. >> > 5) select video by actor and music. >> > >> > Note: - In short, We want to establish an advanced search module by which >> > we can search by anyway and get the desired results. >> > >> > During a search , we need partial search also such that if any user can >> > search "Harry" title, then we are able to give them result as all videos >> > whose >> > title contains "Harry" at any location. >> > >> > As per my ideas, I have to create separate tables such as video_by_actor, >> > video_by_producer etc.. and implement solr query on all tables. Otherwise, >> > is there any others way by which we can implement this search module >> > effectively. >> > >> > Please suggest. >> > >> > Best regards, >
