lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Yonik Seeley <ysee...@gmail.com>
Subject Re: JSON Facet & Analytics API in Solr 5.1
Date Sat, 09 May 2015 15:05:26 GMT
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
View raw message