Does wrapping foo in single quotes help? Also, does this help http://www.datastax.com/blog/whats-new-cassandra-07-secondary-indexes
Aaron On 18/01/2011, at 11:54 PM, Timo Nentwig <timo.nent...@toptarif.de> wrote: > I put a secondary index on rc (IntegerType) and user_agent (AsciiType). > > Don't understand this bevahiour at all, can somebody explain? > > [default@tracking] get crawler where user_agent=foo and rc=200; > > 0 Row Returned. > [default@tracking] get crawler where rc=200 and user_agent=foo; > ------------------- > RowKey: -??>2 > => (column=rc, value=200, timestamp=1295347760933000) > => (column=url, value=http://www/0, timestamp=1295347760933000) > => (column=user_agent, value=foo, timestamp=1295347760915000) > > 1 Row Returned. > [default@tracking] get crawler where rc>199 and user_agent=foo; > > 0 Row Returned. > [default@tracking] get crawler where user_agent=foo; > ------------------- > RowKey: -??>7 > => (column=rc, value=207, timestamp=1295347760935000) > => (column=url, value=http://www/8, timestamp=1295347760933000) > => (column=user_agent, value=foo, timestamp=1295347760917000) > ------------------- > RowKey: -??>8 > => (column=rc, value=209, timestamp=1295347760935000) > => (column=url, value=http://www/9, timestamp=1295347760933000) > => (column=user_agent, value=foo, timestamp=1295347760916000) > ------------------- > RowKey: -??>5 > => (column=rc, value=201, timestamp=1295347760937000) > => (column=url, value=http://www/2, timestamp=1295347760933000) > => (column=user_agent, value=foo, timestamp=1295347760916000) > ------------------- > RowKey: -??>6 > => (column=rc, value=205, timestamp=1295347760935000) > => (column=url, value=http://www/5, timestamp=1295347760933000) > => (column=user_agent, value=foo, timestamp=1295347760917000) > ------------------- > RowKey: -??>2 > => (column=rc, value=200, timestamp=1295347760933000) > => (column=url, value=http://www/0, timestamp=1295347760933000) > => (column=user_agent, value=foo, timestamp=1295347760915000) > > 5 Rows Returned. >
