Hi Michael,
Thanks for helping me to figure this out.
If I fire:
{
"query" : "*:*",
"limit" : 0,
"facet": {
"aip": { "query": "cfname2:aip", }
}
}
I get
"response": { "numFound": 20560849, "start": 0, "numFoundExact": true,
"docs": [] }, "facets": { "count": 20560849, "aip": { "count": 2307 } } }
(works). If I fire
{
"query" : "*:*",
"limit" : 0,
"facet": {
"t_buckets": {
"type": "range",
"field": "t",
"sort": { "t": "asc" },
"start": "2018-05-02T17:00:00.000Z",
"end": "2020-11-16T21:00:00.000Z",
"gap": "+1HOUR"
"limit": 1
}
}
}
I get
"response": { "numFound": 20560849, "start": 0, "numFoundExact": true,
"docs": [] }, "facets": { "count": 20560849, "t_buckets": { "buckets": [ {
"val": "2018-05-02T17:00:00Z", "count": 150 },
(works). If I fire:
{
"query" : "*:*",
"limit" : 0,
"facet": {
"aip": { "query": "cfname2:aip",
"facet": {
"t_buckets": {
"type": "range",
"field": "t",
"sort": { "t": "asc" },
"start": "2018-05-02T17:00:00.000Z",
"end": "2020-11-16T21:00:00.000Z",
"gap": "+1HOUR"
"limit": 1
}
}
}
}
}
I get
"error": { "metadata": [ "error-class",
"org.apache.solr.common.SolrException", "root-error-class",
"org.apache.solr.common.SolrException" ], "msg": "expected facet/stat type
name, like {type:range, field:price, ...} but got null , path=/facet",
"code": 400 } }
If I fire
{
"query" : "*:*",
"limit" : 0,
"facet": {
"aip": { "query": "cfname2:aip",
"facet": {
"type": "range",
"field": "t",
"sort": { "t": "asc" },
"start": "2018-05-02T17:00:00.000Z",
"end": "2020-11-16T21:00:00.000Z",
"gap": "+1HOUR"
"limit": 1
}
}
}
}
I get
"error": { "metadata": [ "error-class",
"org.apache.solr.common.SolrException", "root-error-class",
"org.apache.solr.common.SolrException" ], "msg": "expected facet/stat type
name, like {type:range, field:price, ...} but got null , path=/facet",
"code": 400 } }
What else can I try out?
Cheers,
Arturas
On Thu, Dec 3, 2020 at 3:55 PM Michael Gibney <mich...@michaelgibney.net>
wrote:
> Arturas,
> I think your syntax is wrong for the range subfacet? -- the configuration
> of the range facet should be directly under the `tt` key, rather than
> nested under `t_buckets` in the request. (The response introduces a
> "buckets" attribute that is not part of the request syntax).
> Michael
>
> On Thu, Dec 3, 2020 at 3:47 AM Arturas Mazeika <maze...@gmail.com> wrote:
>
> > Hi Solr Team,
> >
> > I am trying to check how I can formulate facet queries using JSON
> format. I
> > can successfully formulate query, range, term queries, as well as nested
> > term queries. How can I formulate a nested facet query involving "query"
> as
> > well as "range" formulations? The following does not work:
> >
> >
> > GET http://localhost:5555/solr/db/query HTTP/1.1
> > content-type: application/json
> >
> > {
> > "query" : "*:*",
> > "limit" : 0,
> > "facet": {
> > "a1": { "query": "cfname2:1" },
> > "a2": { "query": "cfname2:2" },
> > "a3": { "field": "cfname2", "type":"terms", "prefix":"3" },
> > "a4": { "query": "cfname2:4" },
> > "a5": { "query": "cfname2:5" },
> > "a6": { "query": "cfname2:6" },
> >
> > "tt": {
> > "t_buckets": {
> > "type": "range",
> > "field": "t",
> > "sort": { "t": "asc" },
> > "start": "2018-05-02T17:00:00.000Z",
> > "end": "2020-11-16T21:00:00.000Z",
> > "gap": "+1HOUR"
> > }
> > }
> > }
> > }
> >
> > Single (not nested facets separately on individual queries as well as for
> > range) work in flying colors.
> >
> > Cheers,
> > Arturas
> >
>
