cql3 - Cassandra can not delete role or user which in the role or user list -
create role testrole password = 'test'; create role testrole password = 'test'; list roles shows roles successfully. drop role testrole; invalidrequest: code=2200 [invalid query] message="testrole doesn't exist" drop role test1; invalidrequest: code=2200 [invalid query] message="test1 doesn't exist" image of cqlsh output. the role showed in list can not deleted. how can happen??? when not quoted, role names not preserve case, can see list roles output. if role names case-sensitive, you'll need enclose them in double quotes (like keyspace or table names). did edit output pasted? ask because shouldn't able run same create role statement twice shown. if so, else elided? suspect able drop role once, not second time (that's expected behaviour & i'm seeing).