CQL for Astra DB
You can run CQL commands against your Astra DB databases.
For information about working with CQL in Astra DB Classic, see the following:
CQL limits
To ensure high availability and optimum performance, Astra DB Classic databases have guardrails on underlying Apache Cassandra® functionality. For more information, see Astra DB Classic database limits.
User-defined objects
CQL for Astra DB doesn’t support user-defined functions (UDFs) or user-defined aggregate functions (UDAs).
Ignored values
If you try to use a CQL command with unsupported DDL properties, the command works, but ignores the unsupported values.
For example:
CREATE TABLE IF NOT EXISTS library.books
(
id UUID PRIMARY KEY,
lastname text,
firstname text)
WITH nodesync={'enabled': 'true'};The table is created with the defined attributes, except for the nodesync values.
The results show a warning that lists the unsupported values, which are ignored:
Warnings :
Ignoring provided values [nodesync] as they are not supported for Table
Properties(ignored values are: [additional_write_policy,
bloom_filter_fp_chance, caching, cdc, compaction, compression,
crc_check_chance, dse_edge_label_property, dse_vertex_label_property,
gc_grace_seconds, id, max_index_interval, memtable,
memtable_flush_period_in_ms, min_index_interval, nodesync, read_repair,
speculative_retry])Unsupported CQL commands
Operations concerning keyspaces, materialized views, functions, aggregates, and search indexes are generally not supported. This affects the following CQL commands, which are not supported in Astra DB:
-
CREATE KEYSPACE -
ALTER KEYSPACE -
DROP KEYSPACE -
CREATE MATERIALIZED VIEW -
ALTER MATERIALIZED VIEW -
DROP MATERIALIZED VIEW -
CREATE AGGREGATE -
DESCRIBE AGGREGATE -
DROP AGGREGATE -
CREATE FUNCTION -
DESCRIBE FUNCTION -
DROP FUNCTION -
CREATE TRIGGER -
DROP TRIGGER -
CREATE ROLE -
ALTER ROLE -
DROP ROLE -
LIST ROLES -
LIST PERMISSIONS -
RESTRICT -
RESTRICT ROWS -
UNRESTRICT -
UNRESTRICT ROWS -
CREATE SEARCH INDEX -
COMMIT SEARCH INDEX -
REBUILD SEARCH INDEX -
RELOAD SEARCH INDEX -
ALTER SEARCH INDEX SCHEMA -
ALTER SEARCH INDEX CONFIG -
DROP SEARCH INDEX CONFIG
For a list of supported CQL commands, see the CQL quick reference.
