Python操作Cassandra更新列报错：无法拼接str与UUID对象求助

Hey there, let's break down and fix this error you're hitting.

What's causing the error? #

The issue here is that row.id is a UUID object (not a plain string), and you're trying to concatenate it directly with your SQL query string. Python doesn't allow mixing string and UUID types in concatenation, hence the TypeError you're seeing.

Solution 1: Convert UUID to string (not recommended for production) #

You could explicitly convert the UUID to a string using str(row.id) to make the concatenation work. But a big caveat—this approach carries SQL injection risks if your data isn't fully trusted, so it's not ideal for production code:

active = session.execute("select id, status from address where status = 'A'")
for row in active:
    session.execute("update address set status = 'ACTIVE' where id = '" + str(row.id) + "'")

Solution 2: Use parameterized queries (best practice) #

The right, secure way to handle this is to use parameterized queries, which the Cassandra Python driver supports natively. This method automatically handles type conversion (including UUIDs) and eliminates SQL injection risks entirely. Here's how to rewrite your code:

active = session.execute("select id, status from address where status = 'A'")
update_query = "update address set status = 'ACTIVE' where id = %s"
for row in active:
    session.execute(update_query, (row.id,))

Why this works #

• The %s acts as a safe placeholder for the UUID value.
• When you pass (row.id,) as the second argument to session.execute(), the driver takes care of converting the UUID object to the exact format Cassandra expects.
• This is the industry-standard, maintainable way to interact with Cassandra (and most databases) from Python.

内容的提问来源于stack exchange，提问作者Hari