Database / ScyllaDB Interview questions
What are the data types supported by ScyllaDB?
ScyllaDB, following CQL, supports a broad set of scalar and collection types for schema design:
- text / varchar, ascii - string data.
- int, bigint, smallint, tinyint, varint - integer types of varying width.
- float, double, decimal - numeric types, with decimal for exact precision.
- boolean - true/false.
- uuid, timeuuid - unique identifiers, with timeuuid encoding a sortable timestamp.
- timestamp, date, time - temporal types.
- blob - raw binary data.
- list, set, map - collection types.
- counter - a specialized type for distributed increment/decrement.
- User Defined Types (UDTs) - custom structured types composed of other types.
Counters and collections have special replication behavior, so they're used deliberately rather than as general-purpose containers for arbitrary data.
Which type is designed for distributed increment/decrement operations?
Which type encodes a sortable timestamp as part of its value?
More Related questions...
