All we need is an easy explanation of the problem, so here it is.
When I query a table in my Cassandra database (in an EC2 instance), data before 2022-04-15 are not showing. The table had data from November of 2021.
I am new to Cassandra. What could have happened? Last week I exported data to CSV in addition to my usual work.
How to solve :
I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.
Method 1
Data doesn’t just magically disappear. There will be a reasonable explanation for it.
There’s a good chance that the data has expired, for example if the table has a default TTL of 3 months. However, all we can do is speculate since you haven’t provided sufficient information.
As a friendly note, I suggest you learn how to ask good questions. The general guidance is that you (a) provide a good summary of the problem that includes software/component versions, the full error message + full stack trace; (b) describe what you’ve tried to fix the problem, details of investigation you’ve done; and (c) minimal sample code that replicates the problem.
In your case, you need to provide the following:
- the schema of the table
- sample query you are running
- details of how your app writes to the table, i.e. does the write query set a TTL?
Cheers!
Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂
All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0