Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Fix the keyspace and table creation in test code for cutouts #235

Open
genghisken opened this issue Feb 10, 2025 · 2 comments
Open

Fix the keyspace and table creation in test code for cutouts #235

genghisken opened this issue Feb 10, 2025 · 2 comments
Assignees

Comments

@genghisken
Copy link
Collaborator

The definition of the keyspace and the cutouts table needs to be changed to reflect the new compaction strategy (TimeWindowCompactionStrategy) and expiration of the stamps.

@genghisken genghisken self-assigned this Feb 10, 2025
@genghisken
Copy link
Collaborator Author

Table creation should be something like:

CREATE TABLE cutouts.cutouts ("cutoutId" ascii,
        cutoutimage blob,
        imjd int,
        "objectId" bigint,
        PRIMARY KEY ("cutoutId", imjd) )
WITH compaction={'class': 'org.apache.cassandra.db.compaction.TimeWindowCompactionStrategy', 'compaction_window_size': '1', 'compaction_window_unit': 'DAYS'} AND default_time_to_live=86400;

Note that in the test script I'm proposing a 1 day time to live. We might even consider much shorter TTLs so we can actually test the TTL behaviour.

@RoyWilliams
Copy link
Contributor

Did this experiment on lasair-lsst-dev-cutoutcass and the cutouts disappeared in 1 days.

Now I have recreated the table with the standard create table

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants