DataStax Support Forums » Topic: Get on CF with key returning 0 results, but key exists when retrieving whole table using pycassa

DataStax Support Forums » Topic: Get on CF with key returning 0 results, but key exists when retrieving whole table using pycassa http://www.datastax.com/support-forums/topic/get-on-cf-with-key-returning-0-results-but-key-exists-when-retrieving-whole-table-using-pycassa Software, Support, and Training for Apache Cassandra en-US Fri, 24 May 2013 20:33:25 +0000 http://bbpress.org/?v=1.0.3 <![CDATA[Search]]> q http://www.datastax.com/support-forums/search.php nickmbailey on "Get on CF with key returning 0 results, but key exists when retrieving whole table using pycassa" http://www.datastax.com/support-forums/topic/get-on-cf-with-key-returning-0-results-but-key-exists-when-retrieving-whole-table-using-pycassa#post-9210 Thu, 28 Feb 2013 16:16:05 +0000 nickmbailey 9210@http://www.datastax.com/support-forums/ From what I can tell, this appears to be a bug. Can you file a bug report on the apache jira? <a href="https://issues.apache.org/jira/browse/CASSANDRA" rel="nofollow">https://issues.apache.org/jira/browse/CASSANDRA</a> Donald on "Get on CF with key returning 0 results, but key exists when retrieving whole table using pycassa" http://www.datastax.com/support-forums/topic/get-on-cf-with-key-returning-0-results-but-key-exists-when-retrieving-whole-table-using-pycassa#post-9166 Sun, 24 Feb 2013 09:31:52 +0000 Donald 9166@http://www.datastax.com/support-forums/ Hi, I should have added that when we are using cqlsh and looking for key 3997404 select key from u where key = 3997404; cqlsh:users> returns 0 results, even although when select * from u in cqlsh, or get the whole table in pycassa we see the row with the key 3997404 Sorry for the confusion. Regards D. Donald on "Get on CF with key returning 0 results, but key exists when retrieving whole table using pycassa" http://www.datastax.com/support-forums/topic/get-on-cf-with-key-returning-0-results-but-key-exists-when-retrieving-whole-table-using-pycassa#post-9133 Fri, 22 Feb 2013 15:11:36 +0000 Donald 9133@http://www.datastax.com/support-forums/ I should say that in pycassa when I try: userscf.get(3997404) File "test.py", line 10, in <module> userscf.get(3997404) File "/usr/local/lib/python2.7/dist-packages/pycassa/columnfamily.py", line 655, in get raise NotFoundException() pycassa.cassandra.ttypes.NotFoundException: NotFoundException(_message=None) It seems to be in Ints that are smaller than the average. Donald on "Get on CF with key returning 0 results, but key exists when retrieving whole table using pycassa" http://www.datastax.com/support-forums/topic/get-on-cf-with-key-returning-0-results-but-key-exists-when-retrieving-whole-table-using-pycassa#post-9132 Fri, 22 Feb 2013 14:59:48 +0000 Donald 9132@http://www.datastax.com/support-forums/ Hi, We have a table in Cassandra 1.2.0. That has an VarInt key. When we search keys we can see that they exist. Table description: CREATE TABLE u ( key varint PRIMARY KEY, ) WITH COMPACT STORAGE AND bloom_filter_fp_chance=0.010000 AND caching='KEYS_ONLY' AND comment='' AND dclocal_read_repair_chance=0.000000 AND gc_grace_seconds=864000 AND read_repair_chance=1.000000 AND replicate_on_write='true' AND compaction={'class': 'SizeTieredCompactionStrategy'} AND compression={'sstable_compression': 'SnappyCompressor'}; Select key from u limit 10; key ----------- 12040911 60619595 3220132 4602232 3997404 6312372 1128185 1507755 1778092 4701841 When I try and get the row for key 60619595 it works fine. cqlsh:users> select key from u where key = 60619595; key ----------- 60619595 cqlsh:users> select key from u where key = 3997404; cqlsh:users> When I use pycassa to get the whole table I can access the row. import pycassa from struct import * from pycassa.types import * from urlparse import urlparse import operator userspool = pycassa.ConnectionPool('users'); userscf = pycassa.ColumnFamily(userspool, 'u'); users = {} u = list(userscf.get_range()) for r in u: users[r[0]] = r[1] print users[3997404] returns the correct result. What am I doing wrong? I cannot see what the error is. Any help would be appreciated, Regards Donald. PS: I should say that in pycassa when I try: userscf.get(3997404) File "test.py", line 10, in <module> userscf.get(3997404) File "/usr/local/lib/python2.7/dist-packages/pycassa/columnfamily.py", line 655, in get raise NotFoundException() pycassa.cassandra.ttypes.NotFoundException: NotFoundException(_message=None) It seems to be in Ints that are smaller than the average.