WriteOptions not allowing using timestamp about spring-data-cassandra HOT 7 CLOSED

Can you please be more specific? Where are you attempting to set using options for an insert statement?

from spring-data-cassandra.

I want to set timestamp in below code:
WriteOptions options = new WriteOptions();
options.setTtl(60);
options.setConsistencyLevel(ConsistencyLevel.ONE);
options.setRetryPolicy(RetryPolicy.DOWNGRADING_CONSISTENCY);

then use the execute(cql, queryWriteOptions); which accepts WriteOptions/QueryOptions as parameter.

from spring-data-cassandra.

I see TTL here;

But the insert syntax accepts TIMESTAMP as below:

::= INSERT INTO
'(' ( ',' )* ')'
VALUES '(' ( ',' )* ')'
( IF NOT EXISTS )?
( USING ( AND )* )?

::=
|

from spring-data-cassandra.

Here is the link to the syntax:
https://cassandra.apache.org/doc/cql3/CQL.html#selectStmt

from spring-data-cassandra.

Ah, I see. You've caught us midstream on a change where we're deprecating the method execute(String,QueryOptions). I haven't merged the code back in to master from branch DATACASS-145, but the problem is that there is a limitation in the underlying C* Java driver. We have no way of knowing what kind of statement is being given in the string, so we must use the driver's SimpleStatement class; see the code here. Unfortunately, SimpleStatement, which indirectly extends Statement, does not support setting the TTL. The new deprecation warning, if you want to see it, is here.

If you want to set TTL for an INSERT or UPDATE statement, you must either embed the USING clause into the given CQL string that you pass to execute(String,QueryOptions), or use one of either execute(Insert) or execute(Update) and use Insert or Update's support for TTL. If there were a way to construct an Insert or Update object via an arbitrary string, we might be able to once again support the method (albeit in another form), but the driver gives us no such capability.

I'm closing this issue, since we're at the underlying C* Java driver's mercy here. Sorry.

from spring-data-cassandra.

Incidentally, I'm not sure that WriteOptions ever supported a timestamp property. I've noted that we should add support for it in https://jira.spring.io/browse/DATACASS-155, though.

from spring-data-cassandra.

Thanks for the input Matthew. Its very helpful. Also thanking you for adding future support with timestamp.

from spring-data-cassandra.