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.