Apache Cassandra 1.2 Documentation
Other CQL 3 Enhancements¶
Cassandra 1.2 introduced many enhancements in addition to the key CQL 3 improvements:
- New statement for altering the replication strategy: ALTER KEYSPACE
- Querying ordered data using additional operators such as >=.
- Compound keys and clustering
- Composite partition keys
- Safeguard against running risky queries
- Retrieve more information about cluster topology
- Increased query efficiency by using the clustering order
- Easy access to column timestamps
- Improved secondary index updates
- A table can now consist of only a primary key definition
- New inet data type
- New syntax for setting the replication strategy using a map collection
- Capability to query legacy tables
- Capability to rename a CQL 3 column
- Consistent case-sensitivity rules for keyspace, table, and column names
- Configurable tombstone removal by setting a CQL table property
Other changes¶
Some of these changes affect CQL queries directly and others indirectly.
- Support for legacy tables
- Option used to start cqlsh in CQL 2 mode
- CLI command to query CQL 3 table
- New syntax for setting compression and compaction
- New compaction sub-properties for configuing the size-tiered bucketing process
- Change to the consistency level, now set in the driver instead of CQL or globally using cqlsh
- Capability to drop a column from a table temporarily removed
- The WITH CONSISTENCY LEVEL clause has been removed from CQL commands. Programmatically, you now set the consistency level in the driver. On the command line, you can use a new cqlsh CONSISTENCY command.
- As of Cassandra 1.2.3, CQL 3 supports blob constants.
- As of Cassandra 1.2.3, new functions convert native types to blobs and perform timeuuid conversions.