incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alan Ristić <>
Subject How to search User (Entity) columns without sec. index?
Date Fri, 09 Nov 2012 12:51:36 GMT
Here is the thing. I'm modelling User entity and got to problem with
searching trough user columns.

  user_uuid uuid PRIMARY KEY,
  date_created timestamp,
  password varchar,
  username varchar,
  name varchar,
  first_name varchar,
  last_name varchar,
  email varchar,
) ;

CREATE INDEX users__username_idx ON users (username);

Now I know it's a bad practice to model sec. index on 'username' becouse of
uniqness and all but what's the alternative? I'd want 'username' to be

*Alan Ristić*

*m*: 040 423 688

View raw message