[ 
https://issues.apache.org/jira/browse/CASSANDRA-15977?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17281267#comment-17281267
 ] 

Sergey Kandyla commented on CASSANDRA-15977:
--------------------------------------------

[~adelapena]
we don't use UDTs and frozen collections.
Data model:
{code:java}
CREATE TABLE book_ticket (
 application_id text,
 user_id text,
 ticket_id text,
 book_type text,
 created_at_timestamp int,
 deleted_at int,
 ids set<text>,
 PRIMARY KEY ((application_id, user_id), ticket_id)
) WITH CLUSTERING ORDER BY (ticket_id ASC)
 AND bloom_filter_fp_chance = 0.01
 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
 AND comment = ''
 AND compaction = {'class': 
'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 
'max_threshold': '32', 'min_threshold': '4'}
 AND compression = {'chunk_length_in_kb': '64', 'class': 
'org.apache.cassandra.io.compress.LZ4Compressor'}
 AND crc_check_chance = 1.0
 AND dclocal_read_repair_chance = 0.0
 AND default_time_to_live = 0
 AND gc_grace_seconds = 864000
 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 = '99PERCENTILE';{code}

Typical request from golang application something like this:
{code:java}
SELECT deleted_at,ids FROM book_ticket WHERE application_id = ? AND user_id IN 
('5fff6d0e-2658-4e93-8f8a-05120a0f021d');{code}

user_id can be multiple values.
cassandra 3.11.10, 3 nodes, RF=3. gocql with consistency local_quorum.

> 4.0 Quality: Read Repair Test Audit
> -----------------------------------
>
>                 Key: CASSANDRA-15977
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-15977
>             Project: Cassandra
>          Issue Type: Task
>          Components: Test/dtest/java, Test/unit
>            Reporter: Andres de la Peña
>            Assignee: Andres de la Peña
>            Priority: Normal
>             Fix For: 3.11.9, 4.0, 4.0-beta3
>
>         Attachments: Screenshot 2021-02-05 at 18.01.10.png
>
>          Time Spent: 13h 50m
>  Remaining Estimate: 0h
>
> This is a subtask of CASSANDRA-15579 focusing on read repair.
> [This 
> document|https://docs.google.com/document/d/1-gldHcdLSMRbDhhI8ahs_tPeAZsjurjXr38xABVjWHE/edit?usp=sharing]
>  lists and describes the existing functional tests for read repair, so we can 
> have a broad view of what is currently covered. We can comment on this 
> document and add ideas for new cases/tests, so it can gradually evolve to a 
> more or less detailed test plan.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org

Reply via email to