Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of comptechgeeky@gmail.com
 designates 74.125.82.177 as permitted sender)
MIME-Version: 1.0
From: Techy Teck <comptechgeeky@gmail.com>
Date: Sun, 3 Nov 2013 10:26:03 -0800
Message-ID: 
 <CAF+A=7romY+Yfbn25UF5BmDUEF4APNm5DBbV6TQV2Ka4oUJx9Q@mail.gmail.com>
Subject: Bad Request: No indexed columns present in by-columns clause with
 Equal operator?
To: user <user@cassandra.apache.org>
Content-Type: multipart/alternative; boundary=047d7b5d5710d3db0204ea49ef96

--047d7b5d5710d3db0204ea49ef96
Content-Type: text/plain; charset=ISO-8859-1

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

--047d7b5d5710d3db0204ea49ef96
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">I have below table in CQL-<br><br>create table test (<br>=
=A0=A0=A0 employee_id text,<br>=A0=A0=A0 employee_name text,<br>=A0=A0=A0 v=
alue text,<br>=A0=A0=A0 last_modified_date timeuuid,<br>=A0=A0=A0 primary k=
ey (employee_id)<br>=A0=A0 );<br>=A0=A0 <br>

=A0=A0 <br>I inserted couple of records in the above table like this which =
I will be inserting in our actual use case scenario as well- <br><br>=A0=A0=
=A0 insert into test (employee_id, employee_name, value, last_modified_date=
) values (&#39;1&#39;, &#39;e27&#39;,=A0 &#39;some_value&#39;, now());<br>

=A0=A0=A0 insert into test (employee_id, employee_name, value, last_modifie=
d_date) values (&#39;2&#39;, &#39;e27&#39;,=A0 &#39;some_new_value&#39;, no=
w());<br>=A0=A0=A0 insert into test (employee_id, employee_name, value, las=
t_modified_date) values (&#39;3&#39;, &#39;e27&#39;,=A0 &#39;some_again_val=
ue&#39;, now());<br>

=A0=A0=A0 insert into test (employee_id, employee_name, value, last_modifie=
d_date) values (&#39;4&#39;, &#39;e28&#39;,=A0 &#39;some_values&#39;, now()=
);<br>=A0=A0=A0 insert into test (employee_id, employee_name, value, last_m=
odified_date) values (&#39;5&#39;, &#39;e28&#39;,=A0 &#39;some_new_values&#=
39;, now());<br>

<br>=A0=A0=A0 <br>=A0=A0=A0 <br>Now I was doing select query for -=A0 give =
me all the employee_id for employee_name `e27`.<br><br>=A0=A0=A0 select emp=
loyee_id from test where employee_name =3D &#39;e27&#39;;<br>=A0=A0=A0 <br>=
And this is the error I am getting - <br>

<br>=A0=A0=A0 Bad Request: No indexed columns present in by-columns clause =
with Equal operator<br>=A0=A0=A0 Perhaps you meant to use CQL 2? Try using =
the -2 option when starting cqlsh.<br><br>=A0=A0 <br>Is there anything wron=
g I am doing here?<br>

<br>My use cases are in general - <br><br>=A01. Give me everything for any =
of the employee_name? <br>=A02. Give me everything for what has changed in =
last 5 minutes? <br>=A03. Give me the latest employee_id for any of the emp=
loyee_name?<br>

<br>I am running Cassandra 1.2.11<br><br></div>

--047d7b5d5710d3db0204ea49ef96--