I am trying to update a table-level TTL from unlimited to some determined value.
I have a statement syntax (which is pretty straight-forward): alter table <table_name> with default_time_to_live = <your_time_in_seconds>
I have tested this on my local (with existing records) and it works as advertized.
What I have a concern about is when I run this statement in PROD (where there are a lot of records), this statement might take a long time to run - long enough for my request to time out.
The reason I suspect that is because select count(*) timed out on the table in question.
It did run when I set the request timeout to 60 sec.
I was wondering what the default behavior is with respect to timed out requests: does it mean that the server is still processing the request and I just will not be able to see its completion or does it mean that the server gave up on the request (cancelled / rolled back, etc.)
How would that work with the alter statement above.