prepare() server internal error when using TTL

0

** <b>AWS Update:</b> Keyspaces now supports TTL: https://aws.amazon.com/blogs/database/announcing-amazon-keyspaces-time-to-live-ttl-general-availability/ **

I am seeing an internal error returrned from key space when I try to prepare the following statement.

		createAccessToken = getSession().prepare(  
				"INSERT INTO access_tokens" + "(atokenid, atoken, useruuid, auth, clientid, expiration, time, code, version)"  
						+ "VALUES (?,?,?,?,?, ?,?,?,?) IF NOT EXISTS USING TTL ?;");  

The issue appears to be with the USING TTL ? since the following prepare doesn't exhibit the issue.
createAccessToken = getSession().prepare(
"INSERT INTO access_tokens" + "(atokenid, useruuid, atoken, auth, clientid, code, expiration, time, version)"
+ "VALUES (?,?,?,?,?, ?,?,?,?) USING TTL 200;");
Anybody know of a work around that doesn't have me hard code the ttl?

Edited by: ArturoAtAWS on Oct 18, 2021 3:03 PM

質問済み 4年前226ビュー
3回答
0

Seems the issue is moot since Keyspaces doesn't support ttl.

回答済み 4年前
0

Thanks for the question and info! Our roadmap is driven by customer feedback so it's super helpful to get more info on how you are using prepared statements with TTL.

回答済み 4年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン