Multiple facets error

Adam_Lebsack · April 25, 2013, 12:15pm

I'm trying to query with multiple facets in a query. I've posted the query
and subsequent error
here: https://gist.github.com/alebsack/fc8f0b377c1ca1e780fd

The query works if I remove one of the facets. Is the format correct? Is
it possible to use more than one facet? I'm using tire to form the query,
and it seems to be creating the query correctly per the documentation. Is
this a bug, or am I in fact doing something wrong?

ES version: 0.20.6
OS: OS X Lion 10.8.3

Regards,
Adam

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Yehuda_Zargarov · April 25, 2013, 12:38pm

There is no problem creating as much facets as you want.

Try removing the second facet called 'inactive_2w' (on which you get the
error) and see if you still get the same error..

BTW why do you have an 'and' filter in the query section when you only have
1 condition?

On Thursday, April 25, 2013 3:15:34 PM UTC+3, Adam Lebsack wrote:

I'm trying to query with multiple facets in a query. I've posted the
query and subsequent error here:
Multiple facets error · GitHub

The query works if I remove one of the facets. Is the format correct? Is
it possible to use more than one facet? I'm using tire to form the query,
and it seems to be creating the query correctly per the documentation. Is
this a bug, or am I in fact doing something wrong?

ES version: 0.20.6
OS: OS X Lion 10.8.3

Regards,
Adam

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Adam_Lebsack · April 25, 2013, 12:50pm

Like I mentioned, the query works properly if I remove one of the facets,
so I've tried removing the 'inactive_2w' already.

As for the query, the "and" is put there by tire when I do:

  query do
    filtered do
      query { all }
      filter :term,  :customer_id => customer_id
    end
  end

... but I think that should be unrelated, right?

On Thursday, April 25, 2013 1:38:55 PM UTC+1, Yehuda Zargarov wrote:

There is no problem creating as much facets as you want.

Try removing the second facet called 'inactive_2w' (on which you get the
error) and see if you still get the same error..

BTW why do you have an 'and' filter in the query section when you only
have 1 condition?

On Thursday, April 25, 2013 3:15:34 PM UTC+3, Adam Lebsack wrote:

I'm trying to query with multiple facets in a query. I've posted the
query and subsequent error here:
Multiple facets error · GitHub

The query works if I remove one of the facets. Is the format correct?
Is it possible to use more than one facet? I'm using tire to form the
query, and it seems to be creating the query correctly per the
documentation. Is this a bug, or am I in fact doing something wrong?

ES version: 0.20.6
OS: OS X Lion 10.8.3

Regards,
Adam

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Yehuda_Zargarov · April 25, 2013, 1:07pm

It is obviously not the reason for the error.. just didn't make sense to me.

Did you try removing the first facet and leaving only the "inactive_2w"?

On Thursday, April 25, 2013 3:50:52 PM UTC+3, Adam Lebsack wrote:

Like I mentioned, the query works properly if I remove one of the facets,
so I've tried removing the 'inactive_2w' already.

As for the query, the "and" is put there by tire when I do:
  query do
    filtered do
      query { all }
      filter :term,  :customer_id => customer_id
    end
  end
... but I think that should be unrelated, right?

On Thursday, April 25, 2013 1:38:55 PM UTC+1, Yehuda Zargarov wrote:

There is no problem creating as much facets as you want.

Try removing the second facet called 'inactive_2w' (on which you get the
error) and see if you still get the same error..

BTW why do you have an 'and' filter in the query section when you only
have 1 condition?

On Thursday, April 25, 2013 3:15:34 PM UTC+3, Adam Lebsack wrote:

I'm trying to query with multiple facets in a query. I've posted the
query and subsequent error here:
Multiple facets error · GitHub

The query works if I remove one of the facets. Is the format correct?
Is it possible to use more than one facet? I'm using tire to form the
query, and it seems to be creating the query correctly per the
documentation. Is this a bug, or am I in fact doing something wrong?

ES version: 0.20.6
OS: OS X Lion 10.8.3

Regards,
Adam

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Adam_Lebsack · April 25, 2013, 1:19pm

Yes, I've tried both... each facet works on its own. The interesting part
of the error is at the bottom:

Parse Failure [No parser for element [inactive_2w]]

Why would an (almost) identical sibling of inactive_1w not have a parser
defined?

On Thursday, April 25, 2013 2:07:44 PM UTC+1, Yehuda Zargarov wrote:

It is obviously not the reason for the error.. just didn't make sense to
me.

Did you try removing the first facet and leaving only the "inactive_2w"?

On Thursday, April 25, 2013 3:50:52 PM UTC+3, Adam Lebsack wrote:
Like I mentioned, the query works properly if I remove one of the facets,
so I've tried removing the 'inactive_2w' already.

As for the query, the "and" is put there by tire when I do:
  query do
    filtered do
      query { all }
      filter :term,  :customer_id => customer_id
    end
  end
... but I think that should be unrelated, right?

On Thursday, April 25, 2013 1:38:55 PM UTC+1, Yehuda Zargarov wrote:

There is no problem creating as much facets as you want.

Try removing the second facet called 'inactive_2w' (on which you get
the error) and see if you still get the same error..

BTW why do you have an 'and' filter in the query section when you only
have 1 condition?

On Thursday, April 25, 2013 3:15:34 PM UTC+3, Adam Lebsack wrote:

I'm trying to query with multiple facets in a query. I've posted the
query and subsequent error here:
Multiple facets error · GitHub

The query works if I remove one of the facets. Is the format correct?
Is it possible to use more than one facet? I'm using tire to form the
query, and it seems to be creating the query correctly per the
documentation. Is this a bug, or am I in fact doing something wrong?

ES version: 0.20.6
OS: OS X Lion 10.8.3

Regards,
Adam

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Yehuda_Zargarov · April 25, 2013, 1:22pm

can you please pass your full *tire *code?

On Thursday, April 25, 2013 4:19:25 PM UTC+3, Adam Lebsack wrote:

Yes, I've tried both... each facet works on its own. The interesting
part of the error is at the bottom:

Parse Failure [No parser for element [inactive_2w]]

Why would an (almost) identical sibling of inactive_1w not have a parser
defined?

On Thursday, April 25, 2013 2:07:44 PM UTC+1, Yehuda Zargarov wrote:
It is obviously not the reason for the error.. just didn't make sense to
me.

Did you try removing the first facet and leaving only the "inactive_2w"?

On Thursday, April 25, 2013 3:50:52 PM UTC+3, Adam Lebsack wrote:
Like I mentioned, the query works properly if I remove one of the
facets, so I've tried removing the 'inactive_2w' already.

As for the query, the "and" is put there by tire when I do:
  query do
    filtered do
      query { all }
      filter :term,  :customer_id => customer_id
    end
  end
... but I think that should be unrelated, right?

On Thursday, April 25, 2013 1:38:55 PM UTC+1, Yehuda Zargarov wrote:

There is no problem creating as much facets as you want.

Try removing the second facet called 'inactive_2w' (on which you get
the error) and see if you still get the same error..

BTW why do you have an 'and' filter in the query section when you only
have 1 condition?

On Thursday, April 25, 2013 3:15:34 PM UTC+3, Adam Lebsack wrote:

I'm trying to query with multiple facets in a query. I've posted the
query and subsequent error here:
Multiple facets error · GitHub

The query works if I remove one of the facets. Is the format correct?
Is it possible to use more than one facet? I'm using tire to form the
query, and it seems to be creating the query correctly per the
documentation. Is this a bug, or am I in fact doing something wrong?

ES version: 0.20.6
OS: OS X Lion 10.8.3

Regards,
Adam

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Adam_Lebsack · April 25, 2013, 1:24pm

gist.github.com

https://gist.github.com/alebsack/fc8f0b377c1ca1e780fd#file-tire-query

Error

[2013-04-25 13:08:59,346][DEBUG][action.search.type       ] [Human Robot] [directory_users][3], node[q90bIsQ_RwaB7kn4qpwziQ], [P], s[STARTED]: Failed to execute [org.elasticsearch.action.search.SearchRequest@29c114f2]
org.elasticsearch.search.SearchParseException: [directory_users][3]: query[ConstantScore(NotDeleted(+cache(customer_id:bd9058f4-bf18-416c-8e0d-07e1a1c9819a)))],from[-1],size[-1]: Parse Failure [Failed to parse source [{
    "query": {
        "filtered": {
            "filter": {
                "and": [
                    {
                        "term": {
                            "customer_id": "bd9058f4-bf18-416c-8e0d-07e1a1c9819a"
                        }

This file has been truncated. show original

query

curl -X GET 'http://127.0.0.1:9200/directory_users/directory_user/_search?size=1000&pretty' -d '{
    "query": {
        "filtered": {
            "filter": {
                "and": [
                    {
                        "term": {
                            "customer_id": "bd9058f4-bf18-416c-8e0d-07e1a1c9819a"
                        }
                    }

This file has been truncated. show original

tire query

    customer_id = customer.id
    result = DirectoryUser.search(:per_page => MAX_RESULTS) do
      query do
        filtered do
          query { all }
          filter :term,  :customer_id => customer_id
        end
      end
      facet 'inactive_1w' do
        range :last_seen_at, :ranges => [{:to => 1.week.ago}]

This file has been truncated. show original

On Thursday, April 25, 2013 2:22:17 PM UTC+1, Yehuda Zargarov wrote:

can you please pass your full *tire *code?

On Thursday, April 25, 2013 4:19:25 PM UTC+3, Adam Lebsack wrote:
Yes, I've tried both... each facet works on its own. The interesting
part of the error is at the bottom:

Parse Failure [No parser for element [inactive_2w]]

Why would an (almost) identical sibling of inactive_1w not have a parser
defined?

On Thursday, April 25, 2013 2:07:44 PM UTC+1, Yehuda Zargarov wrote:
It is obviously not the reason for the error.. just didn't make sense to
me.

Did you try removing the first facet and leaving only the "inactive_2w"?

On Thursday, April 25, 2013 3:50:52 PM UTC+3, Adam Lebsack wrote:
Like I mentioned, the query works properly if I remove one of the
facets, so I've tried removing the 'inactive_2w' already.

As for the query, the "and" is put there by tire when I do:
  query do
    filtered do
      query { all }
      filter :term,  :customer_id => customer_id
    end
  end
... but I think that should be unrelated, right?

On Thursday, April 25, 2013 1:38:55 PM UTC+1, Yehuda Zargarov wrote:

There is no problem creating as much facets as you want.

Try removing the second facet called 'inactive_2w' (on which you get
the error) and see if you still get the same error..

BTW why do you have an 'and' filter in the query section when you only
have 1 condition?

On Thursday, April 25, 2013 3:15:34 PM UTC+3, Adam Lebsack wrote:

I'm trying to query with multiple facets in a query. I've posted the
query and subsequent error here:
Multiple facets error · GitHub

The query works if I remove one of the facets. Is the format
correct? Is it possible to use more than one facet? I'm using tire to
form the query, and it seems to be creating the query correctly per the
documentation. Is this a bug, or am I in fact doing something wrong?

ES version: 0.20.6
OS: OS X Lion 10.8.3

Regards,
Adam

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Yehuda_Zargarov · April 25, 2013, 1:36pm

I found an (exactly) similar problem on stack overflow.. there is even a
reply from karmi (the author of tire) in which he says he has no idea..
The funny thing is that he also has 2 facets, both with range, and it also
works when he removes 1 of the facets..

On Thursday, April 25, 2013 4:24:44 PM UTC+3, Adam Lebsack wrote:

Multiple facets error · GitHub

On Thursday, April 25, 2013 2:22:17 PM UTC+1, Yehuda Zargarov wrote:
can you please pass your full *tire *code?

On Thursday, April 25, 2013 4:19:25 PM UTC+3, Adam Lebsack wrote:
Yes, I've tried both... each facet works on its own. The interesting
part of the error is at the bottom:

Parse Failure [No parser for element [inactive_2w]]

Why would an (almost) identical sibling of inactive_1w not have a parser
defined?

On Thursday, April 25, 2013 2:07:44 PM UTC+1, Yehuda Zargarov wrote:
It is obviously not the reason for the error.. just didn't make sense
to me.

Did you try removing the first facet and leaving only the
"inactive_2w"?

On Thursday, April 25, 2013 3:50:52 PM UTC+3, Adam Lebsack wrote:
Like I mentioned, the query works properly if I remove one of the
facets, so I've tried removing the 'inactive_2w' already.

As for the query, the "and" is put there by tire when I do:
  query do
    filtered do
      query { all }
      filter :term,  :customer_id => customer_id
    end
  end
... but I think that should be unrelated, right?

On Thursday, April 25, 2013 1:38:55 PM UTC+1, Yehuda Zargarov wrote:

There is no problem creating as much facets as you want.

Try removing the second facet called 'inactive_2w' (on which you get
the error) and see if you still get the same error..

BTW why do you have an 'and' filter in the query section when you
only have 1 condition?

On Thursday, April 25, 2013 3:15:34 PM UTC+3, Adam Lebsack wrote:

I'm trying to query with multiple facets in a query. I've posted
the query and subsequent error here:
Multiple facets error · GitHub

The query works if I remove one of the facets. Is the format
correct? Is it possible to use more than one facet? I'm using tire to
form the query, and it seems to be creating the query correctly per the
documentation. Is this a bug, or am I in fact doing something wrong?

ES version: 0.20.6
OS: OS X Lion 10.8.3

Regards,
Adam

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Topic		Replies	Views
Multiple Statistical Facets in one search Elasticsearch	5	370	July 6, 2017
Filter error: facetted search where multiple terms can be selected per facet Elasticsearch	5	566	July 6, 2017
Facte Query Elasticsearch	1	300	July 6, 2017
Facet_filter with multiple ranges Elasticsearch	4	382	July 6, 2017
Facet on two fields Elasticsearch	1	286	July 6, 2017

Multiple facets error

Related Topics