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 <https://twitter.com/dadoonet> |
> @elasticsearchfr<https://twitter.com/elasticsearchfr>
>
>
> Le 28 mars 2014 à 15:09:07, Arun Prasath ([email protected]<javascript:>)
> 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 <https://twitter.com/dadoonet> |
>> @elasticsearchfr<https://twitter.com/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 <https://twitter.com/dadoonet> |
>>> @elasticsearchfr<https://twitter.com/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<https://groups.google.com/d/msgid/elasticsearch/32ae7629-abd6-49fe-87a8-06dd075ed2a9%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 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<https://groups.google.com/d/msgid/elasticsearch/8bcbddec-294d-4c0b-93be-b52b376fa0c3%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 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<https://groups.google.com/d/msgid/elasticsearch/e7caf4c7-5320-4568-ba8e-41efa6d4c24c%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 the Google Groups
> "elasticsearch" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected] <javascript:>.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/elasticsearch/700353da-0f42-444f-84ad-3d1ff2615741%40googlegroups.com<https://groups.google.com/d/msgid/elasticsearch/700353da-0f42-444f-84ad-3d1ff2615741%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 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.
