You may have to implement this yourself. In Solr 4.9 you'll be able to implement your own analytic functions in java and plug them in using the AnalyticsQuery API. This is a new Solr API for plugging in custom analytics.
http://heliosearch.org/solrs-new-analyticsquery-api/ Joel Bernstein Search Engineer at Heliosearch On Thu, Jun 12, 2014 at 10:27 AM, 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 >
