[jira] [Updated] (SOLR-5546) Add the aggregate function in the faceted function

2013-12-20 Thread Raintung Li (JIRA)

 [ 
https://issues.apache.org/jira/browse/SOLR-5546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Raintung Li updated SOLR-5546:
--

Description: 
Faceted only provide the count for different type in one field, sometimes we 
will want to aggregate the other field in the same faceted not only count.

The API maybe can use: 
Date Query:
facet=truefacet.date=tTransDatefacet.date.start=NOW/MONTH-12MONTHSfacet.date.end=NOWfacet.date.gap=%2B1MONTHf.tTransDate.facet.sum.field=amountMoneyf.tTransDate.facet.max.field=amountMoney

Query:
facet=truefacet.query=amountMoney:[*+TO+500]facet.query=amountMoney:[500+TO+*]f.query.facet.sum.field=amountMoney

Range:
facet.range=amountMoneyf.amountMoney.facet.range.start=0f.amountMoney.facet.range.end=1000f.amountMoney.facet.range.gap=100f.amountMoney.facet.sum.field=amountMoney

Field:
facet=truefacet.field=amountMoneyf.amountMoney.facet.sum.field=amountMoney


facetd.rt=sum(field1),max(field2),count

that means:
Response XML will be

lst name=count
int name=2007-08-11T00:00:00.000Z1/int
int name=2007-08-12T00:00:00.000Z5/int
int name=2007-08-13T00:00:00.000Z3/int
int name=2007-08-14T00:00:00.000Z7/int
int name=2007-08-15T00:00:00.000Z2/int
int name=2007-08-16T00:00:00.000Z16/int
  /lst
lst name=sum.field1
int name=2007-08-11T00:00:00.000Z1/int
int name=2007-08-12T00:00:00.000Z5/int
int name=2007-08-13T00:00:00.000Z3/int
int name=2007-08-14T00:00:00.000Z7/int
int name=2007-08-15T00:00:00.000Z2/int
int name=2007-08-16T00:00:00.000Z16/int
  /lst
lst name=max.field2
int name=2007-08-11T00:00:00.000Z1/int
int name=2007-08-12T00:00:00.000Z5/int
int name=2007-08-13T00:00:00.000Z3/int
int name=2007-08-14T00:00:00.000Z7/int
int name=2007-08-15T00:00:00.000Z2/int
int name=2007-08-16T00:00:00.000Z16/int
  /lst


  was:
Faceted only provide the count for different type in one field, sometimes we 
will want to aggregate the other field in the same faceted not only count.

The API maybe can use
facetd.rt=sum(field1),max(field2),count

that means:
Response XML will be

lst name=count
int name=2007-08-11T00:00:00.000Z1/int
int name=2007-08-12T00:00:00.000Z5/int
int name=2007-08-13T00:00:00.000Z3/int
int name=2007-08-14T00:00:00.000Z7/int
int name=2007-08-15T00:00:00.000Z2/int
int name=2007-08-16T00:00:00.000Z16/int
  /lst
lst name=sum(field1)
int name=2007-08-11T00:00:00.000Z1/int
int name=2007-08-12T00:00:00.000Z5/int
int name=2007-08-13T00:00:00.000Z3/int
int name=2007-08-14T00:00:00.000Z7/int
int name=2007-08-15T00:00:00.000Z2/int
int name=2007-08-16T00:00:00.000Z16/int
  /lst
lst name=max(field2)
int name=2007-08-11T00:00:00.000Z1/int
int name=2007-08-12T00:00:00.000Z5/int
int name=2007-08-13T00:00:00.000Z3/int
int name=2007-08-14T00:00:00.000Z7/int
int name=2007-08-15T00:00:00.000Z2/int
int name=2007-08-16T00:00:00.000Z16/int
  /lst



 Add the aggregate function in the faceted function
 --

 Key: SOLR-5546
 URL: https://issues.apache.org/jira/browse/SOLR-5546
 Project: Solr
  Issue Type: Improvement
  Components: contrib - Clustering
Affects Versions: 4.5.1
Reporter: Raintung Li

 Faceted only provide the count for different type in one field, sometimes we 
 will want to aggregate the other field in the same faceted not only count.
 The API maybe can use: 
 Date Query:
 facet=truefacet.date=tTransDatefacet.date.start=NOW/MONTH-12MONTHSfacet.date.end=NOWfacet.date.gap=%2B1MONTHf.tTransDate.facet.sum.field=amountMoneyf.tTransDate.facet.max.field=amountMoney
 Query:
 facet=truefacet.query=amountMoney:[*+TO+500]facet.query=amountMoney:[500+TO+*]f.query.facet.sum.field=amountMoney
 Range:
 facet.range=amountMoneyf.amountMoney.facet.range.start=0f.amountMoney.facet.range.end=1000f.amountMoney.facet.range.gap=100f.amountMoney.facet.sum.field=amountMoney
 Field:
 facet=truefacet.field=amountMoneyf.amountMoney.facet.sum.field=amountMoney
 facetd.rt=sum(field1),max(field2),count
 that means:
 Response XML will be
 lst name=count
 int name=2007-08-11T00:00:00.000Z1/int
 int name=2007-08-12T00:00:00.000Z5/int
 int name=2007-08-13T00:00:00.000Z3/int
 int name=2007-08-14T00:00:00.000Z7/int
 int name=2007-08-15T00:00:00.000Z2/int
 int name=2007-08-16T00:00:00.000Z16/int
   /lst
 lst name=sum.field1
 int name=2007-08-11T00:00:00.000Z1/int
 int name=2007-08-12T00:00:00.000Z5/int
 int name=2007-08-13T00:00:00.000Z3/int
 int name=2007-08-14T00:00:00.000Z7/int
 int name=2007-08-15T00:00:00.000Z2/int
 int name=2007-08-16T00:00:00.000Z16/int
   

[jira] [Updated] (SOLR-5546) Add the aggregate function in the faceted function

2013-12-11 Thread Raintung Li (JIRA)

 [ 
https://issues.apache.org/jira/browse/SOLR-5546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Raintung Li updated SOLR-5546:
--

Description: 
Faceted only provide the count for different type in one field, sometimes we 
will want to aggregate the other field in the same faceted not only count.

The API maybe can use
facetd.rt=sum(field1),max(field2),count

that means:
Response XML will be

lst name=count
int name=2007-08-11T00:00:00.000Z1/int
int name=2007-08-12T00:00:00.000Z5/int
int name=2007-08-13T00:00:00.000Z3/int
int name=2007-08-14T00:00:00.000Z7/int
int name=2007-08-15T00:00:00.000Z2/int
int name=2007-08-16T00:00:00.000Z16/int
  /lst
lst name=sum(field1)
int name=2007-08-11T00:00:00.000Z1/int
int name=2007-08-12T00:00:00.000Z5/int
int name=2007-08-13T00:00:00.000Z3/int
int name=2007-08-14T00:00:00.000Z7/int
int name=2007-08-15T00:00:00.000Z2/int
int name=2007-08-16T00:00:00.000Z16/int
  /lst
lst name=max(field1)
int name=2007-08-11T00:00:00.000Z1/int
int name=2007-08-12T00:00:00.000Z5/int
int name=2007-08-13T00:00:00.000Z3/int
int name=2007-08-14T00:00:00.000Z7/int
int name=2007-08-15T00:00:00.000Z2/int
int name=2007-08-16T00:00:00.000Z16/int
  /lst


 Add the aggregate function in the faceted function
 --

 Key: SOLR-5546
 URL: https://issues.apache.org/jira/browse/SOLR-5546
 Project: Solr
  Issue Type: Improvement
  Components: contrib - Clustering
Affects Versions: 4.5.1
Reporter: Raintung Li

 Faceted only provide the count for different type in one field, sometimes we 
 will want to aggregate the other field in the same faceted not only count.
 The API maybe can use
 facetd.rt=sum(field1),max(field2),count
 that means:
 Response XML will be
 lst name=count
 int name=2007-08-11T00:00:00.000Z1/int
 int name=2007-08-12T00:00:00.000Z5/int
 int name=2007-08-13T00:00:00.000Z3/int
 int name=2007-08-14T00:00:00.000Z7/int
 int name=2007-08-15T00:00:00.000Z2/int
 int name=2007-08-16T00:00:00.000Z16/int
   /lst
 lst name=sum(field1)
 int name=2007-08-11T00:00:00.000Z1/int
 int name=2007-08-12T00:00:00.000Z5/int
 int name=2007-08-13T00:00:00.000Z3/int
 int name=2007-08-14T00:00:00.000Z7/int
 int name=2007-08-15T00:00:00.000Z2/int
 int name=2007-08-16T00:00:00.000Z16/int
   /lst
 lst name=max(field1)
 int name=2007-08-11T00:00:00.000Z1/int
 int name=2007-08-12T00:00:00.000Z5/int
 int name=2007-08-13T00:00:00.000Z3/int
 int name=2007-08-14T00:00:00.000Z7/int
 int name=2007-08-15T00:00:00.000Z2/int
 int name=2007-08-16T00:00:00.000Z16/int
   /lst



--
This message was sent by Atlassian JIRA
(v6.1.4#6159)

-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org



[jira] [Updated] (SOLR-5546) Add the aggregate function in the faceted function

2013-12-11 Thread Raintung Li (JIRA)

 [ 
https://issues.apache.org/jira/browse/SOLR-5546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Raintung Li updated SOLR-5546:
--

Description: 
Faceted only provide the count for different type in one field, sometimes we 
will want to aggregate the other field in the same faceted not only count.

The API maybe can use
facetd.rt=sum(field1),max(field2),count

that means:
Response XML will be

lst name=count
int name=2007-08-11T00:00:00.000Z1/int
int name=2007-08-12T00:00:00.000Z5/int
int name=2007-08-13T00:00:00.000Z3/int
int name=2007-08-14T00:00:00.000Z7/int
int name=2007-08-15T00:00:00.000Z2/int
int name=2007-08-16T00:00:00.000Z16/int
  /lst
lst name=sum(field1)
int name=2007-08-11T00:00:00.000Z1/int
int name=2007-08-12T00:00:00.000Z5/int
int name=2007-08-13T00:00:00.000Z3/int
int name=2007-08-14T00:00:00.000Z7/int
int name=2007-08-15T00:00:00.000Z2/int
int name=2007-08-16T00:00:00.000Z16/int
  /lst
lst name=max(field2)
int name=2007-08-11T00:00:00.000Z1/int
int name=2007-08-12T00:00:00.000Z5/int
int name=2007-08-13T00:00:00.000Z3/int
int name=2007-08-14T00:00:00.000Z7/int
int name=2007-08-15T00:00:00.000Z2/int
int name=2007-08-16T00:00:00.000Z16/int
  /lst


  was:
Faceted only provide the count for different type in one field, sometimes we 
will want to aggregate the other field in the same faceted not only count.

The API maybe can use
facetd.rt=sum(field1),max(field2),count

that means:
Response XML will be

lst name=count
int name=2007-08-11T00:00:00.000Z1/int
int name=2007-08-12T00:00:00.000Z5/int
int name=2007-08-13T00:00:00.000Z3/int
int name=2007-08-14T00:00:00.000Z7/int
int name=2007-08-15T00:00:00.000Z2/int
int name=2007-08-16T00:00:00.000Z16/int
  /lst
lst name=sum(field1)
int name=2007-08-11T00:00:00.000Z1/int
int name=2007-08-12T00:00:00.000Z5/int
int name=2007-08-13T00:00:00.000Z3/int
int name=2007-08-14T00:00:00.000Z7/int
int name=2007-08-15T00:00:00.000Z2/int
int name=2007-08-16T00:00:00.000Z16/int
  /lst
lst name=max(field1)
int name=2007-08-11T00:00:00.000Z1/int
int name=2007-08-12T00:00:00.000Z5/int
int name=2007-08-13T00:00:00.000Z3/int
int name=2007-08-14T00:00:00.000Z7/int
int name=2007-08-15T00:00:00.000Z2/int
int name=2007-08-16T00:00:00.000Z16/int
  /lst



 Add the aggregate function in the faceted function
 --

 Key: SOLR-5546
 URL: https://issues.apache.org/jira/browse/SOLR-5546
 Project: Solr
  Issue Type: Improvement
  Components: contrib - Clustering
Affects Versions: 4.5.1
Reporter: Raintung Li

 Faceted only provide the count for different type in one field, sometimes we 
 will want to aggregate the other field in the same faceted not only count.
 The API maybe can use
 facetd.rt=sum(field1),max(field2),count
 that means:
 Response XML will be
 lst name=count
 int name=2007-08-11T00:00:00.000Z1/int
 int name=2007-08-12T00:00:00.000Z5/int
 int name=2007-08-13T00:00:00.000Z3/int
 int name=2007-08-14T00:00:00.000Z7/int
 int name=2007-08-15T00:00:00.000Z2/int
 int name=2007-08-16T00:00:00.000Z16/int
   /lst
 lst name=sum(field1)
 int name=2007-08-11T00:00:00.000Z1/int
 int name=2007-08-12T00:00:00.000Z5/int
 int name=2007-08-13T00:00:00.000Z3/int
 int name=2007-08-14T00:00:00.000Z7/int
 int name=2007-08-15T00:00:00.000Z2/int
 int name=2007-08-16T00:00:00.000Z16/int
   /lst
 lst name=max(field2)
 int name=2007-08-11T00:00:00.000Z1/int
 int name=2007-08-12T00:00:00.000Z5/int
 int name=2007-08-13T00:00:00.000Z3/int
 int name=2007-08-14T00:00:00.000Z7/int
 int name=2007-08-15T00:00:00.000Z2/int
 int name=2007-08-16T00:00:00.000Z16/int
   /lst



--
This message was sent by Atlassian JIRA
(v6.1.4#6159)

-
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org