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, >
