[ https://issues.apache.org/jira/browse/CASSANDRA-8203?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Alexander Sterligov updated CASSANDRA-8203: ------------------------------------------- Description: I'm using static column. When I select whole table (with large limit) some of rows contain null static column value, but it cannot happen accoring to application logic. When I select same row using keys, static column has non-null value as expected. Schema: {quote} cqlsh:iss> describe table target_state; CREATE TABLE iss.target_state ( cell ascii, host ascii, service ascii, active ascii, cell_etag timeuuid static, etag timeuuid, states map<ascii, ascii>, PRIMARY KEY (cell, host, service) ) WITH CLUSTERING ORDER BY (host ASC, service ASC) AND bloom_filter_fp_chance = 0.01 AND caching = '\{"keys":"ALL", "rows_per_partition":"NONE"}' AND comment = '' AND compaction = \{'min_threshold': '4', 'unchecked_tombstone_compaction': 'true', 'tombstone_compaction_interval': '43200', 'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy', 'max_threshold': '32'} AND compression = \{'sstable_compression': 'org.apache.cassandra.io.compress.LZ4Compressor'} AND dclocal_read_repair_chance = 0.1 AND default_time_to_live = 0 AND gc_grace_seconds = 86400 AND max_index_interval = 2048 AND memtable_flush_period_in_ms = 0 AND min_index_interval = 128 AND read_repair_chance = 0.0 AND speculative_retry = '99.0PERCENTILE'; {quote} Whole table query: {quote} cqlsh:iss> select cell, host, service, cell_etag, etag from target_state LIMIT 50000; {quote} Contains in the middle of results: {quote} 60630000000065955650000000063097470000054552016:ya(200,15) | ams1-0003.search.yandex.net | 18265 | null | 737a05e0-5532-11e4-bf0b-efa731c31cd0 {quote} Row query gives non-null cell_etag column: {quote} cqlsh:iss> select host, service, cell_etag, etag from target_state where cell = '60630000000065955650000000063097470000054552016:ya(200,15)' and host = 'ams1-0003.search.yandex.net' and service = '18265'; host | service | cell_etag | etag -----------------------------+---------+--------------------------------------+-------------------------------------- ams1-0003.search.yandex.net | 18265 | bc635e60-5ec3-11e4-bdfd-9f65487c7454 | 737a05e0-5532-11e4-bf0b-efa731c31cd0 (1 rows) {quote} was: Schema: {quote} cqlsh:iss> describe table target_state; CREATE TABLE iss.target_state ( cell ascii, host ascii, service ascii, active ascii, cell_etag timeuuid static, etag timeuuid, states map<ascii, ascii>, PRIMARY KEY (cell, host, service) ) WITH CLUSTERING ORDER BY (host ASC, service ASC) AND bloom_filter_fp_chance = 0.01 AND caching = '\{"keys":"ALL", "rows_per_partition":"NONE"}' AND comment = '' AND compaction = \{'min_threshold': '4', 'unchecked_tombstone_compaction': 'true', 'tombstone_compaction_interval': '43200', 'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy', 'max_threshold': '32'} AND compression = \{'sstable_compression': 'org.apache.cassandra.io.compress.LZ4Compressor'} AND dclocal_read_repair_chance = 0.1 AND default_time_to_live = 0 AND gc_grace_seconds = 86400 AND max_index_interval = 2048 AND memtable_flush_period_in_ms = 0 AND min_index_interval = 128 AND read_repair_chance = 0.0 AND speculative_retry = '99.0PERCENTILE'; {quote} Range query: {quote} cqlsh:iss> select cell, host, service, cell_etag, etag from target_state LIMIT 50000; {quote} Contains in the middle of results: {quote} 60630000000065955650000000063097470000054552016:ya(200,15) | ams1-0003.search.yandex.net | 18265 | null | 737a05e0-5532-11e4-bf0b-efa731c31cd0 {quote} Data is unchanged, and another query gives non-null cell_etag column {quote} cqlsh:iss> select host, service, cell_etag, etag from target_state where cell = '60630000000065955650000000063097470000054552016:ya(200,15)' and host = 'ams1-0003.search.yandex.net' and service = '18265'; host | service | cell_etag | etag -----------------------------+---------+--------------------------------------+-------------------------------------- ams1-0003.search.yandex.net | 18265 | bc635e60-5ec3-11e4-bdfd-9f65487c7454 | 737a05e0-5532-11e4-bf0b-efa731c31cd0 (1 rows) {quote} > Unexpected null static column > ----------------------------- > > Key: CASSANDRA-8203 > URL: https://issues.apache.org/jira/browse/CASSANDRA-8203 > Project: Cassandra > Issue Type: Bug > Reporter: Alexander Sterligov > > I'm using static column. > When I select whole table (with large limit) some of rows contain null static > column value, but it cannot happen accoring to application logic. > When I select same row using keys, static column has non-null value as > expected. > Schema: > {quote} > cqlsh:iss> describe table target_state; > CREATE TABLE iss.target_state ( > cell ascii, > host ascii, > service ascii, > active ascii, > cell_etag timeuuid static, > etag timeuuid, > states map<ascii, ascii>, > PRIMARY KEY (cell, host, service) > ) WITH CLUSTERING ORDER BY (host ASC, service ASC) > AND bloom_filter_fp_chance = 0.01 > AND caching = '\{"keys":"ALL", "rows_per_partition":"NONE"}' > AND comment = '' > AND compaction = \{'min_threshold': '4', > 'unchecked_tombstone_compaction': 'true', 'tombstone_compaction_interval': > '43200', 'class': > 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy', > 'max_threshold': '32'} > AND compression = \{'sstable_compression': > 'org.apache.cassandra.io.compress.LZ4Compressor'} > AND dclocal_read_repair_chance = 0.1 > AND default_time_to_live = 0 > AND gc_grace_seconds = 86400 > AND max_index_interval = 2048 > AND memtable_flush_period_in_ms = 0 > AND min_index_interval = 128 > AND read_repair_chance = 0.0 > AND speculative_retry = '99.0PERCENTILE'; > {quote} > Whole table query: > {quote} > cqlsh:iss> select cell, host, service, cell_etag, etag from target_state > LIMIT 50000; > {quote} > Contains in the middle of results: > {quote} > 60630000000065955650000000063097470000054552016:ya(200,15) | > ams1-0003.search.yandex.net | 18265 | null > | 737a05e0-5532-11e4-bf0b-efa731c31cd0 > {quote} > Row query gives non-null cell_etag column: > {quote} > cqlsh:iss> select host, service, cell_etag, etag from target_state where cell > = '60630000000065955650000000063097470000054552016:ya(200,15)' and host = > 'ams1-0003.search.yandex.net' and service = '18265'; > host | service | cell_etag > | etag > -----------------------------+---------+--------------------------------------+-------------------------------------- > ams1-0003.search.yandex.net | 18265 | bc635e60-5ec3-11e4-bdfd-9f65487c7454 > | 737a05e0-5532-11e4-bf0b-efa731c31cd0 > (1 rows) > {quote} -- This message was sent by Atlassian JIRA (v6.3.4#6332)