72435

Check current TTL on collection columns in Cassandra

Question:

Lets assume I have a Column Family with following schema:

CREATE TABLE users ( user_id timeuuid, name varchar, last_name varchar, children list, phone_numbers map, PRIMARY KEY(user_id) );

Then I insert a row into this CF with "USING TTL 60000". When I want to verify if any of these columns still has TTL set I get error: "Cannot use selection function ttl on collections".

My question is: how to get TTL on elements of a column that is defined as collection ?

Cheers!

Answer1:

I reproduced your problem -- naturally getting the very same result. The problem is that either (1) in collections TTL's are element-wise (one TTL per entry in collection) and (2) I found no way of getting entries from Maps or Lists. Of course I can delete one element -- but selecting it or it's TTL was not possible. Even the Datastax' CQL driver v2 has not provided the metadata for that. So you may change your data structure for that. If this was 'just' for testing purposes you have to trust Cassandra doing this well enough.

Recommend

  • Volley disable cache for one request
  • Firefox web push “Invalid URL endpoint”
  • Tibco RV: Message Lifetime + No Copy for fanouts
  • Getting Respond Time from Ping Command
  • Spring RabbitTemplate is not creating dead letter queue with TTL
  • Fiware Cygnus: no data have been persisted in CKAN
  • Calculate the depth of subclass in the OWL ontology
  • Conditional Formatting in VBA, based on functions
  • Access PCF DEV from external machine on same network as host
  • how to bypass pinentry (passphrase screen) while decrypting a file using gpgme
  • Regex for nested values
  • AlertDialog style when using setView()
  • Aptana 3 remove bundle (jquery)
  • Transactional Create with Validation in ServiceStack Redis Client
  • Why querying a date BC is changed to AD in Java?
  • Email verification using google app script and google forms
  • Database structure design with variable amounts of fields
  • Django: Count of Group Elements
  • ilmerge with a PFX file
  • Why value captured by reference in lambda is broken? [duplicate]
  • PHP - How to update data to MySQL when click a radio button
  • How to add a column to a Pandas dataframe made of arrays of the n-preceding values of another column
  • script to move all files from one location to another location
  • Join two tables and save into third-sql
  • How to handle AllServersUnavailable Exception
  • RestKit - RKRequestDelegate does not exist
  • Unanticipated behavior
  • using conditional logic : check if record exists; if it does, update it, if not, create it
  • Android Studio and gradle
  • Why joiner is not used after Sequence generator or Update statergy
  • Can't mass-assign protected attributes when import data from csv file
  • Recursive/Hierarchical Query Using Postgres
  • Running Map reduces the dimensions of the matrices
  • Binding checkboxes to object values in AngularJs
  • UserPrincipal.Current returns apppool on IIS
  • Unable to use reactive element in my shiny app
  • Android Heatmap on canvas or ImageView
  • Net Present Value in Excel for Grouped Recurring CF
  • jQuery Masonry / Isotope and fluid images: Momentary overlap on window resize
  • How to load view controller without button in storyboard?