Hi Erick, We are actually comparing the speed of search. We are trying to run this few hive queries in solr. We are if we can implement this in solr definitely we can migrate our system into solr.
Can you please look at this issue also http://stackoverflow.com/questions/24202798/sum-and-groupby-in-solr Here we are removing collect_set() concept. Thanks, Vivek On Thu, Jun 12, 2014 at 7:57 PM, Erick Erickson <erickerick...@gmail.com> wrote: > Any time I see a question like this I break out in hives (little pun > there). > Solr is _not_ a replacement for Hive. Or any other SQL or SQL-like > engine. Trying to make it into one is almost always a mistake. First I'd > ask > why you have to form this query. > > Now, while I have very little knowledge of HIve, collect_set "removes > duplicates" > Why do you have duplicates in the first place? > > Best, > Erick > > On Thu, Jun 12, 2014 at 7:12 AM, Vivekanand Ittigi > <vi...@biginfolabs.com> wrote: > > Hi, > > > > Can anyone please look into this issue. I want to implement this query in > > solr. > > > > Thanks, > > Vivek > > > > ---------- Forwarded message ---------- > > From: Vivekanand Ittigi <vi...@biginfolabs.com> > > Date: Thu, Jun 12, 2014 at 11:08 AM > > Subject: Implementing Hive query in Solr > > To: "solr-user@lucene.apache.org" <solr-user@lucene.apache.org> > > > > > > Hi, > > > > My requirements is to execute this query(hive) in solr: > > > > select SUM(Primary_cause_vaR),collect_set(skuType),RiskType,market, > > collect_set(primary_cause) from bil_tos Where skuType='Product' group by > > RiskType,market; > > > > I can implement sum and groupBy operations in solr using StatsComponent > > concept but i've no idea to implement collect_set() in solr. > > > > Collect_set() is used in Hive queries. > > Please provide me equivalent function for collect_set in solr or links or > > how to achieve it. It'd be a great help. > > > > > > Thanks, > > Vivek >
