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:39:08 GMT
I figured it out now. It works. "cats" just a name, right? It does not
matter what is used.

Really appreciate your help. This is going to be really useful. I meant
"json.facet".

On Sun, May 10, 2015 at 12:13 AM, Frank li <fudongli@gmail.com> wrote:

> Here is our SOLR query:
>
>
> http://qa-solr:8080/solr/select?q=type:PortalCase&json.facet={categories:{terms:{field:campaign_id_ls,sort:%27count+asc%27}}}&rows=0
> <http://qa-solr:8080/solr/select?q=type:PortalCase&json.facet=%7Bcategories:%7Bterms:%7Bfield:campaign_id_ls,sort:%27count+asc%27%7D%7D%7D&rows=0>
>
> I replaced "cats" with "categories". It is still not working.
>
> On Sun, May 10, 2015 at 12:10 AM, Frank li <fudongli@gmail.com> wrote:
>
>> 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'}}}
>>> <http://localhost:8983/solr/techproducts/query?q=*:*&json.facet=%7Bcats:%7Bterms:%7Bfield:cat,sort:'count+asc'%7D%7D%7D>
>>> "
>>>
>>> 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