Finding by id in Cassandra does not work -

i'm having weird behavior cassandra. whenever try finding rows id, returns me null (either cqlsh console or clients), register exists if find field. example:

my table schema:

create table if not exists user_aggregation_new.user_aggregation_new (     userid timeuuid primary key,     fullname text,     birthdate text,     password text,     mobile text,     address frozen <address>,     thumbs map<text, text>,     driverlicense frozen <driverlicense>,     cpf text,     facebookid text,     membershipsince timestamp,     rating double,     email text,     status text,     facebookemail boolean,     bankaccount list<frozen <bankaccount>>,     dateupdated timestamp,     version bigint ); 

cassandra version: 3.7

why happening ?

you have 2 options :

• run nodetool repair on each node improve data consistency

• increase client consistency level. in cqlsh, run command consistency value quorum or all

then retry , if still not working.