# How to delete index permanently Elastic Search

**URL:** <https://discuss.elastic.co/t/how-to-delete-index-permanently-elastic-search/22957>\
**Category:** Elasticsearch\
**Created:** [March 28, 2015, 8:54am UTC](https://discuss.elastic.co/t/how-to-delete-index-permanently-elastic-search/22957 "2015-03-28T08:54:27Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![James\_Crone](https://avatars.discourse-cdn.com/v4/letter/j/e68b1a/32.png) [@James\_Crone](https://discuss.elastic.co/u/James_Crone)\
**Post date:** [March 28, 2015, 8:54am UTC](https://discuss.elastic.co/t/how-to-delete-index-permanently-elastic-search/22957/1 "2015-03-28T08:54:27Z")

</div>

localhost:9200/\_river/my\_update\_river/\_meta{  
"type" : "jdbc",  
"jdbc" : {  
"url" : "jdbc:mysql://localhost:3306/admin",  
"user" : "root",  
"password" : "",  
"poll" : "6s",  
"index" : "updateauto",  
"type" : "users",  
"schedule":"0/10 \* \* ? \* \*",  
"strategy" : "simple",  
"sql" : "select \* from users"  
}  
}

Here's my code and when i delete index it works for only 10seconds and when i refresh again it automatically created the index.

--  
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).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/6faeb492-a60d-49ca-bbcf-1de118ed8a4e%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/6faeb492-a60d-49ca-bbcf-1de118ed8a4e%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![Rafal\_Kuc\_3](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rafal_kuc_3/32/799_2.png) [@Rafal\_Kuc\_3](https://discuss.elastic.co/u/Rafal_Kuc_3)\
**Post date:** [March 28, 2015, 8:57am UTC](https://discuss.elastic.co/t/how-to-delete-index-permanently-elastic-search/22957/2 "2015-03-28T08:57:34Z")

</div>

Hello!

What are you truing to achieve? Do you want to stop the JDBC river from running? If so, try tunning:

curl -XDELETE 'localhost:9200/\_river/my\_update\_river'

It should stop the river. If you than delete the updateauto index it will be no longer created.

_--_

Regards,

Rafał Kuć

Performance Monitoring \* Log Analytics \* Search Analytics

Solr & Elasticsearch Support \* [http://sematext.com/](http://sematext.com/)

localhost:9200/\_river/my\_update\_river/\_meta

{

"type" : "jdbc",

"jdbc" : {

```
 "url" : "jdbc:mysql://localhost:3306/admin",

  "user" : "root",

  "password" : "",

  "poll" : "6s",

  "index" : "updateauto",

  "type" : "users",

  "schedule":"0/10 * * ? * *",

  "strategy" : "simple",

  "sql" : "select * from users"

}

```

}

Here's my code and when i delete index it works for only 10seconds and when i refresh again it automatically created the index.

--

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).

To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/6faeb492-a60d-49ca-bbcf-1de118ed8a4e%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/6faeb492-a60d-49ca-bbcf-1de118ed8a4e%40googlegroups.com?utm_medium=email&utm_source=footer).

For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![James\_Crone](https://avatars.discourse-cdn.com/v4/letter/j/e68b1a/32.png) [@James\_Crone](https://discuss.elastic.co/u/James_Crone)\
**Post date:** [March 28, 2015, 9:05am UTC](https://discuss.elastic.co/t/how-to-delete-index-permanently-elastic-search/22957/3 "2015-03-28T09:05:28Z")

</div>

I just want to refresh my elasticsearch and update my sql command. But when  
i post this code/query again it gives me error that index name "updateauto"  
already created and it gives my "created" : "false".

On Saturday, March 28, 2015 at 1:54:27 PM UTC+5, Abdul Rafay wrote:

> localhost:9200/\_river/my\_update\_river/\_meta{  
> "type" : "jdbc",  
> "jdbc" : {  
> "url" : "jdbc:mysql://localhost:3306/admin",  
> "user" : "root",  
> "password" : "",  
> "poll" : "6s",  
> "index" : "updateauto",  
> "type" : "users",  
> "schedule":"0/10 \* \* ? \* \*",  
> "strategy" : "simple",  
> "sql" : "select \* from users"  
> }  
> }
> 
> Here's my code and when i delete index it works for only 10seconds and when i refresh again it automatically created the index.

--  
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).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/275ee522-d6f2-4f44-8043-fcd1d10cb8de%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/275ee522-d6f2-4f44-8043-fcd1d10cb8de%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![Rafal\_Kuc\_3](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rafal_kuc_3/32/799_2.png) [@Rafal\_Kuc\_3](https://discuss.elastic.co/u/Rafal_Kuc_3)\
**Post date:** [March 28, 2015, 9:11am UTC](https://discuss.elastic.co/t/how-to-delete-index-permanently-elastic-search/22957/4 "2015-03-28T09:11:54Z")

</div>

Hello!

The command you show is creating the river ([https://github.com/jprante/elasticsearch-river-jdbc](https://github.com/jprante/elasticsearch-river-jdbc) ), not the 'updateauto' index itself. When the river starts running it will create the 'updateauto' index.

I'm not sure what you mean by 'refresh my elasticsearch', but I assume you would like to delete the already created index called 'updateauto' and change the river configuration. If so try the following set of commands:

curl -XDELETE 'localhost:9200/\_river/my\_update\_river' \<- it will delete the river resulting in stopping it

curl -XDELETE 'localhost:9200/updateauto' \<- this will delete the updateauto index

curl -XPOST 'localhost:9200/\_river/my\_update\_river/\_meta' -d '

{

"type" : "jdbc",

"jdbc" : {

```
 "url" : "jdbc:mysql://localhost:3306/admin",

  "user" : "root",

  "password" : "",

  "poll" : "6s",

  "index" : "updateauto",

  "type" : "users",

  "schedule":"0/10 * * ? * *",

  "strategy" : "simple",

  "sql" : "select * from users"

}

```

}'

Of course, the last command should be updated to match your needs before sending it.

_--_

Regards,

Rafał Kuć

Performance Monitoring \* Log Analytics \* Search Analytics

Solr & Elasticsearch Support \* [http://sematext.com/](http://sematext.com/)

I just want to refresh my elasticsearch and update my sql command. But when i post this code/query again it gives me error that index name "updateauto" already created and it gives my "created" : "false".

On Saturday, March 28, 2015 at 1:54:27 PM UTC+5, Abdul Rafay wrote:

localhost:9200/\_river/my\_update\_river/\_meta

{

"type" : "jdbc",

"jdbc" : {

```
 "url" : "jdbc:mysql://localhost:3306/admin",

  "user" : "root",

  "password" : "",

  "poll" : "6s",

  "index" : "updateauto",

  "type" : "users",

  "schedule":"0/10 * * ? * *",

  "strategy" : "simple",

  "sql" : "select * from users"

}

```

}

Here's my code and when i delete index it works for only 10seconds and when i refresh again it automatically created the index.

--

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).

To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/275ee522-d6f2-4f44-8043-fcd1d10cb8de%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/275ee522-d6f2-4f44-8043-fcd1d10cb8de%40googlegroups.com?utm_medium=email&utm_source=footer).

For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![James\_Crone](https://avatars.discourse-cdn.com/v4/letter/j/e68b1a/32.png) [@James\_Crone](https://discuss.elastic.co/u/James_Crone)\
**Post date:** [March 28, 2015, 9:30am UTC](https://discuss.elastic.co/t/how-to-delete-index-permanently-elastic-search/22957/5 "2015-03-28T09:30:44Z")

</div>

Hello!

Can we directly update index without deleting it?

On Saturday, March 28, 2015 at 2:12:08 PM UTC+5, Rafał Kuć wrote:

> Hello!
> 
> The command you show is creating the river (  
> [GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch](https://github.com/jprante/elasticsearch-river-jdbc) ), not the  
> 'updateauto' index itself. When the river starts running it will create the  
> 'updateauto' index.
> 
> I'm not sure what you mean by 'refresh my elasticsearch', but I assume you  
> would like to delete the already created index called 'updateauto' and  
> change the river configuration. If so try the following set of commands:
> 
> curl -XDELETE 'localhost:9200/\_river/my\_update\_river' \<- it will delete  
> the river resulting in stopping it
> 
> curl -XDELETE 'localhost:9200/updateauto' \<- this will delete the  
> updateauto index
> 
> curl -XPOST 'localhost:9200/\_river/my\_update\_river/\_meta' -d '  
> {  
> "type" : "jdbc",  
> "jdbc" : {  
> "url" : "jdbc:mysql://localhost:3306/admin",  
> "user" : "root",  
> "password" : "",  
> "poll" : "6s",  
> "index" : "updateauto",  
> "type" : "users",  
> "schedule":"0/10 \* \* ? \* \*",  
> "strategy" : "simple",  
> "sql" : "select \* from users"  
> }  
> }'
> 
> Of course, the last command should be updated to match your needs before  
> sending it.
> 
> \*-- Regards, Rafał Kuć Performance Monitoring \* Log Analytics \* Search  
> Analytics Solr & Elasticsearch Support \* \*[http://sematext.com/](http://sematext.com/)
> 
> I just want to refresh my elasticsearch and update my sql command. But  
> when i post this code/query again it gives me error that index name  
> "updateauto" already created and it gives my "created" : "false".
> 
> On Saturday, March 28, 2015 at 1:54:27 PM UTC+5, Abdul Rafay wrote:  
> localhost:9200/\_river/my\_update\_river/\_meta  
> {  
> "type" : "jdbc",  
> "jdbc" : {  
> "url" : "jdbc:mysql://localhost:3306/admin",  
> "user" : "root",  
> "password" : "",  
> "poll" : "6s",  
> "index" : "updateauto",  
> "type" : "users",  
> "schedule":"0/10 \* \* ? \* \*",  
> "strategy" : "simple",  
> "sql" : "select \* from users"  
> }  
> }
> 
> ## Here's my code and when i delete index it works for only 10seconds and when i refresh again it automatically created the index.
> 
> 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) \<javascript:\>.  
> To view this discussion on the web visit  
> [https://groups.google.com/d/msgid/elasticsearch/275ee522-d6f2-4f44-8043-fcd1d10cb8de%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/275ee522-d6f2-4f44-8043-fcd1d10cb8de%40googlegroups.com)  
> [https://groups.google.com/d/msgid/elasticsearch/275ee522-d6f2-4f44-8043-fcd1d10cb8de%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/275ee522-d6f2-4f44-8043-fcd1d10cb8de%40googlegroups.com?utm_medium=email&utm_source=footer)  
> .  
> For more options, visit [https://groups.google.com/d/optout](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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/24b53ed7-6ec1-47da-b561-bdce00cf1390%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/24b53ed7-6ec1-47da-b561-bdce00cf1390%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![Rafal\_Kuc\_3](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rafal_kuc_3/32/799_2.png) [@Rafal\_Kuc\_3](https://discuss.elastic.co/u/Rafal_Kuc_3)\
**Post date:** [March 28, 2015, 9:36am UTC](https://discuss.elastic.co/t/how-to-delete-index-permanently-elastic-search/22957/6 "2015-03-28T09:36:24Z")

</div>

Hello!

Which index you want to update and what you mean by update?

Do you want to change river configuration, for example change the SQL statement? Just delete the river and create it once again and it will do the job.

_--_

Regards,

Rafał Kuć

Performance Monitoring \* Log Analytics \* Search Analytics

Solr & Elasticsearch Support \* [http://sematext.com/](http://sematext.com/)

Hello!

Can we directly update index without deleting it?

On Saturday, March 28, 2015 at 2:12:08 PM UTC+5, Rafał Kuć wrote:

Hello!

The command you show is creating the river ([https://github.com/jprante/elasticsearch-river-jdbc](https://github.com/jprante/elasticsearch-river-jdbc) ), not the 'updateauto' index itself. When the river starts running it will create the 'updateauto' index.

I'm not sure what you mean by 'refresh my elasticsearch', but I assume you would like to delete the already created index called 'updateauto' and change the river configuration. If so try the following set of commands:

curl -XDELETE 'localhost:9200/\_river/my\_update\_river' \<- it will delete the river resulting in stopping it

curl -XDELETE 'localhost:9200/updateauto' \<- this will delete the updateauto index

curl -XPOST 'localhost:9200/\_river/my\_update\_river/\_meta' -d '

{

"type" : "jdbc",

"jdbc" : {

```
"url" : "jdbc:mysql://localhost:3306/admin",

 "user" : "root",

 "password" : "",

 "poll" : "6s",

 "index" : "updateauto",

 "type" : "users",

 "schedule":"0/10 * * ? * *",

 "strategy" : "simple",

 "sql" : "select * from users"

```

}

}'

Of course, the last command should be updated to match your needs before sending it.

_--_

Regards,

Rafał Kuć

Performance Monitoring \* Log Analytics \* Search Analytics

Solr & Elasticsearch Support \* [http://sematext.com/](http://sematext.com/)

I just want to refresh my elasticsearch and update my sql command. But when i post this code/query again it gives me error that index name "updateauto" already created and it gives my "created" : "false".

On Saturday, March 28, 2015 at 1:54:27 PM UTC+5, Abdul Rafay wrote:

localhost:9200/\_river/my\_update\_river/\_meta

{

"type" : "jdbc",

"jdbc" : {

```
"url" : "jdbc:mysql://localhost:3306/admin",

 "user" : "root",

 "password" : "",

 "poll" : "6s",

 "index" : "updateauto",

 "type" : "users",

 "schedule":"0/10 * * ? * *",

 "strategy" : "simple",

 "sql" : "select * from users"

```

}

}

Here's my code and when i delete index it works for only 10seconds and when i refresh again it automatically created the index.

--

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.

To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/275ee522-d6f2-4f44-8043-fcd1d10cb8de%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/275ee522-d6f2-4f44-8043-fcd1d10cb8de%40googlegroups.com?utm_medium=email&utm_source=footer).

For more options, visit [https://groups.google.com/d/optout](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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).

To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/24b53ed7-6ec1-47da-b561-bdce00cf1390%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/24b53ed7-6ec1-47da-b561-bdce00cf1390%40googlegroups.com?utm_medium=email&utm_source=footer).

For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![James\_Crone](https://avatars.discourse-cdn.com/v4/letter/j/e68b1a/32.png) [@James\_Crone](https://discuss.elastic.co/u/James_Crone)\
**Post date:** [March 28, 2015, 9:38am UTC](https://discuss.elastic.co/t/how-to-delete-index-permanently-elastic-search/22957/7 "2015-03-28T09:38:07Z")

</div>

Thank you. I understand 🙂

On Saturday, March 28, 2015 at 2:36:40 PM UTC+5, Rafał Kuć wrote:

> Hello!
> 
> Which index you want to update and what you mean by update?
> 
> Do you want to change river configuration, for example change the SQL  
> statement? Just delete the river and create it once again and it will do  
> the job.
> 
> \*-- Regards, Rafał Kuć Performance Monitoring \* Log Analytics \* Search  
> Analytics Solr & Elasticsearch Support \* \*[http://sematext.com/](http://sematext.com/)
> 
> Hello!
> 
> Can we directly update index without deleting it?
> 
> On Saturday, March 28, 2015 at 2:12:08 PM UTC+5, Rafał Kuć wrote:  
> Hello!
> 
> The command you show is creating the river (  
> [GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch](https://github.com/jprante/elasticsearch-river-jdbc) ), not the  
> 'updateauto' index itself. When the river starts running it will create the  
> 'updateauto' index.
> 
> I'm not sure what you mean by 'refresh my elasticsearch', but I assume you  
> would like to delete the already created index called 'updateauto' and  
> change the river configuration. If so try the following set of commands:
> 
> curl -XDELETE 'localhost:9200/\_river/my\_update\_river' \<- it will delete  
> the river resulting in stopping it
> 
> curl -XDELETE 'localhost:9200/updateauto' \<- this will delete the  
> updateauto index
> 
> curl -XPOST 'localhost:9200/\_river/my\_update\_river/\_meta' -d '  
> {  
> "type" : "jdbc",  
> "jdbc" : {  
> "url" : "jdbc:mysql://localhost:3306/admin",  
> "user" : "root",  
> "password" : "",  
> "poll" : "6s",  
> "index" : "updateauto",  
> "type" : "users",  
> "schedule":"0/10 \* \* ? \* \*",  
> "strategy" : "simple",  
> "sql" : "select \* from users"  
> }  
> }'
> 
> Of course, the last command should be updated to match your needs before  
> sending it.
> 
> \*-- Regards, Rafał Kuć Performance Monitoring \* Log Analytics \* Search  
> Analytics Solr & Elasticsearch Support \* \*[http://sematext.com/](http://sematext.com/)
> 
> I just want to refresh my elasticsearch and update my sql command. But  
> when i post this code/query again it gives me error that index name  
> "updateauto" already created and it gives my "created" : "false".
> 
> On Saturday, March 28, 2015 at 1:54:27 PM UTC+5, Abdul Rafay wrote:  
> localhost:9200/\_river/my\_update\_river/\_meta  
> {  
> "type" : "jdbc",  
> "jdbc" : {  
> "url" : "jdbc:mysql://localhost:3306/admin",  
> "user" : "root",  
> "password" : "",  
> "poll" : "6s",  
> "index" : "updateauto",  
> "type" : "users",  
> "schedule":"0/10 \* \* ? \* \*",  
> "strategy" : "simple",  
> "sql" : "select \* from users"  
> }  
> }
> 
> ## Here's my code and when i delete index it works for only 10seconds and when i refresh again it automatically created the index.
> 
> 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).  
> To view this discussion on the web visit  
> [https://groups.google.com/d/msgid/elasticsearch/275ee522-d6f2-4f44-8043-fcd1d10cb8de%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/275ee522-d6f2-4f44-8043-fcd1d10cb8de%40googlegroups.com)  
> [https://groups.google.com/d/msgid/elasticsearch/275ee522-d6f2-4f44-8043-fcd1d10cb8de%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/275ee522-d6f2-4f44-8043-fcd1d10cb8de%40googlegroups.com?utm_medium=email&utm_source=footer)  
> .  
> For more options, visit [https://groups.google.com/d/optout](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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com) \<javascript:\>.  
> To view this discussion on the web visit  
> [https://groups.google.com/d/msgid/elasticsearch/24b53ed7-6ec1-47da-b561-bdce00cf1390%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/24b53ed7-6ec1-47da-b561-bdce00cf1390%40googlegroups.com)  
> [https://groups.google.com/d/msgid/elasticsearch/24b53ed7-6ec1-47da-b561-bdce00cf1390%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/24b53ed7-6ec1-47da-b561-bdce00cf1390%40googlegroups.com?utm_medium=email&utm_source=footer)  
> .  
> For more options, visit [https://groups.google.com/d/optout](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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/9096d0d0-e313-4cfd-bca6-fe025ae1b7ae%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/9096d0d0-e313-4cfd-bca6-fe025ae1b7ae%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![jprante](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jprante/32/44941_2.png) [@jprante](https://discuss.elastic.co/u/jprante)\
**Post date:** [March 28, 2015, 10:58am UTC](https://discuss.elastic.co/t/how-to-delete-index-permanently-elastic-search/22957/8 "2015-03-28T10:58:38Z")

</div>

You should use \_id column name in the SQL statement to control update of  
documents by their ID.

No need to delete the river, or the index.

Jörg

On Sat, Mar 28, 2015 at 10:38 AM, Abdul Rafay [arafay696@gmail.com](mailto:arafay696@gmail.com) wrote:

> Thank you. I understand 🙂
> 
> On Saturday, March 28, 2015 at 2:36:40 PM UTC+5, Rafał Kuć wrote:
> 
> > Hello!
> > 
> > Which index you want to update and what you mean by update?
> > 
> > Do you want to change river configuration, for example change the SQL  
> > statement? Just delete the river and create it once again and it will do  
> > the job.
> > 
> > \*-- Regards, Rafał Kuć Performance Monitoring \* Log Analytics \* Search  
> > Analytics Solr & Elasticsearch Support \* \*[http://sematext.com/](http://sematext.com/)
> > 
> > Hello!
> > 
> > Can we directly update index without deleting it?
> > 
> > On Saturday, March 28, 2015 at 2:12:08 PM UTC+5, Rafał Kuć wrote:  
> > Hello!
> > 
> > The command you show is creating the river ([jprante (Jörg Prante) · GitHub](https://github.com/jprante/)  
> > elasticsearch-river-jdbc ), not the 'updateauto' index itself. When the  
> > river starts running it will create the 'updateauto' index.
> > 
> > I'm not sure what you mean by 'refresh my elasticsearch', but I assume  
> > you would like to delete the already created index called 'updateauto' and  
> > change the river configuration. If so try the following set of commands:
> > 
> > curl -XDELETE 'localhost:9200/\_river/my\_update\_river' \<- it will delete  
> > the river resulting in stopping it
> > 
> > curl -XDELETE 'localhost:9200/updateauto' \<- this will delete the  
> > updateauto index
> > 
> > curl -XPOST 'localhost:9200/\_river/my\_update\_river/\_meta' -d '  
> > {  
> > "type" : "jdbc",  
> > "jdbc" : {  
> > "url" : "jdbc:mysql://localhost:3306/admin",  
> > "user" : "root",  
> > "password" : "",  
> > "poll" : "6s",  
> > "index" : "updateauto",  
> > "type" : "users",  
> > "schedule":"0/10 \* \* ? \* \*",  
> > "strategy" : "simple",  
> > "sql" : "select \* from users"  
> > }  
> > }'
> > 
> > Of course, the last command should be updated to match your needs before  
> > sending it.
> > 
> > \*-- Regards, Rafał Kuć Performance Monitoring \* Log Analytics \* Search  
> > Analytics Solr & Elasticsearch Support \* \*[http://sematext.com/](http://sematext.com/)
> > 
> > I just want to refresh my elasticsearch and update my sql command. But  
> > when i post this code/query again it gives me error that index name  
> > "updateauto" already created and it gives my "created" : "false".
> > 
> > On Saturday, March 28, 2015 at 1:54:27 PM UTC+5, Abdul Rafay wrote:  
> > localhost:9200/\_river/my\_update\_river/\_meta  
> > {  
> > "type" : "jdbc",  
> > "jdbc" : {  
> > "url" : "jdbc:mysql://localhost:3306/admin",  
> > "user" : "root",  
> > "password" : "",  
> > "poll" : "6s",  
> > "index" : "updateauto",  
> > "type" : "users",  
> > "schedule":"0/10 \* \* ? \* \*",  
> > "strategy" : "simple",  
> > "sql" : "select \* from users"  
> > }  
> > }
> > 
> > ## Here's my code and when i delete index it works for only 10seconds and when i refresh again it automatically created the index.
> > 
> > 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).  
> > To view this discussion on the web visit [https://groups.google.com/d/](https://groups.google.com/d/)  
> > msgid/elasticsearch/275ee522-d6f2-4f44-8043-fcd1d10cb8de%  
> > [40googlegroups.com](http://40googlegroups.com)  
> > [https://groups.google.com/d/msgid/elasticsearch/275ee522-d6f2-4f44-8043-fcd1d10cb8de%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/275ee522-d6f2-4f44-8043-fcd1d10cb8de%40googlegroups.com?utm_medium=email&utm_source=footer)  
> > .  
> > For more options, visit [https://groups.google.com/d/optout](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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com)  
> > .  
> > To view this discussion on the web visit [https://groups.google.com/d/](https://groups.google.com/d/)  
> > msgid/elasticsearch/24b53ed7-6ec1-47da-b561-bdce00cf1390%  
> > [40googlegroups.com](http://40googlegroups.com)  
> > [https://groups.google.com/d/msgid/elasticsearch/24b53ed7-6ec1-47da-b561-bdce00cf1390%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/24b53ed7-6ec1-47da-b561-bdce00cf1390%40googlegroups.com?utm_medium=email&utm_source=footer)  
> > .  
> > For more options, visit [https://groups.google.com/d/optout](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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> To view this discussion on the web visit  
> [https://groups.google.com/d/msgid/elasticsearch/9096d0d0-e313-4cfd-bca6-fe025ae1b7ae%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/9096d0d0-e313-4cfd-bca6-fe025ae1b7ae%40googlegroups.com)  
> [https://groups.google.com/d/msgid/elasticsearch/9096d0d0-e313-4cfd-bca6-fe025ae1b7ae%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/9096d0d0-e313-4cfd-bca6-fe025ae1b7ae%40googlegroups.com?utm_medium=email&utm_source=footer)  
> .
> 
> For more options, visit [https://groups.google.com/d/optout](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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAKdsXoEuyd4Nh3wdV%2BUbxm37gdNipVuKEbuYyrtsgM9iXc3J8Q%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAKdsXoEuyd4Nh3wdV%2BUbxm37gdNipVuKEbuYyrtsgM9iXc3J8Q%40mail.gmail.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![James\_Crone](https://avatars.discourse-cdn.com/v4/letter/j/e68b1a/32.png) [@James\_Crone](https://discuss.elastic.co/u/James_Crone)\
**Post date:** [March 28, 2015, 11:05am UTC](https://discuss.elastic.co/t/how-to-delete-index-permanently-elastic-search/22957/9 "2015-03-28T11:05:51Z")

</div>

Hi thanks for reply.!

```
                      Can I use two sql command in single index? And 

```

also can i update my table name from existing index?

On Saturday, March 28, 2015 at 3:58:43 PM UTC+5, Jörg Prante wrote:

> You should use \_id column name in the SQL statement to control update of  
> documents by their ID.
> 
> No need to delete the river, or the index.
> 
> Jörg
> 
> On Sat, Mar 28, 2015 at 10:38 AM, Abdul Rafay \<[araf...@gmail.com](mailto:araf...@gmail.com)  
> \<javascript:\>\> wrote:
> 
> > Thank you. I understand 🙂
> > 
> > On Saturday, March 28, 2015 at 2:36:40 PM UTC+5, Rafał Kuć wrote:
> > 
> > > Hello!
> > > 
> > > Which index you want to update and what you mean by update?
> > > 
> > > Do you want to change river configuration, for example change the SQL  
> > > statement? Just delete the river and create it once again and it will do  
> > > the job.
> > > 
> > > \*-- Regards, Rafał Kuć Performance Monitoring \* Log Analytics \* Search  
> > > Analytics Solr & Elasticsearch Support \* \*[http://sematext.com/](http://sematext.com/)
> > > 
> > > Hello!
> > > 
> > > Can we directly update index without deleting it?
> > > 
> > > On Saturday, March 28, 2015 at 2:12:08 PM UTC+5, Rafał Kuć wrote:  
> > > Hello!
> > > 
> > > The command you show is creating the river ([jprante (Jörg Prante) · GitHub](https://github.com/jprante/)  
> > > elasticsearch-river-jdbc ), not the 'updateauto' index itself. When the  
> > > river starts running it will create the 'updateauto' index.
> > > 
> > > I'm not sure what you mean by 'refresh my elasticsearch', but I assume  
> > > you would like to delete the already created index called 'updateauto' and  
> > > change the river configuration. If so try the following set of commands:
> > > 
> > > curl -XDELETE 'localhost:9200/\_river/my\_update\_river' \<- it will delete  
> > > the river resulting in stopping it
> > > 
> > > curl -XDELETE 'localhost:9200/updateauto' \<- this will delete the  
> > > updateauto index
> > > 
> > > curl -XPOST 'localhost:9200/\_river/my\_update\_river/\_meta' -d '  
> > > {  
> > > "type" : "jdbc",  
> > > "jdbc" : {  
> > > "url" : "jdbc:mysql://localhost:3306/admin",  
> > > "user" : "root",  
> > > "password" : "",  
> > > "poll" : "6s",  
> > > "index" : "updateauto",  
> > > "type" : "users",  
> > > "schedule":"0/10 \* \* ? \* \*",  
> > > "strategy" : "simple",  
> > > "sql" : "select \* from users"  
> > > }  
> > > }'
> > > 
> > > Of course, the last command should be updated to match your needs before  
> > > sending it.
> > > 
> > > \*-- Regards, Rafał Kuć Performance Monitoring \* Log Analytics \* Search  
> > > Analytics Solr & Elasticsearch Support \* \*[http://sematext.com/](http://sematext.com/)
> > > 
> > > I just want to refresh my elasticsearch and update my sql command. But  
> > > when i post this code/query again it gives me error that index name  
> > > "updateauto" already created and it gives my "created" : "false".
> > > 
> > > On Saturday, March 28, 2015 at 1:54:27 PM UTC+5, Abdul Rafay wrote:  
> > > localhost:9200/\_river/my\_update\_river/\_meta  
> > > {  
> > > "type" : "jdbc",  
> > > "jdbc" : {  
> > > "url" : "jdbc:mysql://localhost:3306/admin",  
> > > "user" : "root",  
> > > "password" : "",  
> > > "poll" : "6s",  
> > > "index" : "updateauto",  
> > > "type" : "users",  
> > > "schedule":"0/10 \* \* ? \* \*",  
> > > "strategy" : "simple",  
> > > "sql" : "select \* from users"  
> > > }  
> > > }
> > > 
> > > ## Here's my code and when i delete index it works for only 10seconds and when i refresh again it automatically created the index.
> > > 
> > > 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).  
> > > To view this discussion on the web visit [https://groups.google.com/d/](https://groups.google.com/d/)  
> > > msgid/elasticsearch/275ee522-d6f2-4f44-8043-fcd1d10cb8de%  
> > > [40googlegroups.com](http://40googlegroups.com)  
> > > [https://groups.google.com/d/msgid/elasticsearch/275ee522-d6f2-4f44-8043-fcd1d10cb8de%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/275ee522-d6f2-4f44-8043-fcd1d10cb8de%40googlegroups.com?utm_medium=email&utm_source=footer)  
> > > .  
> > > For more options, visit [https://groups.google.com/d/optout](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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com)  
> > > .  
> > > To view this discussion on the web visit [https://groups.google.com/d/](https://groups.google.com/d/)  
> > > msgid/elasticsearch/24b53ed7-6ec1-47da-b561-bdce00cf1390%  
> > > [40googlegroups.com](http://40googlegroups.com)  
> > > [https://groups.google.com/d/msgid/elasticsearch/24b53ed7-6ec1-47da-b561-bdce00cf1390%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/24b53ed7-6ec1-47da-b561-bdce00cf1390%40googlegroups.com?utm_medium=email&utm_source=footer)  
> > > .  
> > > For more options, visit [https://groups.google.com/d/optout](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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com) \<javascript:\>.  
> > To view this discussion on the web visit  
> > [https://groups.google.com/d/msgid/elasticsearch/9096d0d0-e313-4cfd-bca6-fe025ae1b7ae%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/9096d0d0-e313-4cfd-bca6-fe025ae1b7ae%40googlegroups.com)  
> > [https://groups.google.com/d/msgid/elasticsearch/9096d0d0-e313-4cfd-bca6-fe025ae1b7ae%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/9096d0d0-e313-4cfd-bca6-fe025ae1b7ae%40googlegroups.com?utm_medium=email&utm_source=footer)  
> > .
> > 
> > For more options, visit [https://groups.google.com/d/optout](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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/fabd8f9e-9d18-4713-ae61-462bcd30c480%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/fabd8f9e-9d18-4713-ae61-462bcd30c480%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![jprante](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jprante/32/44941_2.png) [@jprante](https://discuss.elastic.co/u/jprante)\
**Post date:** [March 28, 2015, 12:20pm UTC](https://discuss.elastic.co/t/how-to-delete-index-permanently-elastic-search/22957/10 "2015-03-28T12:20:31Z")

</div>

Please read guideline at

> **[GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch](https://github.com/jprante/elasticsearch-jdbc#parameters-inside-of-the-jdbc-block)**
>
> JDBC importer for Elasticsearch. Contribute to jprante/elasticsearch-jdbc development by creating an account on GitHub.

You can not update tables with data by ES by JDBC plugin. It can only  
transport a tabular data stream from RDBMS to ES JSON. For more complex  
requirements, you should build an individual solution with an official ES  
client.

Jörg

On Sat, Mar 28, 2015 at 12:05 PM, Abdul Rafay [arafay696@gmail.com](mailto:arafay696@gmail.com) wrote:

> Hi thanks for reply.!
> 
> ```
> Can I use two sql command in single index? And
> 
> ```
> 
> also can i update my table name from existing index?
> 
> On Saturday, March 28, 2015 at 3:58:43 PM UTC+5, Jörg Prante wrote:
> 
> > You should use \_id column name in the SQL statement to control update of  
> > documents by their ID.
> > 
> > No need to delete the river, or the index.
> > 
> > Jörg
> > 
> > On Sat, Mar 28, 2015 at 10:38 AM, Abdul Rafay [araf...@gmail.com](mailto:araf...@gmail.com) wrote:
> > 
> > > Thank you. I understand 🙂
> > > 
> > > On Saturday, March 28, 2015 at 2:36:40 PM UTC+5, Rafał Kuć wrote:
> > > 
> > > > Hello!
> > > > 
> > > > Which index you want to update and what you mean by update?
> > > > 
> > > > Do you want to change river configuration, for example change the SQL  
> > > > statement? Just delete the river and create it once again and it will do  
> > > > the job.
> > > > 
> > > > \*-- Regards, Rafał Kuć Performance Monitoring \* Log Analytics \* Search  
> > > > Analytics Solr & Elasticsearch Support \* \*[http://sematext.com/](http://sematext.com/)
> > > > 
> > > > Hello!
> > > > 
> > > > Can we directly update index without deleting it?
> > > > 
> > > > On Saturday, March 28, 2015 at 2:12:08 PM UTC+5, Rafał Kuć wrote:  
> > > > Hello!
> > > > 
> > > > The command you show is creating the river ([jprante (Jörg Prante) · GitHub](https://github.com/jprante/)  
> > > > elasticsearch-river-jdbc ), not the 'updateauto' index itself. When  
> > > > the river starts running it will create the 'updateauto' index.
> > > > 
> > > > I'm not sure what you mean by 'refresh my elasticsearch', but I assume  
> > > > you would like to delete the already created index called 'updateauto' and  
> > > > change the river configuration. If so try the following set of commands:
> > > > 
> > > > curl -XDELETE 'localhost:9200/\_river/my\_update\_river' \<- it will  
> > > > delete the river resulting in stopping it
> > > > 
> > > > curl -XDELETE 'localhost:9200/updateauto' \<- this will delete the  
> > > > updateauto index
> > > > 
> > > > curl -XPOST 'localhost:9200/\_river/my\_update\_river/\_meta' -d '  
> > > > {  
> > > > "type" : "jdbc",  
> > > > "jdbc" : {  
> > > > "url" : "jdbc:mysql://localhost:3306/admin",  
> > > > "user" : "root",  
> > > > "password" : "",  
> > > > "poll" : "6s",  
> > > > "index" : "updateauto",  
> > > > "type" : "users",  
> > > > "schedule":"0/10 \* \* ? \* \*",  
> > > > "strategy" : "simple",  
> > > > "sql" : "select \* from users"  
> > > > }  
> > > > }'
> > > > 
> > > > Of course, the last command should be updated to match your needs  
> > > > before sending it.
> > > > 
> > > > \*-- Regards, Rafał Kuć Performance Monitoring \* Log Analytics \* Search  
> > > > Analytics Solr & Elasticsearch Support \* \*[http://sematext.com/](http://sematext.com/)
> > > > 
> > > > I just want to refresh my elasticsearch and update my sql command.  
> > > > But when i post this code/query again it gives me error that index name  
> > > > "updateauto" already created and it gives my "created" : "false".
> > > > 
> > > > On Saturday, March 28, 2015 at 1:54:27 PM UTC+5, Abdul Rafay wrote:  
> > > > localhost:9200/\_river/my\_update\_river/\_meta  
> > > > {  
> > > > "type" : "jdbc",  
> > > > "jdbc" : {  
> > > > "url" : "jdbc:mysql://localhost:3306/admin",  
> > > > "user" : "root",  
> > > > "password" : "",  
> > > > "poll" : "6s",  
> > > > "index" : "updateauto",  
> > > > "type" : "users",  
> > > > "schedule":"0/10 \* \* ? \* \*",  
> > > > "strategy" : "simple",  
> > > > "sql" : "select \* from users"  
> > > > }  
> > > > }
> > > > 
> > > > ## Here's my code and when i delete index it works for only 10seconds and when i refresh again it automatically created the index.
> > > > 
> > > > 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).  
> > > > To view this discussion on the web visit [https://groups.google.com/d/ms](https://groups.google.com/d/ms)  
> > > > gid/elasticsearch/275ee522-d6f2-4f44-8043-fcd1d10cb8de%40goo  
> > > > [glegroups.com](http://glegroups.com)  
> > > > [https://groups.google.com/d/msgid/elasticsearch/275ee522-d6f2-4f44-8043-fcd1d10cb8de%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/275ee522-d6f2-4f44-8043-fcd1d10cb8de%40googlegroups.com?utm_medium=email&utm_source=footer)  
> > > > .  
> > > > For more options, visit [https://groups.google.com/d/optout](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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com)  
> > > > .  
> > > > To view this discussion on the web visit [https://groups.google.com/d/ms](https://groups.google.com/d/ms)  
> > > > gid/elasticsearch/24b53ed7-6ec1-47da-b561-bdce00cf1390%40goo  
> > > > [glegroups.com](http://glegroups.com)  
> > > > [https://groups.google.com/d/msgid/elasticsearch/24b53ed7-6ec1-47da-b561-bdce00cf1390%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/24b53ed7-6ec1-47da-b561-bdce00cf1390%40googlegroups.com?utm_medium=email&utm_source=footer)  
> > > > .  
> > > > For more options, visit [https://groups.google.com/d/optout](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 [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com).  
> > > To view this discussion on the web visit [https://groups.google.com/d/](https://groups.google.com/d/)  
> > > msgid/elasticsearch/9096d0d0-e313-4cfd-bca6-fe025ae1b7ae%  
> > > [40googlegroups.com](http://40googlegroups.com)  
> > > [https://groups.google.com/d/msgid/elasticsearch/9096d0d0-e313-4cfd-bca6-fe025ae1b7ae%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/9096d0d0-e313-4cfd-bca6-fe025ae1b7ae%40googlegroups.com?utm_medium=email&utm_source=footer)  
> > > .
> > > 
> > > For more options, visit [https://groups.google.com/d/optout](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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> > To view this discussion on the web visit  
> > [https://groups.google.com/d/msgid/elasticsearch/fabd8f9e-9d18-4713-ae61-462bcd30c480%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/fabd8f9e-9d18-4713-ae61-462bcd30c480%40googlegroups.com)  
> > [https://groups.google.com/d/msgid/elasticsearch/fabd8f9e-9d18-4713-ae61-462bcd30c480%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/fabd8f9e-9d18-4713-ae61-462bcd30c480%40googlegroups.com?utm_medium=email&utm_source=footer)  
> > .
> 
> For more options, visit [https://groups.google.com/d/optout](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 [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAKdsXoFXUGm48z2K7vcB8Z8XkNuBzz0qZmaEwzjpmNGiHkCVnA%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAKdsXoFXUGm48z2K7vcB8Z8XkNuBzz0qZmaEwzjpmNGiHkCVnA%40mail.gmail.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**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, 12:23am UTC](https://discuss.elastic.co/t/how-to-delete-index-permanently-elastic-search/22957/11 "2017-07-06T00:23:18Z")

</div>