[
https://issues.apache.org/jira/browse/CASSANDRA-15082?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16977210#comment-16977210
]
Alex Petrov commented on CASSANDRA-15082:
-----------------------------------------
This seems to be related to, or possibly a duplicate of [CASSANDRA-13478],
depending on which exactly part of issue is considered more important here. I
agree that a general purpose data base should have no such limitation.
Possibly, we could perform similar optimisation in a way that wouldn't force
user to pick an arbitrary number that sets upper limit on cardinality of the
data: fall back to non-sparse mode, or create overflow pages would be two
potential options.
> SASI SPARSE mode 5 limit
> ------------------------
>
> Key: CASSANDRA-15082
> URL: https://issues.apache.org/jira/browse/CASSANDRA-15082
> Project: Cassandra
> Issue Type: Improvement
> Components: Feature/SASI
> Reporter: Edward Capriolo
> Priority: Normal
>
> I do not know what the "improvement" should be here, but I ran into this:
> [https://github.com/apache/cassandra/blob/cassandra-3.11/src/java/org/apache/cassandra/index/sasi/disk/OnDiskIndexBuilder.java#L585]
> Term '55.3' belongs to more than 5 keys in sparse mode, which is not allowed.
> The only reference I can find to the limit is here:
> [http://www.doanduyhai.com/blog/?p=2058]
> Why is it 5? Could it be a variable? Could it be an option when creating the
> table? Why or why not?
> This seems awkward. A user can insert more then 5 rows into a table, and it
> "works". IE you can write and you can query that table getting more than 5
> results, but the index will not flush to disk. It throws an IOException.
> Maybe I am misunderstanding, but this seems impossible to support, if users
> inserts the same value 5 times, the entire index will not flush to disk?
--
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
