f
>
> All the links for detailed documentation are now broken.
>
>
>
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/Division-with-Stats-Component-when-Grouping-in-Solr-tp4211402p4211751.html
> Sent from the Solr - User mailing list archive at Nabble.com.
tachment/12606793/Search%20Analytics%20Component.pdf
All the links for detailed documentation are now broken.
--
View this message in context:
http://lucene.472066.n3.nabble.com/Division-with-Stats-Component-when-Grouping-in-Solr-tp4211402p4211751.html
Sent from the Solr - User mailing list archive at Nabble.com.
_sum, visits_sum) ... but this doesn't work.
--
View this message in context:
http://lucene.472066.n3.nabble.com/Division-with-Stats-Component-when-Grouping-in-Solr-tp4211402p4211639.html
Sent from the Solr - User mailing list archive at Nabble.com.
message in context:
http://lucene.472066.n3.nabble.com/Division-with-Stats-Component-when-Grouping-in-Solr-tp4211402p4211635.html
Sent from the Solr - User mailing list archive at Nabble.com.
r of results, I would need to
precalculate this (division operation) if they happen to sort on it. I don't
see anything like this mentioned in the api docs, so maybe it's not
possible.
--
View this message in context:
http://lucene.472066.n3.nabble.com/Division-with-Stats-Component-whe
list. I've made a few replies to others that haven't gone through. I
> am not sure if it's because I'm replying via email or what the issue is.
>
>
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/Division-with-Stats-Component-when
472066.n3.nabble.com/Division-with-Stats-Component-when-Grouping-in-Solr-tp4211402p4211631.html
Sent from the Solr - User mailing list archive at Nabble.com.
It would be cool to be able to set 2 group by with facets
>> GROUP BY
>>site_id, keyword
Bill Bell
Sent from mobile
On Jun 13, 2015, at 2:28 PM, Yonik Seeley wrote:
>> GROUP BY
>>site_id, keyword
On Fri, Jun 12, 2015 at 10:30 AM, kingofhypocrites
wrote:
> I am migrating a database from SQL Server to Cassandra. Currently I have a
> setup as follows:
>
> - Log data in Cassandra
> - Summarize data in Spark and put into Cassandra summary tables
> - Query data in Solr
>
> Everything fits beauti
ke so:
>>>>>> > > SELECT
>>>>>> > > site_id,
>>>>>> > > keyword,
>>>>>> > > SUM(visits) as visits,
>>>>>> > > CONVERT(DECIMAL(13, 3), SUM(bounces)) / SUM
gt; > > report_all_keywords_daily
>>>>> > > WHERE
>>>>> > > site_id = 55 AND date_key >= '20150606' AND date_key <=
>>>>> '20150608'
>>>>> > > GROUP BY
>>&g
DER BY visits DESC
>>>> > >
>>>> > > Now I need to replicate this in Solr. The closest I could get to
>>>> this is
>>>> > by
>>>> > > using the Stats component and then using field collapsin
t;> group=true&group.field=keyword&stats=true&stats.field=visits&stats.facet=keyword
>>> >
>>> > >
>>> > > And here are some results I get back:
>>> > > http://pastebin.com/raw.php?i=Fxh
in
>> > SQL:
>> > > <http://lucene.472066.n3.nabble.com/file/n4211402/pic.png>
>> > >
>> > > Is this possible or do I have to give up on the prospect of using
>> Solr?
>> > I
>> > > have to quer
e the functions. Also it seems to ignoring the
> paging
> > > for
> > > the stats results and returns all groups regardless.
> > >
> > > Ultimately I'd like something like this which is what I would get in
> > SQL:
> > > <http://luce
do I have to give up on the prospect of using Solr?
> I
> > have to query this data dynamically so I can't pre-summarize all of it.
> >
> > To clarify I having the following two problems:
> > - Paging is ignored for stats data
> > - I can't figure out how
: However, I need to do able to divide certain metrics. I tried including
: functions in the stats.field such as div(sum(bounce_rate), (sum(visits)) but
: it doesn't recognize the functions. Also it seems to ignoring the paging for
: the stats results and returns all groups regardless.
i'm lost o
ttp://lucene.472066.n3.nabble.com/file/n4211402/pic.png>
>>
>> Is this possible or do I have to give up on the prospect of using Solr? I
>> have to query this data dynamically so I can't pre-summarize all of it.
>>
>> To clarify I having the following two problems:
>> - Paging is ignored for stats data
>> - I can't figure out how to divide two stats together to get a third stat.
>> Note: In some cases I would need to be able to sort on this combined stat
>>
>>
>>
>> --
>> View this message in context:
>> http://lucene.472066.n3.nabble.com/Division-with-Stats-Component-when-Grouping-in-Solr-tp4211402.html
>> Sent from the Solr - User mailing list archive at Nabble.com.
>>
>
>
ing is ignored for stats data
> - I can't figure out how to divide two stats together to get a third stat.
> Note: In some cases I would need to be able to sort on this combined stat
>
>
>
> --
> View this message in context:
> http://lucene.472066.n3.nabble.com/Division-with-Stats-Component-when-Grouping-in-Solr-tp4211402.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>
following two problems:
- Paging is ignored for stats data
- I can't figure out how to divide two stats together to get a third stat.
Note: In some cases I would need to be able to sort on this combined stat
--
View this message in context:
http://lucene.472066.n3.nabble.com/Division-wit
20 matches
Mail list logo
