Do you have any documents that starts with "happy people"? -- Ivan
On Tue, Apr 29, 2014 at 7:21 PM, chee hoo lum <[email protected]> wrote: > Hi Ivan, > > Tried with 2 and 3 with no luck. > > { > "from" : 100, > "size" : 100, > "query" : { > "span_first" : { > "match" : { > "span_near" : { > "clauses" : [ > { "span_term" : { "DISPLAY_NAME" : "happy" } }, > { "span_term" : { "DISPLAY_NAME" : "people" } } > > ], > "slop" : 1, > "in_order" : true > } > }, > *"end" : 2* > } > } > } > > > The field is using "standard" analyzer with stopword=_none: > > "DISPLAY_NAME": { > "type": "string", > "analyzer": "standard" > }, > > "index.analysis.analyzer.standard.type": "standard", > "index.analysis.analyzer.standard.stopwords": "_none_" > > > Any clue on this ? :) Thanks > > > > > On Wed, Apr 30, 2014 at 12:37 AM, Ivan Brusic <[email protected]> wrote: > >> The end parameter is too low. It needs to be at a minimum the number of >> clauses in the span_near query. >> >> -- >> Ivan >> >> >> On Mon, Apr 28, 2014 at 7:05 PM, chee hoo lum <[email protected]>wrote: >> >>> Hi Ivan, >>> >>> Not able to get any result with the following query : >>> >>> { >>> "from" : 100, >>> "size" : 100, >>> "query" : { >>> "span_first" : { >>> "match" : { >>> "span_near" : { >>> "clauses" : [ >>> { "span_term" : { "DISPLAY_NAME" : "happy" } }, >>> { "span_term" : { "DISPLAY_NAME" : "people" } } >>> >>> ], >>> "slop" : 1, >>> "in_order" : true >>> } >>> }, >>> "end" : 1 >>> } >>> } >>> } >>> >>> >>> Meanwhile tried with : >>> >>> { >>> "from" : 100, >>> "size" : 100, >>> "query" : { >>> "span_first" : { >>> "match" : { >>> "span_term" : { "DISPLAY_NAME" : "happy" } >>> }, >>> "end" : 1 >>> } >>> } >>> } >>> >>> and it returns : >>> >>> "_index": "jdbc_dev", >>> "_type": "media", >>> "_id": "9556", >>> "_score": 4.612431, >>> "_source": { >>> "DISPLAY_NAME": "Happy People", >>> >>> >>> Anything wrong with my first query ? >>> >>> Thanks >>> >>> >>> >>> On Tue, Apr 29, 2014 at 12:16 AM, Ivan Brusic <[email protected]> wrote: >>> >>>> 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 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%3DcQBefd__MOrWNUzHvTdkk8ZtMD1BxHAB26Cxz3k3OSYSAQ%40mail.gmail.com<https://groups.google.com/d/msgid/elasticsearch/CALY%3DcQBefd__MOrWNUzHvTdkk8ZtMD1BxHAB26Cxz3k3OSYSAQ%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/CAGS0%2Bg9iuY_eHFO_VUywCQYB18FOWprT%3D9ZBDm4id8A0brq0Pw%40mail.gmail.com<https://groups.google.com/d/msgid/elasticsearch/CAGS0%2Bg9iuY_eHFO_VUywCQYB18FOWprT%3D9ZBDm4id8A0brq0Pw%40mail.gmail.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%3DcQBrN1ft3kG_L_LZ39KF-L1Y7hBsPFy%3D2ar64%3DqKe3ogLw%40mail.gmail.com<https://groups.google.com/d/msgid/elasticsearch/CALY%3DcQBrN1ft3kG_L_LZ39KF-L1Y7hBsPFy%3D2ar64%3DqKe3ogLw%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/CAGS0%2Bg8vUBhgDgnyhC_DT4PtwmGn4%3D6%2BCHpg9UrgnZNhgTEKig%40mail.gmail.com<https://groups.google.com/d/msgid/elasticsearch/CAGS0%2Bg8vUBhgDgnyhC_DT4PtwmGn4%3D6%2BCHpg9UrgnZNhgTEKig%40mail.gmail.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%3DcQDubi%2Bf9W50UtMc4GJ2XpuoGSB7se0b7o31Zs6GKfLFZg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
