Re: Implementing Hive query in Solr

2014-06-15 Thread Vivekanand Ittigi
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-i

Re: Implementing Hive query in Solr

2014-06-12 Thread Joel Bernstein
Yeah, solr-jdbc does look interesting. Has an Apache license as well. Joel Bernstein Search Engineer at Heliosearch On Thu, Jun 12, 2014 at 1:18 PM, Mikhail Khludnev < mkhlud...@griddynamics.com> wrote: > Hello, > > I've found https://github.com/kawasima/solr-jdbc recently. Haven't checked > it

Re: Implementing Hive query in Solr

2014-06-12 Thread Mikhail Khludnev
Hello, I've found https://github.com/kawasima/solr-jdbc recently. Haven't checked it so far, but the idea is fairly cool. I wonder if it can be relevant to your challenge. On Thu, Jun 12, 2014 at 9:38 AM, Vivekanand Ittigi wrote: > Hi, > > My requirements is to execute this query(hive) in solr

Re: Implementing Hive query in Solr

2014-06-12 Thread Joel Bernstein
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 E

Re: Implementing Hive query in Solr

2014-06-12 Thread Erick Erickson
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 H