The main limitation of the span queries is that they only operate on analyzed terms. The terms used in span_term must match the terms in the index. In your case, there is no single term "happy holiday" in your index, because the original document was tokenized into "happy" "birthday" "to" "you".
You would need to do a span near query of the two terms with a slop of 1 and in order. This span near query will then be the argument to the span first. Here is a good explanation of span queries in Lucene: http://searchhub.org/2009/07/18/the-spanquery/ -- Ivan On Sun, Apr 27, 2014 at 11:24 PM, cyrilforce <[email protected]> wrote: > Hi Ivan, > > I recreate the mapping and re-index the documents and now working fine. > Thanks. > > Btw would like to ask how i could search two or more words in the > span_first query as i need it to support the following searches : > 1)happy > 2)happy holiday > 3)happy birthday to you > > { > "from" : 100, > "size" : 100, > "query" : { > "span_first" : { > "match" : { > * "span_term" : { "DISPLAY_NAME" : "happy holiday" }* > }, > "end" : 1 > } > } > } > > > returns empty list even we have documents that display_name start with *happy > holiday*. > > Thanks. > > > On Sunday, April 27, 2014 2:55:37 AM UTC+8, cyrilforce wrote: >> >> Hi Ivan, >> >> I am using version elasticsearch-0.90.1. Nope we don't have any >> templates. Not sure whether your are referring to the full index mapping >> here's the gist >> >> media mapping >> https://gist.github.com/cheehoo/11327970 >> >> full index mapping >> https://gist.github.com/cheehoo/11327996 >> >> Thanks in advance. >> >> >> >> >> >> On Sat, Apr 26, 2014 at 8:31 AM, Ivan Brusic <[email protected]> wrote: >> >>> Your mapping looks correct. Which version are you running? Do you have >>> any templates? >>> >>> Just to be on the safe side, can you provide the mapping that >>> Elasticsearch is using (not the one you provide): >>> >>> http://localhost:9200/jdbc_dev/media/_mapping >>> >>> -- >>> Ivan >>> >>> >>> >>> >>> On Fri, Apr 25, 2014 at 3:24 AM, cyrilforce <[email protected]> wrote: >>> >>>> Hi, >>>> >>>> I am trying to query some records via the span_first query as below : >>>> >>>> { >>>> "from" : 100, >>>> "size" : 100, >>>> "query" : { >>>> "span_first" : { >>>> "match" : { >>>> * "span_term" : { "DISPLAY_NAME" : "happy" }* >>>> }, >>>> "end" : 1 >>>> } >>>> } >>>> } >>>> >>>> >>>> >>>> however it returned me with an error : >>>> >>>> "index": "jdbc_dev", >>>> "shard": 4, >>>> "status": 500, >>>> * "reason": >>>> "RemoteTransportException[[portal-web-02][inet[/192.168.96.27:9300]][search/phase/query/id]]; >>>> nested: QueryPhaseExecutionException[[jdbc_dev][4]: >>>> query[filtered(spanFirst(DISPLAY_NAME:happy, >>>> 1))->cache(_type:media)],from[100],size[100]: Query Failed [Failed to >>>> execute main query]]; nested: IllegalStateException[field \"DISPLAY_NAME\" >>>> was indexed without position data; cannot run SpanTermQuery (term=happy)]; >>>> "* >>>> } >>>> >>>> >>>> >>>> The mapping for that type : >>>> >>>> { >>>> "media": { >>>> "properties": { >>>> "AUDIO": { >>>> "type": "string" >>>> }, >>>> "BILLINGTYPE_ID": { >>>> "type": "long" >>>> }, >>>> "CATMEDIA_CDATE": { >>>> "type": "date", >>>> "format": "dateOptionalTime" >>>> }, >>>> "CATMEDIA_NAME": { >>>> "type": "string" >>>> }, >>>> "CATMEDIA_RANK": { >>>> "type": "long" >>>> }, >>>> "CAT_ID": { >>>> "type": "long" >>>> }, >>>> "CAT_NAME": { >>>> "type": "string", >>>> "analyzer": "string_lowercase", >>>> "include_in_all": true >>>> }, >>>> "CAT_PARENT": { >>>> "type": "long" >>>> }, >>>> "CHANNEL_ID": { >>>> "type": "long" >>>> }, >>>> "CKEY": { >>>> "type": "long" >>>> }, >>>> * "DISPLAY_NAME": {* >>>> * "type": "string",* >>>> * "analyzer": "standard"* >>>> * },* >>>> "FTID": { >>>> "type": "string" >>>> }, >>>> "GENRE": { >>>> "type": "string" >>>> }, >>>> "ITEMCODE": { >>>> "type": "string" >>>> }, >>>> "KEYWORDS": { >>>> "type": "string" >>>> }, >>>> "LANG_ID": { >>>> "type": "long" >>>> }, >>>> "LONG_DESCRIPTION": { >>>> "type": "string" >>>> }, >>>> "MAPPINGS": { >>>> "type": "string", >>>> "analyzer": "string_lowercase", >>>> "include_in_all": true >>>> }, >>>> "MEDIA_ID": { >>>> "type": "long" >>>> }, >>>> "MEDIA_PKEY": { >>>> "type": "string" >>>> }, >>>> "PERFORMER": { >>>> "type": "string" >>>> }, >>>> "PLAYER": { >>>> "type": "string" >>>> }, >>>> "POSITION": { >>>> "type": "long" >>>> }, >>>> "PRICE": { >>>> "type": "double" >>>> }, >>>> "PRIORITY": { >>>> "type": "long" >>>> }, >>>> "SHORTCODE": { >>>> "type": "string" >>>> }, >>>> "SHORT_DESCRIPTION": { >>>> "type": "string" >>>> }, >>>> "TYPE_ID": { >>>> "type": "long" >>>> }, >>>> "VIEW_ID": { >>>> "type": "long" >>>> } >>>> } >>>> } >>>> } >>>> >>>> >>>> >>>> >>>> I would like to know what is the reason and how i could fix it. Thanks. >>>> >>>> -- >>>> 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 [email protected]. >>>> >>>> To view this discussion on the web visit https://groups.google.com/d/ >>>> msgid/elasticsearch/ad8740af-2038-40d4-9fc2-79d6e1402e5a% >>>> 40googlegroups.com<https://groups.google.com/d/msgid/elasticsearch/ad8740af-2038-40d4-9fc2-79d6e1402e5a%40googlegroups.com?utm_medium=email&utm_source=footer> >>>> . >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "elasticsearch" group. >>> To unsubscribe from this topic, visit https://groups.google.com/d/ >>> topic/elasticsearch/cwzQrR1Rpsw/unsubscribe. >>> To unsubscribe from this group and all its topics, send an email to >>> [email protected]. >>> To view this discussion on the web visit https://groups.google.com/d/ >>> msgid/elasticsearch/CALY%3DcQBYhpWDHm-h-1rXFO% >>> 3DvHY0y4qkHdcHrR57nGEc0f1haAw%40mail.gmail.com<https://groups.google.com/d/msgid/elasticsearch/CALY%3DcQBYhpWDHm-h-1rXFO%3DvHY0y4qkHdcHrR57nGEc0f1haAw%40mail.gmail.com?utm_medium=email&utm_source=footer> >>> . >>> >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> >> -- >> Regards, >> >> Chee Hoo >> > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/elasticsearch/c6d86b5e-52c9-479d-b2fa-78ef9f8bde0d%40googlegroups.com<https://groups.google.com/d/msgid/elasticsearch/c6d86b5e-52c9-479d-b2fa-78ef9f8bde0d%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CALY%3DcQBefd__MOrWNUzHvTdkk8ZtMD1BxHAB26Cxz3k3OSYSAQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
