php - Pruning Columns in Cassandra -


I'm thinking of using Cassandra for a large data project. Data will be taken from traditional data warehouse. Cassandra will host data in a way that my application can read it correctly.

I do not quite understand how I will sort data from Kaisandra. For example, I have to count the number of visits, special IP address has been planning to create this data every 24 hours on the website and I want to keep 2 IP addresses per week. My column structure looks like this: <127> P> How to remove at least rows from visitors?

So far, the best solution I have taken is this:

  1. Find the column I want to work with
  2. Prices
  3. Re-insert new sliced ​​column

This is like a bad method Seems to work with the database, I agree that my figure size will be balloon, the basis of the way storage is done in Cassandra Su.

Is there a more efficient way to do this?

I am currently working with my interface.

Thank you!

You do not really want to delete and rewrite the entire column, assuming that you have a supercompany here Using, you can only remove a specific key from within the supercoll (in this case the visitor last 24 hours). You will cross specific key values ​​within the supercomputer, which are older than your cutoff time, and remove each of them. Every time you add or sub-line with a supercool, you do not have to rewrite the entire dataset. Items of Interest: Fragmentation and Deletion.


Comments