THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
- 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 |
...