Lindorm is highly compatible with Cassandra Query Language (CQL). Take note of the following limits on syntax before you use CQL:
Lindorm does not support user-defined types (UDTs), user-defined functions (UDFs), and user-defined aggregates (UDAs).
Lindorm does not support materialized views.
Lindorm does not support triggers.
Lindorm does not support SSTable attached secondary indexes (SASI).
Data records cannot be deleted by range.
The BATCH operation is not supported.
Lindorm does not support the following data types: Collections, Duration, and Counter.
Clients cannot use a token aware policy to connect to Lindorm.
Apache Cassandra supports timestamps in microseconds. Lindorm supports timestamps in milliseconds. When you migrate data from Apache Cassandra to a Lindorm wide table, exclude the writeTime column of the data. A timestamp value in microseconds is much larger than a timestamp value in milliseconds. Lindorm determines the timestamp value in microseconds to be a future timestamp. This may cause various issues such as issues related to time to live (TTL), data deletion, and data updates.
To obtain more information about the limits, contact the Lindorm technical support.