# Question about facets and get full terms **URL:** \ **Category:** Elasticsearch\ **Created:** [September 17, 2013, 9:14pm UTC](https://discuss.elastic.co/t/question-about-facets-and-get-full-terms/13658 "2013-09-17T21:14:10Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Pashkevich\_Aleksandr](https://avatars.discourse-cdn.com/v4/letter/p/a4c791/32.png) [@Pashkevich\_Aleksandr](https://discuss.elastic.co/u/Pashkevich_Aleksandr)\ **Post date:** [September 17, 2013, 9:14pm UTC](https://discuss.elastic.co/t/question-about-facets-and-get-full-terms/13658/1 "2013-09-17T21:14:10Z")
Hello, sory for my English i am use that query for get all fields of one tag { "query" : { "match\_all" : { } }, "facets" : { "Params\_1" : { "terms" : { "field" : "Params\_1", } } } } and elasticsearch return to me result "facets" : {"tag" : {"\_type" : "terms","missing" : 0,"total" : 3151716,"other" : 0,"terms" : [ {"term" : "mores","count" : 525286}, {"term" : "more","count" : 525286}, {"term" : "text","count" : 525286}, {"term" : "texts","count" : 1050572} ]}} All great, but one small trouble. Me need to return a full term, for example "more text", and don't return "more" and "text" as two different terms. How i can change query? -- 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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [September 17, 2013, 10:02pm UTC](https://discuss.elastic.co/t/question-about-facets-and-get-full-terms/13658/2 "2013-09-17T22:02:16Z")
You don't have to change the query but the mapping. Have a look at Put Mapping API: [Elastic — The Search AI Company | Elastic](http://www.elasticsearch.org/guide/reference/api/admin-indices-put-mapping/). Set your field Params\_1 as not\_analyzed ([Elastic — The Search AI Company | Elastic](http://www.elasticsearch.org/guide/reference/mapping/core-types/)) and then run again the same query. ## Hope this helps David Pilato | Technical Advocate | [Elasticsearch.com](http://Elasticsearch.com) @dadoonet | @elasticsearchfr | @scrutmydocs Le 17 sept. 2013 à 23:14, Pashkevich Aleksandr [serious2008@gmail.com](mailto:serious2008@gmail.com) a écrit : > Hello, sory for my English > > i am use that query for get all fields of one tag > > { > "query" : { > "match\_all" : { } > }, > "facets" : { > "Params\_1" : { > "terms" : { > "field" : "Params\_1", > } > } > } > } > and elasticsearch return to me result > > "facets" : {"tag" : {"\_type" : "terms","missing" : 0,"total" : 3151716,"other" : 0,"terms" : [ > {"term" : "mores","count" : 525286}, {"term" : "more","count" : 525286}, {"term" : "text","count" : 525286}, {"term" : "texts","count" : 1050572} ]}} > > All great, but one small trouble. Me need to return a full term, for example "more text", and don't return "more" and "text" as two different terms. > How i can change query? > > -- > 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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- 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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Pashkevich\_Aleksandr](https://avatars.discourse-cdn.com/v4/letter/p/a4c791/32.png) [@Pashkevich\_Aleksandr](https://discuss.elastic.co/u/Pashkevich_Aleksandr)\ **Post date:** [September 17, 2013, 10:25pm UTC](https://discuss.elastic.co/t/question-about-facets-and-get-full-terms/13658/3 "2013-09-17T22:25:38Z")
i try that query > $comand =' curl -XPUT "[http://localhost:9200/test/type1/\_mapping](http://localhost:9200/test/type1/_mapping)" -d ' > { > > ``` > "properties" : { > "Params_1" : { > "type" : "string", > "store" : "yes", > "index" : "not_analyzed", > "null_value" : "na" > } > } > > ``` > > } and elastic return > {"ok":true,"acknowledged":true} then i run my query and elastic return the same result "facets" : {"tag" : {"\_type" : "terms","missing" : 0,"total" : 3151716,"other" : 0,"terms" : [ {"term" : "mores","count" : 525286}, {"term" : "more","count" : 525286}, {"term" : "text","count" : 525286}, {"term" : "texts","count" : 1050572} ]}} среда, 18 сентября 2013 г., 1:02:16 UTC+3 пользователь David Pilato написал: > You don't have to change the query but the mapping. > Have a look at Put Mapping API: > [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/reference/api/admin-indices-put-mapping/). > Set your field Params\_1 as not\_analyzed ( > [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/reference/mapping/core-types/)) and > then run again the same query. > > ## Hope this helps > > _David Pilato_ | _Technical Advocate_ | _[Elasticsearch.com](http://Elasticsearch.com)_ > @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr[https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr) > | @scrutmydocs [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs) > > Le 17 sept. 2013 à 23:14, Pashkevich Aleksandr \<[serio...@gmail.com](mailto:serio...@gmail.com)\\> > a écrit : > > Hello, sory for my English > > i am use that query for get all fields of one tag > > { > "query" : { > "match\_all" : { } > }, > "facets" : { > "Params\_1" : { > "terms" : { > "field" : "Params\_1", > } > } > } > } > > and elasticsearch return to me result > > "facets" : {"tag" : {"\_type" : "terms","missing" : 0,"total" : 3151716,"other" : 0,"terms" : [ > {"term" : "mores","count" : 525286}, {"term" : "more","count" : 525286}, {"term" : "text","count" : 525286}, {"term" : "texts","count" : 1050572} ]}} > > All great, but one small trouble. Me need to return a full term, for > example "more text", and don't return "more" and "text" as two different > terms. > How i can change query? > > -- > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com) \. > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- 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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [September 17, 2013, 10:33pm UTC](https://discuss.elastic.co/t/question-about-facets-and-get-full-terms/13658/4 "2013-09-17T22:33:19Z")
Start a new index (delete the old one). Index again your documents. Check logs. If it does not work, please provide a full curl recreation. It will hep to understand what you are exactly doing. See [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/help/) -- David Pilato | Technical Advocate | [Elasticsearch.com](http://Elasticsearch.com) @dadoonet | @elasticsearchfr | @scrutmydocs Le 18 sept. 2013 à 00:25, Pashkevich Aleksandr [serious2008@gmail.com](mailto:serious2008@gmail.com) a écrit : > i try that query > $comand =' curl -XPUT "[http://localhost:9200/test/type1/\_mapping](http://localhost:9200/test/type1/_mapping)" -d ' > { > > ``` > "properties" : { > "Params_1" : { > "type" : "string", > "store" : "yes", > "index" : "not_analyzed", > "null_value" : "na" > } > } > > ``` > > } > and elastic return > {"ok":true,"acknowledged":true} > > then i run my query and elastic return the same result > > > "facets" : {"tag" : {"\_type" : "terms","missing" : 0,"total" : 3151716,"other" : 0,"terms" : [ > > {"term" : "mores","count" : 525286}, {"term" : "more","count" : 525286}, {"term" : "text","count" : 525286}, {"term" : "texts","count" : 1050572} ]}} > > среда, 18 сентября 2013 г., 1:02:16 UTC+3 пользователь David Pilato написал: > You don't have to change the query but the mapping. > Have a look at Put Mapping API: [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/reference/api/admin-indices-put-mapping/). Set your field Params\_1 as not\_analyzed ([Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/reference/mapping/core-types/)) and then run again the same query. > > ## Hope this helps > > David Pilato | Technical Advocate | [Elasticsearch.com](http://Elasticsearch.com) > @dadoonet | @elasticsearchfr | @scrutmydocs > > Le 17 sept. 2013 à 23:14, Pashkevich Aleksandr [serio...@gmail.com](mailto:serio...@gmail.com) a écrit : > > > Hello, sory for my English > > > > i am use that query for get all fields of one tag > > > > { > > "query" : { > > "match\_all" : { } > > }, > > "facets" : { > > "Params\_1" : { > > "terms" : { > > "field" : "Params\_1", > > } > > } > > } > > } > > and elasticsearch return to me result > > > > "facets" : {"tag" : {"\_type" : "terms","missing" : 0,"total" : 3151716,"other" : 0,"terms" : [ > > {"term" : "mores","count" : 525286}, {"term" : "more","count" : 525286}, {"term" : "text","count" : 525286}, {"term" : "texts","count" : 1050572} ]}} > > > > All great, but one small trouble. Me need to return a full term, for example "more text", and don't return "more" and "text" as two different terms. > > How i can change query? > > > > -- > > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com). > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). > > -- > 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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- 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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Pashkevich\_Aleksandr](https://avatars.discourse-cdn.com/v4/letter/p/a4c791/32.png) [@Pashkevich\_Aleksandr](https://discuss.elastic.co/u/Pashkevich_Aleksandr)\ **Post date:** [September 17, 2013, 10:55pm UTC](https://discuss.elastic.co/t/question-about-facets-and-get-full-terms/13658/5 "2013-09-17T22:55:46Z")
> Start a new index (delete the old one). > Index again your documents. After that curl > curl -XPUT "[http://localhost:9200/test/type1/\_mapping](http://localhost:9200/test/type1/_mapping)" -d ' > > { > > ``` > "properties" : { > > "Params_1" : {"type" : "string", "index" : "not_analyzed"}, > > "Articul" : {"type" : "integer"} > > } > > ``` > > } > > ' > > I insert new value that query i use > curl -XPOST localhost:9200/test/type3/368800 -d > > > '{"Articul":"1","Names":"Sample 1","Price":"1232","Cat":"1","Params\_1":"text"}' > > curl -XPOST localhost:9200/test/type3/368801 -d > > > '{"Articul":"7","Names":"Sample > > 2","Price":"1234","Cat":"1","Params\_1":"more mored text"}' > > curl -XPOST localhost:9200/test/type3/368802 -d > > > '{"Articul":"10","Names":"Sample 3","Price":"124323","Cat":"2","Params\_1":"more > > text"}' > > when i add new record, i use that curl query > curl -X POST "[http://localhost:9200/test/type1/\_search?pretty=true](http://localhost:9200/test/type1/_search?pretty=true)" -d ' > { > "query" : { > "match\_all" : { } > }, > "sort" : [ > {"Articul" : {"order" : "asc", "mode" : "avg"}} > ], > "facets" : { > "tag" : { > "terms" : { > "field" : "Params\_1" > } > } > } > } > ' and esatic return ordered records 1,10,7 rather than 1, 7, 10 and return facets terms > "facets" : { "tag" : { "\_type" : "terms", "missing" : 0, "total" : > 3151716, "other" : 0, "terms" : [ { "term" : "texts", "count" : 1050572}, {"term" : "text","count" : 525286}, {"term" : "more","count" : 525286}, {"term" : "mores","count" : 525286} > ] } } среда, 18 сентября 2013 г., 1:33:19 UTC+3 пользователь David Pilato написал: > Start a new index (delete the old one). > Index again your documents. > Check logs. > > If it does not work, please provide a full curl recreation. It will hep to > understand what you are exactly doing. > > See [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/help/) > > -- > _David Pilato_ | _Technical Advocate_ | _[Elasticsearch.com](http://Elasticsearch.com)_ > @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr[https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr) > | @scrutmydocs [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs) > > Le 18 sept. 2013 à 00:25, Pashkevich Aleksandr \<[serio...@gmail.com](mailto:serio...@gmail.com)\\> > a écrit : > > i try that query > > > $comand =' curl -XPUT "[http://localhost:9200/test/type1/\_mapping](http://localhost:9200/test/type1/_mapping)" -d ' > > { > > > > ``` > > "properties" : { > > "Params_1" : { > > "type" : "string", > > "store" : "yes", > > "index" : "not_analyzed", > > "null_value" : "na" > > } > > } > > > > ``` > > > > } > > and elastic return > > > {"ok":true,"acknowledged":true} > > then i run my query and elastic return the same result > > "facets" : {"tag" : {"\_type" : "terms","missing" : 0,"total" : 3151716,"other" : 0,"terms" : [ > {"term" : "mores","count" : 525286}, {"term" : "more","count" : 525286}, {"term" : "text","count" : 525286}, {"term" : "texts","count" : 1050572} ]}} > > среда, 18 сентября 2013 г., 1:02:16 UTC+3 пользователь David Pilato > написал: > > > You don't have to change the query but the mapping. > > Have a look at Put Mapping API: > > [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/reference/api/admin-indices-put-mapping/). > > Set your field Params\_1 as not\_analyzed ( > > [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/reference/mapping/core-types/)) and > > then run again the same query. > > > > ## Hope this helps > > > > _David Pilato_ | _Technical Advocate_ | \*[Elasticsearch.com](http://Elasticsearch.com)[http://elasticsearch.com/](http://elasticsearch.com/) > > \* > > @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr[https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr) > > | @scrutmydocs [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs) > > > > Le 17 sept. 2013 à 23:14, Pashkevich Aleksandr [serio...@gmail.com](mailto:serio...@gmail.com) a > > écrit : > > > > Hello, sory for my English > > > > i am use that query for get all fields of one tag > > > > { > > "query" : { > > "match\_all" : { } > > }, > > "facets" : { > > "Params\_1" : { > > "terms" : { > > "field" : "Params\_1", > > } > > } > > } > > } > > > > and elasticsearch return to me result > > > > "facets" : {"tag" : {"\_type" : "terms","missing" : 0,"total" : 3151716,"other" : 0,"terms" : [ > > {"term" : "mores","count" : 525286}, {"term" : "more","count" : 525286}, {"term" : "text","count" : 525286}, {"term" : "texts","count" : 1050572} ]}} > > > > All great, but one small trouble. Me need to return a full term, for > > example "more text", and don't return "more" and "text" as two different > > terms. > > How i can change query? > > > > -- > > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com). > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). > > -- > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com) \. > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- 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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [September 17, 2013, 11:02pm UTC](https://discuss.elastic.co/t/question-about-facets-and-get-full-terms/13658/6 "2013-09-17T23:02:31Z")
Your first curl command is incorrect. Type name is missing. Look at the example with type tweet: $ curl -XPUT '[http://localhost:9200/twitter/tweet/\_mapping](http://localhost:9200/twitter/tweet/_mapping)' -d ' { "tweet" : { "properties" : { "message" : {"type" : "string", "store" : "yes"} } } } ' -- David Pilato | Technical Advocate | [Elasticsearch.com](http://Elasticsearch.com) @dadoonet | @elasticsearchfr | @scrutmydocs Le 18 sept. 2013 à 00:55, Pashkevich Aleksandr [serious2008@gmail.com](mailto:serious2008@gmail.com) a écrit : > Start a new index (delete the old one). > Index again your documents. > After that curl > curl -XPUT "[http://localhost:9200/test/type1/\_mapping](http://localhost:9200/test/type1/_mapping)" -d ' > { > > ``` > "properties" : { > "Params_1" : {"type" : "string", "index" : "not_analyzed"}, > "Articul" : {"type" : "integer"} > } > > ``` > > } > ' > I insert new value that query i use > curl -XPOST localhost:9200/test/type3/368800 -d '{"Articul":"1","Names":"Sample 1","Price":"1232","Cat":"1","Params\_1":"text"}' > curl -XPOST localhost:9200/test/type3/368801 -d '{"Articul":"7","Names":"Sample 2","Price":"1234","Cat":"1","Params\_1":"more mored text"}' > curl -XPOST localhost:9200/test/type3/368802 -d '{"Articul":"10","Names":"Sample 3","Price":"124323","Cat":"2","Params\_1":"more text"}' > when i add new record, i use that curl query > curl -X POST "[http://localhost:9200/test/type1/\_search?pretty=true](http://localhost:9200/test/type1/_search?pretty=true)" -d ' > { > "query" : { > "match\_all" : { } > }, > "sort" : [ > {"Articul" : {"order" : "asc", "mode" : "avg"}} > ], > "facets" : { > "tag" : { > "terms" : { > "field" : "Params\_1" > } > } > } > } > ' > and esatic return ordered records 1,10,7 rather than 1, 7, 10 and return facets terms > "facets" : { > "tag" : { > "\_type" : "terms", > "missing" : 0, > "total" : 3151716, > "other" : 0, > "terms" : [ { > "term" : "texts", > "count" : 1050572 > }, { > "term" : "text", > "count" : 525286 > }, { > "term" : "more", > "count" : 525286 > }, { > "term" : "mores", > "count" : 525286 > } > > ] > } > } > > среда, 18 сентября 2013 г., 1:33:19 UTC+3 пользователь David Pilato написал: > Start a new index (delete the old one). > Index again your documents. > Check logs. > > If it does not work, please provide a full curl recreation. It will hep to understand what you are exactly doing. > > See [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/help/) > > -- > David Pilato | Technical Advocate | [Elasticsearch.com](http://Elasticsearch.com) > @dadoonet | @elasticsearchfr | @scrutmydocs > > Le 18 sept. 2013 à 00:25, Pashkevich Aleksandr [serio...@gmail.com](mailto:serio...@gmail.com) a écrit : > > > i try that query > > $comand =' curl -XPUT "[http://localhost:9200/test/type1/\_mapping](http://localhost:9200/test/type1/_mapping)" -d ' > > { > > > > ``` > > "properties" : { > > "Params_1" : { > > "type" : "string", > > "store" : "yes", > > "index" : "not_analyzed", > > "null_value" : "na" > > } > > } > > > > ``` > > > > } > > and elastic return > > {"ok":true,"acknowledged":true} > > > > then i run my query and elastic return the same result > > > > > "facets" : {"tag" : {"\_type" : "terms","missing" : 0,"total" : 3151716,"other" : 0,"terms" : [ > > > {"term" : "mores","count" : 525286}, {"term" : "more","count" : 525286}, {"term" : "text","count" : 525286}, {"term" : "texts","count" : 1050572} ]}} > > > > среда, 18 сентября 2013 г., 1:02:16 UTC+3 пользователь David Pilato написал: > > You don't have to change the query but the mapping. > > Have a look at Put Mapping API: [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/reference/api/admin-indices-put-mapping/). Set your field Params\_1 as not\_analyzed ([Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/reference/mapping/core-types/)) and then run again the same query. > > > > ## Hope this helps > > > > David Pilato | Technical Advocate | [Elasticsearch.com](http://Elasticsearch.com) > > @dadoonet | @elasticsearchfr | @scrutmydocs > > > > Le 17 sept. 2013 à 23:14, Pashkevich Aleksandr [serio...@gmail.com](mailto:serio...@gmail.com) a écrit : > > > > > Hello, sory for my English > > > > > > i am use that query for get all fields of one tag > > > > > > { > > > "query" : { > > > "match\_all" : { } > > > }, > > > "facets" : { > > > "Params\_1" : { > > > "terms" : { > > > "field" : "Params\_1", > > > } > > > } > > > } > > > } > > > and elasticsearch return to me result > > > > > > "facets" : {"tag" : {"\_type" : "terms","missing" : 0,"total" : 3151716,"other" : 0,"terms" : [ > > > {"term" : "mores","count" : 525286}, {"term" : "more","count" : 525286}, {"term" : "text","count" : 525286}, {"term" : "texts","count" : 1050572} ]}} > > > > > > All great, but one small trouble. Me need to return a full term, for example "more text", and don't return "more" and "text" as two different terms. > > > How i can change query? > > > > > > -- > > > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com). > > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). > > > > -- > > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com). > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). > > -- > 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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- 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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Pashkevich\_Aleksandr](https://avatars.discourse-cdn.com/v4/letter/p/a4c791/32.png) [@Pashkevich\_Aleksandr](https://discuss.elastic.co/u/Pashkevich_Aleksandr)\ **Post date:** [September 17, 2013, 11:11pm UTC](https://discuss.elastic.co/t/question-about-facets-and-get-full-terms/13658/7 "2013-09-17T23:11:54Z")
when i use that sample from my php scripts > esatics return that error > {"error":"MergeMappingException[Merge failed with failures {[mapper > [Парметр\_1] has different index values, mapper [Парметр\_1] has different > store values, mapper [Парметр\_1] has different tokenize values, mapper > [Парметр\_1] has different index\_analyzer]}]","status":400} when i try that sample form SSH console elastics return > {"ok":true,"acknowledged":true} and i try that curl query > curl -X POST "[http://localhost:9200/test/type1/\_search?pretty=true](http://localhost:9200/test/type1/_search?pretty=true)" -d ' > > { > > ``` > "query" : { > > "match_all" : { } > > }, > > "sort" : [ > > {"Articul" : {"order" : "asc", "mode" : "avg"}} > > ], > > "facets" : { > > "tag" : { > > "terms" : { > > "field" : "Params_1" > > } > > } > > } > > ``` > > } > > ' > > and result not change среда, 18 сентября 2013 г., 2:02:31 UTC+3 пользователь David Pilato написал: > Your first curl command is incorrect. Type name is missing. > Look at the example with type _tweet_: > > $ curl -XPUT '[http://localhost:9200/twitter/tweet/\_mapping](http://localhost:9200/twitter/tweet/_mapping)' -d ' > { > "tweet" : { > "properties" : { > "message" : {"type" : "string", "store" : "yes"} > } > } > } > ' > > -- > _David Pilato_ | _Technical Advocate_ | _[Elasticsearch.com](http://Elasticsearch.com)_ > @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr[https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr) > | @scrutmydocs [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs) > > Le 18 sept. 2013 à 00:55, Pashkevich Aleksandr \<[serio...@gmail.com](mailto:serio...@gmail.com)\\> > a écrit : > > Start a new index (delete the old one). > > > Index again your documents. > > After that curl > > > curl -XPUT "[http://localhost:9200/test/type1/\_mapping](http://localhost:9200/test/type1/_mapping)" -d ' > > > > { > > > > ``` > > "properties" : { > > > > "Params_1" : {"type" : "string", "index" : "not_analyzed"}, > > > > "Articul" : {"type" : "integer"} > > > > } > > > > ``` > > > > } > > > > ' > > > > I insert new value that query i use > > > curl -XPOST localhost:9200/test/type3/368800 -d > > > > > '{"Articul":"1","Names":"Sample 1","Price":"1232","Cat":"1","Params\_1":"text"}' > > > > curl -XPOST localhost:9200/test/type3/368801 -d > > > > > '{"Articul":"7","Names":"Sample > > > 2","Price":"1234","Cat":"1","Params\_1":"more mored text"}' > > > > curl -XPOST localhost:9200/test/type3/368802 -d > > > > > '{"Articul":"10","Names":"Sample 3","Price":"124323","Cat":"2","Params\_1":"more > > > text"}' > > > > when i add new record, i use that curl query > > > curl -X POST "[http://localhost:9200/test/type1/\_search?pretty=true](http://localhost:9200/test/type1/_search?pretty=true)" -d ' > > { > > "query" : { > > "match\_all" : { } > > }, > > "sort" : [ > > {"Articul" : {"order" : "asc", "mode" : "avg"}} > > ], > > "facets" : { > > "tag" : { > > "terms" : { > > "field" : "Params\_1" > > } > > } > > } > > } > > ' > > and esatic return ordered records 1,10,7 rather than 1, 7, 10 and return > facets terms > > > "facets" : { "tag" : { "\_type" : "terms", "missing" : 0, "total" : > > 3151716, "other" : 0, "terms" : [ { "term" : "texts", "count" : 1050572}, {"term" : "text","count" : 525286}, {"term" : "more","count" : 525286}, {"term" : "mores","count" : 525286} > > ] } } > > среда, 18 сентября 2013 г., 1:33:19 UTC+3 пользователь David Pilato > написал: > > > Start a new index (delete the old one). > > Index again your documents. > > Check logs. > > > > If it does not work, please provide a full curl recreation. It will hep > > to understand what you are exactly doing. > > > > See [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/help/) > > > > -- > > _David Pilato_ | _Technical Advocate_ | \*[Elasticsearch.com](http://Elasticsearch.com)[http://elasticsearch.com/](http://elasticsearch.com/) > > \* > > @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr[https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr) > > | @scrutmydocs [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs) > > > > Le 18 sept. 2013 à 00:25, Pashkevich Aleksandr [serio...@gmail.com](mailto:serio...@gmail.com) a > > écrit : > > > > i try that query > > > > > $comand =' curl -XPUT "[http://localhost:9200/test/type1/\_mapping](http://localhost:9200/test/type1/_mapping)" -d ' > > > { > > > > > > ``` > > > "properties" : { > > > "Params_1" : { > > > "type" : "string", > > > "store" : "yes", > > > "index" : "not_analyzed", > > > "null_value" : "na" > > > } > > > } > > > > > > ``` > > > > > > } > > > > and elastic return > > > > > {"ok":true,"acknowledged":true} > > > > then i run my query and elastic return the same result > > > > "facets" : {"tag" : {"\_type" : "terms","missing" : 0,"total" : 3151716,"other" : 0,"terms" : [ > > {"term" : "mores","count" : 525286}, {"term" : "more","count" : 525286}, {"term" : "text","count" : 525286}, {"term" : "texts","count" : 1050572} ]}} > > > > среда, 18 сентября 2013 г., 1:02:16 UTC+3 пользователь David Pilato > > написал: > > > > > You don't have to change the query but the mapping. > > > Have a look at Put Mapping API: > > > [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/reference/api/admin-indices-put-mapping/). > > > Set your field Params\_1 as not\_analyzed ( > > > [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/reference/mapping/core-types/)) and > > > then run again the same query. > > > > > > ## Hope this helps > > > > > > _David Pilato_ | _Technical Advocate_ | \*[Elasticsearch.com](http://Elasticsearch.com)[http://elasticsearch.com/](http://elasticsearch.com/) > > > \* > > > @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr[https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr) > > > | @scrutmydocs [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs) > > > > > > Le 17 sept. 2013 à 23:14, Pashkevich Aleksandr [serio...@gmail.com](mailto:serio...@gmail.com) a > > > écrit : > > > > > > Hello, sory for my English > > > > > > i am use that query for get all fields of one tag > > > > > > { > > > "query" : { > > > "match\_all" : { } > > > }, > > > "facets" : { > > > "Params\_1" : { > > > "terms" : { > > > "field" : "Params\_1", > > > } > > > } > > > } > > > } > > > > > > and elasticsearch return to me result > > > > > > "facets" : {"tag" : {"\_type" : "terms","missing" : 0,"total" : 3151716,"other" : 0,"terms" : [ > > > {"term" : "mores","count" : 525286}, {"term" : "more","count" : 525286}, {"term" : "text","count" : 525286}, {"term" : "texts","count" : 1050572} ]}} > > > > > > All great, but one small trouble. Me need to return a full term, for > > > example "more text", and don't return "more" and "text" as two different > > > terms. > > > How i can change query? > > > > > > -- > > > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com). > > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). > > > > -- > > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com). > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). > > -- > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com) \. > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- 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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [September 18, 2013, 6:31am UTC](https://discuss.elastic.co/t/question-about-facets-and-get-full-terms/13658/8 "2013-09-18T06:31:00Z")
As I said before, you have FIRST to remove your data (index or type at least). Please GIST a CURL recreation as explained in details at this URL: [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/help/) -- David Pilato | Technical Advocate | [Elasticsearch.com](http://Elasticsearch.com) @dadoonet | @elasticsearchfr | @scrutmydocs Le 18 sept. 2013 à 01:11, Pashkevich Aleksandr [serious2008@gmail.com](mailto:serious2008@gmail.com) a écrit : > when i use that sample from my php scripts > > esatics return that error > {"error":"MergeMappingException[Merge failed with failures {[mapper [Парметр\_1] has different index values, mapper [Парметр\_1] has different store values, mapper [Парметр\_1] has different tokenize values, mapper [Парметр\_1] has different index\_analyzer]}]","status":400} > when i try that sample form SSH console > elastics return > {"ok":true,"acknowledged":true} > and i try that curl query > curl -X POST "[http://localhost:9200/test/type1/\_search?pretty=true](http://localhost:9200/test/type1/_search?pretty=true)" -d ' > { > "query" : { > "match\_all" : { } > }, > "sort" : [ > {"Articul" : {"order" : "asc", "mode" : "avg"}} > ], > "facets" : { > "tag" : { > "terms" : { > "field" : "Params\_1" > } > } > } > } > ' > and result not change > > среда, 18 сентября 2013 г., 2:02:31 UTC+3 пользователь David Pilato написал: > Your first curl command is incorrect. Type name is missing. > Look at the example with type tweet: > > $ curl -XPUT '[http://localhost:9200/twitter/tweet/\_mapping](http://localhost:9200/twitter/tweet/_mapping)' -d ' > { > "tweet" : { > "properties" : { > "message" : {"type" : "string", "store" : "yes"} > } > } > } > ' > > -- > David Pilato | Technical Advocate | [Elasticsearch.com](http://Elasticsearch.com) > @dadoonet | @elasticsearchfr | @scrutmydocs > > Le 18 sept. 2013 à 00:55, Pashkevich Aleksandr [serio...@gmail.com](mailto:serio...@gmail.com) a écrit : > > > Start a new index (delete the old one). > > Index again your documents. > > After that curl > > curl -XPUT "[http://localhost:9200/test/type1/\_mapping](http://localhost:9200/test/type1/_mapping)" -d ' > > { > > > > ``` > > "properties" : { > > "Params_1" : {"type" : "string", "index" : "not_analyzed"}, > > "Articul" : {"type" : "integer"} > > } > > > > ``` > > > > } > > ' > > I insert new value that query i use > > curl -XPOST localhost:9200/test/type3/368800 -d '{"Articul":"1","Names":"Sample 1","Price":"1232","Cat":"1","Params\_1":"text"}' > > curl -XPOST localhost:9200/test/type3/368801 -d '{"Articul":"7","Names":"Sample 2","Price":"1234","Cat":"1","Params\_1":"more mored text"}' > > curl -XPOST localhost:9200/test/type3/368802 -d '{"Articul":"10","Names":"Sample 3","Price":"124323","Cat":"2","Params\_1":"more text"}' > > when i add new record, i use that curl query > > curl -X POST "[http://localhost:9200/test/type1/\_search?pretty=true](http://localhost:9200/test/type1/_search?pretty=true)" -d ' > > { > > "query" : { > > "match\_all" : { } > > }, > > "sort" : [ > > {"Articul" : {"order" : "asc", "mode" : "avg"}} > > ], > > "facets" : { > > "tag" : { > > "terms" : { > > "field" : "Params\_1" > > } > > } > > } > > } > > ' > > and esatic return ordered records 1,10,7 rather than 1, 7, 10 and return facets terms > > "facets" : { > > "tag" : { > > "\_type" : "terms", > > "missing" : 0, > > "total" : 3151716, > > "other" : 0, > > "terms" : [ { > > "term" : "texts", > > "count" : 1050572 > > }, { > > "term" : "text", > > "count" : 525286 > > }, { > > "term" : "more", > > "count" : 525286 > > }, { > > "term" : "mores", > > "count" : 525286 > > } > > > > ] > > } > > } > > > > среда, 18 сентября 2013 г., 1:33:19 UTC+3 пользователь David Pilato написал: > > Start a new index (delete the old one). > > Index again your documents. > > Check logs. > > > > If it does not work, please provide a full curl recreation. It will hep to understand what you are exactly doing. > > > > See [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/help/) > > > > -- > > David Pilato | Technical Advocate | [Elasticsearch.com](http://Elasticsearch.com) > > @dadoonet | @elasticsearchfr | @scrutmydocs > > > > Le 18 sept. 2013 à 00:25, Pashkevich Aleksandr [serio...@gmail.com](mailto:serio...@gmail.com) a écrit : > > > > > i try that query > > > $comand =' curl -XPUT "[http://localhost:9200/test/type1/\_mapping](http://localhost:9200/test/type1/_mapping)" -d ' > > > { > > > > > > ``` > > > "properties" : { > > > "Params_1" : { > > > "type" : "string", > > > "store" : "yes", > > > "index" : "not_analyzed", > > > "null_value" : "na" > > > } > > > } > > > > > > ``` > > > > > > } > > > and elastic return > > > {"ok":true,"acknowledged":true} > > > > > > then i run my query and elastic return the same result > > > > > > > "facets" : {"tag" : {"\_type" : "terms","missing" : 0,"total" : 3151716,"other" : 0,"terms" : [ > > > > {"term" : "mores","count" : 525286}, {"term" : "more","count" : 525286}, {"term" : "text","count" : 525286}, {"term" : "texts","count" : 1050572} ]}} > > > > > > среда, 18 сентября 2013 г., 1:02:16 UTC+3 пользователь David Pilato написал: > > > You don't have to change the query but the mapping. > > > Have a look at Put Mapping API: [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/reference/api/admin-indices-put-mapping/). Set your field Params\_1 as not\_analyzed ([Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/reference/mapping/core-types/)) and then run again the same query. > > > > > > ## Hope this helps > > > > > > David Pilato | Technical Advocate | [Elasticsearch.com](http://Elasticsearch.com) > > > @dadoonet | @elasticsearchfr | @scrutmydocs > > > > > > Le 17 sept. 2013 à 23:14, Pashkevich Aleksandr [serio...@gmail.com](mailto:serio...@gmail.com) a écrit : > > > > > > > Hello, sory for my English > > > > > > > > i am use that query for get all fields of one tag > > > > > > > > { > > > > "query" : { > > > > "match\_all" : { } > > > > }, > > > > "facets" : { > > > > "Params\_1" : { > > > > "terms" : { > > > > "field" : "Params\_1", > > > > } > > > > } > > > > } > > > > } > > > > and elasticsearch return to me result > > > > > > > > "facets" : {"tag" : {"\_type" : "terms","missing" : 0,"total" : 3151716,"other" : 0,"terms" : [ > > > > {"term" : "mores","count" : 525286}, {"term" : "more","count" : 525286}, {"term" : "text","count" : 525286}, {"term" : "texts","count" : 1050572} ]}} > > > > > > > > All great, but one small trouble. Me need to return a full term, for example "more text", and don't return "more" and "text" as two different terms. > > > > How i can change query? > > > > > > > > -- > > > > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com). > > > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). > > > > > > -- > > > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com). > > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). > > > > -- > > 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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com). > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). > > -- > 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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- 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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 2:15am UTC](https://discuss.elastic.co/t/question-about-facets-and-get-full-terms/13658/9 "2017-07-06T02:15:50Z")