Installation details ScyllaDB version: 6.2.1 Data model: CREATE TABLE data( p TEXT, c TIMESTAMP, v BLOB, PRIMARY KEY(p, c) ) Queries: Give me the first and the last value for each partition. SELECT * FROM data WHERE p IN (‘p1’, ‘p2’, ‘p3’) PER PARTITION LIMIT 1 Here is we can get the…

[image] Artem_Golovko: Question: Does scylla supports “per partition ordering” only? And if not, are there any plans to support it? The short answer is that ScyllaDB doesn’t support this and I’m not aware of any plans to support it either. Note that making the ordering restricted to a single…

Thanks for the answer, but I still didn’t get why we need read whole result in memory when we are sorting by clustering key, but in reversed order? Let’s have a look at the following queries: Get me first row for each partition and ignore sorting across the final result SELECT * FROM data WHERE p…

Thanks, sounds great. Do I need to create feature request on the github for that? Or this feature may be considered only for the Enterprise version?

Feel free to create a feature request issue in the open-source repository.

Per partition local ordering

ScyllaDB

Botond_Denes December 10, 2024, 8:43am 4

You are right, examples (1) and (3) do not require reading all results into memory, as the end results are partially sorted only.
I think this PER PARTITION ORDER would be possible to implement.

Topic		Replies	Views
Partitions in Scylla ScyllaDB	1	363	July 19, 2023
What is the best way to fetch N rows in ScyllaDB: Count, Limit or Paging? ScyllaDB data-model , ttl , drivers	2	4122	December 11, 2022
Latency issue and data retrieval, page size and number of threads (Java Driver) ScyllaDB data-model , java-driver , paging , latency , threads	0	112	December 23, 2024
Using IN in a query for a specific partition, is the entire partition fetched? ScyllaDB data-model , performance	0	72	July 23, 2024
Pagination with concurrent inserts, stale queries and caching ScyllaDB data-model , drivers , cache , consistency , paging	0	155	December 16, 2024

Per partition local ordering

Related topics