Cannot find empty fields ("") processed by stempel (polish analyser) using exists/missing query

[rkoc]

Elasticsearch version: 2.3.4

Cannot find empty fields ("") processed by stempel (polish analyser) using exists/missing query. I have no problems with other 'standard' or 'not_anlyzed' types.

[clintongormley]

Please provide a short but complete curl reproduction of the issue, including creating the index, specifying the mappings, indexing the docs, searching, and explain what you expected to see and what you actually see. It will greatly help us to understand what the problem is.

[jsgandalf]

I'm on Elastic 5.2
I'm also having the same issues... I'm trying to find empty values, and have set my index mapping to keyword (which technically does not analyze so it should pick up on the "" values)

"query": {
      "term": { "MY_FIELD_TO_SEARCH": "" }
}

[colings86]

@jsgandalf could you provide the information @clintongormley asked for above as it will greatly help in recreating (and therefore understanding and solving) this issue you are seeing

[jsgandalf]

Actually, when I reindex my database and rerun the query. It worked =)

The problem was that my field was type: text and NOT a keyword. Changed the index to keyword and reindexed:

curl -X PUT https://username:password@host.io:9200/mycoolindex

curl -X PUT https://user:pass@host.io:9200/mycoolindex/_mapping/mycooltype -d '{
  "properties": {
			    "MY_FIELD_TO_SEARCH": {
						"type": "keyword"
					},
}'

curl -X PUT https://username:password@host.io:9200/_reindex -d '{
  "source": {
    "index": "oldindex"
  },
  "dest": {
    "index": "mycoolindex"
  }
}'

I hope this helps someone who was as stuck as I was getting rid of those empty values.

[javanna]

thanks for getting back to us. Closing.