卡桑德拉(Cassandra)有什么选择

Question

我试图在cql中重写一个sqlite查询。

我知道CQL中没有关键字。我用谷歌搜索了这是替代的。但是，我找不到任何东西。

UPDATE users SET passsword = ? WHERE user_name = ? AND EXISTS(SELECT 1 FROM 
users WHERE user_name = ? AND active_status = 1)

如何在CQL中编写此查询？任何帮助都将受到赞赏。谢谢。

Answer 1

This query may be broken down to 2 queries and put an additional java logic to filter the subqueries.That will be 2 calls to database layer
Resultset rs = stmt.execute ("SELECT user_name FROM 
users WHERE active_status = 1");
while ( rs.next()){
  stmt.executeUpdate("UPDATE users SET passsword = ? WHERE user_name = "+rs.next());
}