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/CAGS0%2Bg_9Nq6sL%2BYfhXSY60DpV8_JqV55ypWgGczzQcUGEsKE8Q%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
