Special Character can't search in ElasticSearch

[mhsankar]

Hi what character we can't search in ElasticSearch? for example q=query('name:.') we can't search . character in ElasticSearch please give me list of character like this.

[shi-yuan]

Why not?

curl -XPUT -H 'Content-Type:application/json; charset=UTF-8' 'http://127.0.0.1:9200/test/test/1' -d '{
    "name" : "."
}'

curl -XPOST -H 'Content-Type:application/json; charset=UTF-8' 'http://127.0.0.1:9200/_sql?pretty' -d '{
    "sql":"SELECT * FROM test where q=query(\"name.keyword:.\")"
}'

[mhsankar]

I test your code it is right. but it is not solve my problem when you create dynamic Index under every text field create one sub field with Keyword type. then you search in sub field with keyword type. how ever if you insert ". ab" in your index your can't search . character alone. it can't find. i want to search in Text type field. how do you search?

[shi-yuan]

except for the stop word .

SELECT * FROM test where q=query("name:.")