lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Frank li <fudon...@gmail.com>
Subject Re: JSON Facet & Analytics API in Solr 5.1
Date Sun, 10 May 2015 07:10:55 GMT
Thank you, Yonik!

Looks cool to me. Only problem is it is not working for me.
I see you have "cats" and "cat" in your URL. "cat" must be a field name.
What is "cats"?

We are doing a POC with facet count ascending. You help is really important
to us.



On Sat, May 9, 2015 at 8:05 AM, Yonik Seeley <yseeley@gmail.com> wrote:

> curl -g "
> http://localhost:8983/solr/techproducts/query?q=*:*&json.facet={cats:{terms:{field:cat,sort:'count+asc'}}}
> "
>
> Using curl with everything in the URL is definitely trickier.
> Everything needs to be URL escaped.  If it's not, curl will often
> silently do nothing.
> For example, when I had sort:'count asc' , the command above would do
> nothing.  When I remembered to URL encode the space as a "+", it
> started working.
>
> It's definitely easier to use "-d" with curl...
>
> curl  "http://localhost:8983/solr/techproducts/query" -d
> 'q=*:*&json.facet={cats:{terms:{field:cat,sort:"count asc"}}}'
>
> That also allows you to format it nicer for reading as well:
>
> curl  "http://localhost:8983/solr/techproducts/query" -d
> 'q=*:*&json.facet=
> {cats:{terms:{
>   field:cat,
>   sort:"count asc"
> }}}'
>
> -Yonik
>
>
> On Thu, May 7, 2015 at 5:32 PM, Frank li <fudongli@gmail.com> wrote:
> > This one does not have problem, but how do I include "sort" in this facet
> > query. Basically, I want to write a solr query which can sort the facet
> > count ascending. Something like "http://localhost:8983/solr
> > /demo/query?q=apple&json.facet={field=price sort='count asc'}
> > <
> http://localhost:8983/solr/demo/query?q=apple&json.facet=%7Bx:%27avg%28price%29%27%7D
> >
> >
> > I really appreciate your help.
> >
> > Frank
> >
> > <
> http://localhost:8983/solr/demo/query?q=apple&json.facet=%7Bx:%27avg%28price%29%27%7D
> >
> >
> > On Thu, May 7, 2015 at 2:24 PM, Yonik Seeley <yseeley@gmail.com> wrote:
> >
> >> On Thu, May 7, 2015 at 4:47 PM, Frank li <fudongli@gmail.com> wrote:
> >> > Hi Yonik,
> >> >
> >> > I am reading your blog. It is helpful. One question for you, for
> >> following
> >> > example,
> >> >
> >> > curl http://localhost:8983/solr/query -d 'q=*:*&rows=0&
> >> >  json.facet={
> >> >    categories:{
> >> >      type : terms,
> >> >      field : cat,
> >> >      sort : { x : desc},
> >> >      facet:{
> >> >        x : "avg(price)",
> >> >        y : "sum(price)"
> >> >      }
> >> >    }
> >> >  }
> >> > '
> >> >
> >> >
> >> > If I want to write it in the format of this:
> >> >
> >>
> http://localhost:8983/solr/query?q=apple&json.facet={x:'avg(campaign_ult_defendant_cnt_is)
> '}
> >> ,
> >> > how do I do?
> >>
> >> What problems do you encounter when you try that?
> >>
> >> If you try that URL with curl, be aware that curly braces {} are
> >> special globbing characters in curl.  Turn them off with the "-g"
> >> option:
> >>
> >> curl -g "
> >>
> http://localhost:8983/solr/demo/query?q=apple&json.facet={x:'avg(price)'}"
> >>
> >> -Yonik
> >>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message