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.
For more options, visit https://groups.google.com/d/optout.
