I forgot to mention one of my use case in my previous email -  So here is the complete list of my use case again -

 1. Give me everything for any of the employee_name?
 2. Give me everything for what has changed in last 5 minutes?
 3. Give me the latest employee_id and value for any of the employee_name?
 4. Give me all the employee_id for any of the employee_name?






On Sun, Nov 3, 2013 at 10:26 AM, Techy Teck <comptechgeeky@gmail.com> wrote:
I have below table in CQL-

create table test (
    employee_id text,
    employee_name text,
    value text,
    last_modified_date timeuuid,
    primary key (employee_id)
   );
  
  
I inserted couple of records in the above table like this which I will be inserting in our actual use case scenario as well-

    insert into test (employee_id, employee_name, value, last_modified_date) values ('1', 'e27',  'some_value', now());
    insert into test (employee_id, employee_name, value, last_modified_date) values ('2', 'e27',  'some_new_value', now());
    insert into test (employee_id, employee_name, value, last_modified_date) values ('3', 'e27',  'some_again_value', now());
    insert into test (employee_id, employee_name, value, last_modified_date) values ('4', 'e28',  'some_values', now());
    insert into test (employee_id, employee_name, value, last_modified_date) values ('5', 'e28',  'some_new_values', now());

   
   
Now I was doing select query for -  give me all the employee_id for employee_name `e27`.

    select employee_id from test where employee_name = 'e27';
   
And this is the error I am getting -

    Bad Request: No indexed columns present in by-columns clause with Equal operator
    Perhaps you meant to use CQL 2? Try using the -2 option when starting cqlsh.

  
Is there anything wrong I am doing here?

My use cases are in general -

 1. Give me everything for any of the employee_name?
 2. Give me everything for what has changed in last 5 minutes?
 3. Give me the latest employee_id for any of the employee_name?

I am running Cassandra 1.2.11