[
https://issues.apache.org/jira/browse/CASSANDRA-19345?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Brandon Williams updated CASSANDRA-19345:
-----------------------------------------
Summary: Not using min/max column name meta data from CASSANDRA-8180 when
the LIMIT clause is used (was: Optimize disk seek using min/max column name
meta data when the LIMIT clause is used)
> Not using min/max column name meta data from CASSANDRA-8180 when the LIMIT
> clause is used
> -----------------------------------------------------------------------------------------
>
> Key: CASSANDRA-19345
> URL: https://issues.apache.org/jira/browse/CASSANDRA-19345
> Project: Cassandra
> Issue Type: Bug
> Components: Legacy/Local Write-Read Paths
> Reporter: Avneesh Pandey
> Priority: Normal
> Fix For: 4.0.x, 4.1.x, 5.0.x, 5.x
>
> Attachments: Jira-Ticket.pdf
>
>
> {code:java}
> CREATE TABLE tracking_details (
> tracker_public_id text,
> updated_at timeuuid,
> details text,
> PRIMARY KEY (tracker_public_id, updated_at)
> ) WITH CLUSTERING ORDER BY (updated_at DESC){code}
> {code:java}
> INSERT INTO tracking_details (tracker_public_id, updated_at, details)
> VALUES('trk_e0544f077f7f4140bf1b961493fa99fe', now(), '{"details":[{...1-3KB
> }]}');{code}
> {code:java}
> nodetool flush trackingdata tracking_details{code}
> {code:java}
> INSERT INTO tracking_details (tracker_public_id, updated_at, details)
> VALUES('trk_e0544f077f7f4140bf1b961493fa99fe', now(), '{"details":[{...1-3KB
> }]}');
> INSERT INTO tracking_details (tracker_public_id, updated_at, details)
> VALUES('trk_e0544f077f7f4140bf1b961493fa99fe', now(), '{"details":[{...1-3KB
> }]}');{code}
> {code:java}
> nodetool flush trackingdata tracking_details{code}
> {code:java}
> Compaction is disabled-
> {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy',
> 'enabled': 'false', 'max_threshold': '32', 'min_threshold': '4'}{code}
> _Each node is reading from both sstables - *Merged data from memtables and 2
> sstables.*_
> I thought this was fixed -
> https://issues.apache.org/jira/browse/CASSANDRA-8180_
> _But somehow C* doesn't optimizes the read path_
> _Dev Cluster Info - 3 Nodes, RF is 3 and CL is LOCAL_QUORUM_
> _Tracing attached_
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
