This should fail. It's not a range query on date. Look at: http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/query-dsl-range-filter.html#query-dsl-range-filter or: http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/query-dsl-range-query.html
-- David Pilato | Technical Advocate | Elasticsearch.com @dadoonet | @elasticsearchfr Le 28 mars 2014 à 15:50:57, Arun Prasath ([email protected]) a écrit: I did , now it doesn't delete mapping/index but still records are not getting deleted for the given condition. I tried in both curl and Sense. Is the format correct. It it right way to delete records for date range. DELETE /local-test/logs-test/_query { "query" : { "term" : { "TransactionTime" : "from" : "2013-08-01", "to" : "2014-03-27"} } } Apreciate your Help. On Friday, March 28, 2014 10:27:39 AM UTC-4, David Pilato wrote: Ok. Thanks to Boaz for finding it. You did not run a DELETE by query: http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/docs-delete-by-query.html#docs-delete-by-query But a DELETE MAPPING: http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/indices-delete-mapping.html#indices-delete-mapping You need to add _query at the end. -- David Pilato | Technical Advocate | Elasticsearch.com @dadoonet | @elasticsearchfr Le 28 mars 2014 à 15:09:07, Arun Prasath ([email protected]) a écrit: Sorry.. Could you try with curl? - I don't know how to do this and where to execute curl. Could you please help me here. Should i execute curl in Fiddler or in Sense ? On Friday, March 28, 2014 10:03:34 AM UTC-4, David Pilato wrote: Hmmm… Wondering if SENSE support payload when using DELETE method… Could you try with curl? Could you check also your date format. I think it's wrong. If none of those works, please create a full curl recreation. -- David Pilato | Technical Advocate | Elasticsearch.com @dadoonet | @elasticsearchfr Le 28 mars 2014 à 15:00:01, Arun Prasath ([email protected]) a écrit: David, I'm using following command in Sense. Is this correct ? Index - local-test Type - logs-test DELETE /local-test/logs-test/ { "query" : { "range" : { "TransactionTime" : "from" : "2014-03-26 12:23:41", "to" : "2014-03-26 12:24:40"} } } Thanks, Arun On Friday, March 28, 2014 9:57:26 AM UTC-4, David Pilato wrote: Could you GIST a full curl recreation which reproduce your issue? See help if you don't know how to write it: http://www.elasticsearch.org/help -- David Pilato | Technical Advocate | Elasticsearch.com @dadoonet | @elasticsearchfr Le 28 mars 2014 à 14:55:09, Arun Prasath ([email protected]) a écrit: I tried in both the case it deletes complete index when criteria doesn't match. It should not delete if the condition doesn't match. Please let me know how to delete based on condition. Im trying this as TTL doesn't work. I don't know how to delete records from memory for particular date range. Appreicate your Help. On Thursday, March 27, 2014 5:55:05 PM UTC-4, David Pilato wrote: Use range not term -- David ;-) Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs Le 27 mars 2014 à 22:34, Arun Prasath <[email protected]> a écrit : Hi, I would need to delete records from particular Type with date range. I'm trying following command but it deletes all records from index. Is it right way to delete records. DELETE /index/type/ { "query" : { "term" : { "TransactionTime" : "from" : "2014-03-26 12:23:41", "to" : "2014-03-26 12:24:40"} } } Thanks, Arun -- 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/32ae7629-abd6-49fe-87a8-06dd075ed2a9%40googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- 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/8bcbddec-294d-4c0b-93be-b52b376fa0c3%40googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- 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/e7caf4c7-5320-4568-ba8e-41efa6d4c24c%40googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- 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/700353da-0f42-444f-84ad-3d1ff2615741%40googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- 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/3e7d9d0a-41b5-4270-a200-b45583022fde%40googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- 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/etPan.53358cb4.216231b.16bdd%40MacBook-Air-de-David.local. For more options, visit https://groups.google.com/d/optout.
