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 log the actual timestamp which is associated with the current update/insert statements https://docs.datastax.com/en/drivers/java/3.6/com/datastax/driver/core/Statement.html#getDefaultTimestamp-- (though this should only be used for debugging purposes!) Thanks! On Tue, Apr 9, 2019 at 5:31 PM Ben Slater <ben.sla...@instaclustr.com> wrote: > Maybe stabledump can help you? > https://cassandra.apache.org/doc/4.0/tools/sstable/sstabledump.html > > --- > > > *Ben Slater* > *Chief Product Officer* > > > <https://www.facebook.com/instaclustr> <https://twitter.com/instaclustr> > <https://www.linkedin.com/company/instaclustr> > > Read our latest technical blog posts here > <https://www.instaclustr.com/blog/>. > > This email has been sent on behalf of Instaclustr Pty. Limited (Australia) > and Instaclustr Inc (USA). > > This email and any attachments may contain confidential and legally > privileged information. If you are not the intended recipient, do not copy > or disclose its content, but please reply to this email immediately and > highlight the error to the sender and then immediately delete the message. > > > On Tue, 9 Apr 2019 at 19:26, Mahesh Daksha <daks...@gmail.com> wrote: > >> 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 going to overwite the same. >> >> This all information is needed as out update statements going silent (not >> reflecting any changes) in database. Not even returning any error or >> exception. >> >> Thanks, >> Mahesh Daksha >> >> On Tue, Apr 9, 2019 at 2:46 PM Ben Slater <ben.sla...@instaclustr.com> >> wrote: >> >>> 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* >>> >>> >>> <https://www.facebook.com/instaclustr> >>> <https://twitter.com/instaclustr> >>> <https://www.linkedin.com/company/instaclustr> >>> >>> Read our latest technical blog posts here >>> <https://www.instaclustr.com/blog/>. >>> >>> This email has been sent on behalf of Instaclustr Pty. Limited >>> (Australia) and Instaclustr Inc (USA). >>> >>> This email and any attachments may contain confidential and legally >>> privileged information. If you are not the intended recipient, do not copy >>> or disclose its content, but please reply to this email immediately and >>> highlight the error to the sender and then immediately delete the message. >>> >>> >>> On Tue, 9 Apr 2019 at 16:51, Mahesh Daksha <daks...@gmail.com> wrote: >>> >>>> 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 >>>> time associated by with updated columns in the update query (sent by >>>> cient). Or if there is any other way I can log the same at client >>>> itself. >>>> >>>> Basically I want to see the write time sent by client to cassandra >>>> cluster. >>>> >>>> Thanks, >>>> Mahesh Daksha >>>> >>>