Re: ***UNCHECKED*** Query regarding cassandra column write time set by client Timestamp Generator

2019-04-09 Thread Mahesh Daksha
Thank you Ben and Varun. Will try these approaches. On Tue, Apr 9, 2019 at 3:12 PM Varun Barala wrote: > I'm not sure about the use cases. But other approaches can also be > considered:- > > * Every mutation will have the timestamp in the commitlog [So taking > backup of the commitlogs will

Re: ***UNCHECKED*** Query regarding cassandra column write time set by client Timestamp Generator

2019-04-09 Thread Varun Barala
I'm not sure about the use cases. But other approaches can also be considered:- * Every mutation will have the timestamp in the commitlog [So taking backup of the commitlogs will give you this functionality] * At client side, you fetch the existing writetime for those columns from the db and also

Re: ***UNCHECKED*** Query regarding cassandra column write time set by client Timestamp Generator

2019-04-09 Thread Ben Slater
Maybe stabledump can help you? https://cassandra.apache.org/doc/4.0/tools/sstable/sstabledump.html --- *Ben Slater* *Chief Product Officer* Read our latest technical blog

Re: ***UNCHECKED*** Query regarding cassandra column write time set by client Timestamp Generator

2019-04-09 Thread Mahesh Daksha
Thanks Ben for your response. WRITETIME gives the information of about the column value already residing int the table. We intend to know the timestamp of the record which is about to apply/update. This is needed to understand the timestamp difference of the data residing in table with the one

Re: ***UNCHECKED*** Query regarding cassandra column write time set by client Timestamp Generator

2019-04-09 Thread Ben Slater
Not in the logs but I think you should be able to use the WRITETIME function to view via CQL (see https://cassandra.apache.org/doc/latest/cql/dml.html#select) Cheers Ben --- *Ben Slater* *Chief Product Officer*

***UNCHECKED*** Query regarding cassandra column write time set by client Timestamp Generator

2019-04-09 Thread Mahesh Daksha
Hello, I have configured the timestamp generator at cassandra client as below: cluster.setTimestampGenerator(new AtomicMonotonicTimestampGenerator()); My cassandra client inserting and updating few of the rows in a table. My query is where in the cassandra debug logs I can see the query write