Partitioning of data for each index type

Hi All,
I have a doubt regarding partitioning of data for every index type.

In our application the data in elastic search is in sync with DB. Each table in DB maps to an index type in elastic search.
We are now creating monthly partitions for all tables in DB, so that the old partitions can dropped as and when required.

Can we create monthly or weekly partitions for all index types in elastic search and drop the partition when its not required?
If not is there an alternative to achieve the partitioning feature in elastic search.

Thanks in advance,

Sounds like you want to have multiple indexes, one per month.
You can do it and have an alias on top of monthly indexes so your front end app will have to query on the alias.

Then, simply remove from the alias the old one and add the new one each month.
Then, drop the old index.

Does it help?

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 24 mai 2013 à 16:29, ymmud ymmudym@gmail.com a écrit :

Hi All,
I have a doubt regarding partitioning of data for every index type.

In our application the data in Elasticsearch is in sync with DB. Each
table in DB maps to an index type in Elasticsearch.
We are now creating monthly partitions for all tables in DB, so that the
old partitions can dropped as and when required.

Can we create monthly or weekly partitions for all index types in elastic
search and drop the partition when its not required?
If not is there an alternative to achieve the partitioning feature in
Elasticsearch.

Thanks in advance,

--
View this message in context: http://elasticsearch-users.115913.n3.nabble.com/Partitioning-of-data-for-each-index-type-tp4035456.html
Sent from the Elasticsearch Users mailing list archive at Nabble.com.

--
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.
For more options, visit 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.
For more options, visit https://groups.google.com/groups/opt_out.