...
- numeric threshold with soft/hard limits
- size threshold with soft/hard limits in bytes
- percentage threshold with soft/hard limits
- that trigger a warning or a failure
- have a boolean enabled/disabled flag that triggers a failure
- list of disallowed values that trigger a failure
- list of ignored values that trigger a warning
- pair of boolean predicates that trigger a warning or a failure
Reaching a soft limit should issue a warning, whereas reaching a hard limit issues a failure (InvalidRequestException).
...
Parameter | Example Limit | Notes |
---|---|---|
Single column size | 5 MB | Hard limit to prevent writing a large column value |
Number of columns per Tabletable | 50 | Hard limit to prevent creating too many columns per table |
Number of items fields per CollectionUDT | 2010 | Soft Hard limit to prevent creating collections with too many itemslarge UDTs |
Number of fields items per UDTcollection | 1020 | Hard Soft limit to prevent creating large UDTscollections with too many items |
Size of a collection | 5 MB | Soft limit that warns when encountering large collections |
Enable Useruser-provided timestamps | true | Whether to allow user-provided timestamps in write requests (USING TIMESTAMP...) |
Enable Readread-before-write List list operations | true | Whether to allow read-before-write list operations (setting/removing an item by index) |
Enable logged batch | true | Whether to allow LOGGED batches |
Enable truncate table | true | Whether to allow the truncation of tables |
Disallowed Table table properties | compression, compaction | List of table properties that are disallowed to be set by users |
Disallowed write consistency levels | ANY, ONE, LOCAL_ONE, ALL | List of Consistency Levels that are disallowed to be used during writes |
Ignored table properties | default_time_to_live | List of table properties that trigger a warning |
Number of secondary indexes per Tabletable | 1 | Hard limit to prevent having lots of secondary indexes per table |
Number of SASI indexes per table | 1 | Hard limit to prevent having lots of SASI indexes per table |
Number of MVs per Table | 2 | Hard limit to prevent having lots of MVs |
Total Number of Useruser-created Tables | 100 (soft) / 200 (hard) | Soft limit issues a warning when exceeded and hard limit issues a failure |
Large partition size | 100 MB | Soft limit that issues a warning when large partitions are being compacted |
Number of partition keys in SELECT | 20 | Hard limit |
Cartesian Product of values in IN condition | 25 | Hard limit. For example "a IN (1,2,...10) AND b IN (1,2...10)" results in cartesian product of 100 |
Disk usage | 70% (soft) / 80% (hard) | Local and Replica Disk usage are monitored to issue warnings/failures when the soft/hard limit is reached |
...