[
https://issues.apache.org/jira/browse/CASSANDRA-12431?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15488899#comment-15488899
]
Fei Fang edited comment on CASSANDRA-12431 at 9/14/16 12:12 AM:
----------------------------------------------------------------
@Nate
Yes, correct.
For Cassandra version, here is another result (we upgraded to 2.2.7 recently).
{code}
cqlsh> select release_version from system.local ;
release_version
-----------------
2.2.7-SNAPSHOT
{code}
was (Author: feefeif...@gmail.com):
Yes, correct.
For Cassandra version, here is another result (we upgraded to 2.2.7 recently).
{code}
cqlsh> select release_version from system.local ;
release_version
-----------------
2.2.7-SNAPSHOT
{code}
> Getting null value for the field that has value when query result has many
> rows
> -------------------------------------------------------------------------------
>
> Key: CASSANDRA-12431
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12431
> Project: Cassandra
> Issue Type: Bug
> Reporter: Fei Fang
> Assignee: Edward Capriolo
> Fix For: 2.2.x
>
>
> Hi,
> We get null value (not an older value, but null) for a float column (score)
> from a 20k result row query. However, when we fetch data for that specific
> row, the column actually has value.
> The table schema is like this:
> {code}
> CREATE TABLE IF NOT EXISTS email_histogram (
> id text,
> email text,
> score float,
> PRIMARY KEY (id, email)
> ) WITH bloom_filter_fp_chance = 0.01
> AND caching = 'KEYS_ONLY'
> AND comment = ''
> AND compaction =
> {'tombstone_threshold': '0.1', 'tombstone_compaction_interval': '300',
> 'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
> AND compression =
> {'sstable_compression': 'org.apache.cassandra.io.compress.SnappyCompressor'}
> AND dclocal_read_repair_chance = 0.1
> AND default_time_to_live = 864000
> AND gc_grace_seconds = 86400
> AND memtable_flush_period_in_ms = 0
> AND read_repair_chance = 0.0
> AND speculative_retry = '99.0PERCENTILE';
> {code}
> This is my read query: SELECT * FROM " + TABLE_NAME + " WHERE guid = ?
> I'm using consistency One when querying it and Quorum when updating it. If I
> insert data, I insert for all the columns, never only part of the column. I
> understand that I might get out of date value since I'm using One to read,
> but again here I'm not getting out of date value, but just "null".
> This is happening on our staging server which servers 20k users, and we see
> this error happening 10+ times everyday. I don't have an exact number of how
> many times we do the query, but nodetool cfstats shows local read count of
> 85314 for this table for the last 18 hours and we have 6 cassandra nodes in
> this cluster so about 500k querying for 18 hours.
> We update the table every 3 weeks. The table has 20k rows for each key (guid)
> I'm querying for. Out of the 20k rows, only a couple at most are null and
> they are not the same every time we query the same key.
> We are using C# driver version 3.0.1 and Cassandra version 2.2.6.44.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
