Please add a JIRA issue requesting this. A bunch of things are not
supported for functions: returning as a field value, for example.
On Thu, Oct 14, 2010 at 8:31 AM, Tanguy Moal <tanguy.m...@gmail.com> wrote:
> Dear solr-user folks,
>
> I would like to use the stats module to perform very basic statistics
> (mean, min and max) which is actually working just fine.
>
> Nethertheless I found a little limitation that bothers me a tiny bit :
> how to perform the exact same statistics, but on the result of a
> function query rather than a field.
>
> Example :
> schema :
> - string : id
> - float : width
> - float : height
> - float : depth
> - string : color
> - float : price
>
> What I'd like to do is something like :
> select?price:[45.5 TO
> 99.99]&stats=on&stats.facet=color&stats.field={volume=product(product(width,
> height), depth)}
> I would expect to obtain :
>
> <lst name="stats">
> <lst name="stats_fields">
> <lst name="(product(product(width,height),depth))">
> <double name="min">...</double>
> <double name="max">...</double>
> <double name="sum">...</double>
> <long name="count">...</long>
> <long name="missing">...</long>
> <double name="sumOfSquares">...</double>
> <double name="mean">...</double>
> <double name="stddev">...</double>
> <lst name="facets">
> <lst name="color">
> <lst name="white">
> <double name="min">...</double>
> <double name="max">...</double>
> <double name="sum">...</double>
> <long name="count">...</long>
> <long name="missing">...</long>
> <double name="sumOfSquares">...</double>
> <double name="mean">...</double>
> <double name="stddev">...</double>
> </lst>
> <lst name="red">
> <double name="min">...</double>
> <double name="max">...</double>
> <double name="sum">...</double>
> <long name="count">...</long>
> <long name="missing">...</long>
> <double name="sumOfSquares">...</double>
> <double name="mean">...</double>
> <double name="stddev">...</double>
> </lst>
> <!-- Other facets on other colors go here -->
> </lst><!-- end of statistical facets on volumes -->
> </lst><!-- end of stats on volumes -->
> </lst><!-- end of stats_fields node -->
> </lst>
>
> Of course computing the volume can be performed before indexing data,
> but defining virtual fields on the fly given an arbitrary function is
> powerful and I am comfortable with the idea that many others would
> appreciate. Especially for BI needs and so on... :-D
> Is there a way to do it easily that I would have not been able to
> find, or is it actually impossible ?
>
> Thank you very much in advance for your help.
>
> --
> Tanguy
>
--
Lance Norskog
goks...@gmail.com
