[jira] [Commented] (CASSANDRA-18534) Make sstable format configurable per table

["Maxwell Guo (Jira)" <ji...@apache.org>]

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

Maxwell Guo commented on CASSANDRA-18534:
-----------------------------------------

By re-reading the description of jira, I intend to carry out this task as follows: 
1. The configuration file supports sstable.format.options configuration, and the approximate format is as above; what about just call the sstable format : BigFormat and BtiFormat ? [~blambov]
2. I also hope to be able to use ddl to configure sstable format and even some sst options, but I need to see if I will encounter problems CASSANDRA-18040 as [~maedhroz] mentioned. [~dcapwell]



> Make sstable format configurable per table
> ------------------------------------------
>
>                 Key: CASSANDRA-18534
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-18534
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: Cluster/Schema, Local/SSTable
>            Reporter: Branimir Lambov
>            Assignee: Maxwell Guo
>            Priority: Normal
>             Fix For: 5.x
>
>
> Some SSTable format settings need to be configurable per table for better efficiency. This includes:
>  - {{row_index_granularity}}
>  - {{bloom_filter_fp_chance}}
>  - {{crc_check_chance}}
>  - {{min/max_index_interval}}
> Some of these are currently configurable using direct properties of tables. Having them as format properties makes better sense and should also support specifying useable combinations of settings, e.g.
> {code:java}
> CREATE TABLE ... WITH sstable_format = "bti-fast";
> CREATE TABLE ... WITH sstable_format = "bti-small";
> {code}
> where {{bti-fast}} and {{bti-small}} can be defined in {{cassandra.yaml}} e.g. as
> {code:java}
> sstable.format.options:
>   - bti-fast:
>       row_index_granularity: 1kiB
>       bloom_filter_fp_chance: 0.01
>   - bti-small:
>       row_index_granularity: 32kiB
>       bloom_filter_fp_chance: 0.1
> {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

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