Hi Christian,
I ran into this problem last month; after some chasing I thought it was
possibly a bug in the Datastax driver, which I'm also using. The CQL protocol
itself supports dynamic TTLs fine.
One workaround that seems to work is to use an unnamed bind marker for the TTL
('?') and then set it using the "[ttl]" reserved name as the bind marker name
('setLong("[ttl]", myTtl)'), which will set the correct field in the bound
statement.
Best,
Nick?
________________________________
From: horschi <hors...@gmail.com>
Sent: 08 March 2016 13:52
To: user@cassandra.apache.org
Subject: Dynamic TTLs / limits still not working in 2.2 ?
Hi,
according to
CASSANDRA-4450<https://issues.apache.org/jira/browse/CASSANDRA-4450> it should
be fixed, but I still can't use dynamic TTLs or limits in my CQL queries.
Query:
update mytable set data=:data where ts=:ts and randkey=:randkey using ttl
:timetolive
Exception:
Caused by: com.datastax.driver.core.exceptions.SyntaxError: line 1:138 missing
EOF at 'using' (...:ts and randkey=:randkey [using] ttl...)
at com.datastax.driver.core.Responses$Error.asException(Responses.java:100)
I am using Cassandra 2.2 (using Datastax java driver 2.1.9) and I still see
this, even though the Jira ticket states fixVersion 2.0.
Has anyone used this successfully? Am I doing something wrong or is there still
a bug?
kind regards,
Christian
Tickets:
https://datastax-oss.atlassian.net/browse/JAVA-54
https://issues.apache.org/jira/browse/CASSANDRA-4450
