Lindorm:Use Lindorm-cqlsh to connect to LindormTable

Step 1: Create a keyspace

A keyspace in Lindorm is equivalent to a database in a relational database system. It can contain one or more tables or column families.

Create a keyspace named test_keyspace:

CREATE KEYSPACE test_keyspace WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 1};

Verify that the keyspace was created:

DESCRIBE KEYSPACE test_keyspace;

Step 2: Switch to the keyspace

USE test_keyspace;

The prompt changes to confirm the active keyspace:

cqlsh:test_keyspace>

Step 3: Create a table

Create a table named test_user with two TEXT columns. first_name is the primary key.

CREATE TABLE test_user(first_name text, last_name text, PRIMARY KEY (first_name));

CREATE TABLE test_keyspace.test_user(first_name text, last_name text, PRIMARY KEY (first_name));

Verify the table structure:

DESCRIBE TABLE test_user;

The output shows both your custom settings and Cassandra default values for unsupported attributes.

Cassandra compatibility

Lindorm does not fully support all Cassandra table attributes. Unsupported attributes are still returned in DESCRIBE TABLE output, but their values reflect Cassandra defaults rather than actual settings.

Step 4: Insert data

INSERT INTO test_user (first_name, last_name) VALUES ('test', 'LINDORM');
INSERT INTO test_user (first_name, last_name) VALUES ('Zhang', 'San');
INSERT INTO test_user (first_name) VALUES ('Wu');

Step 5: Query data

Verify the row count:

SELECT COUNT(*) FROM test_user;

 count
-------
     3

(1 rows)

Query all rows:

SELECT * FROM test_user;

 first_name | last_name
------------+-----------
       test |    LINDORM
         Wu |      null
      Zhang |       San

(3 rows)

Step 6: Delete data

Delete a column value — remove last_name for a specific row, then verify:

DELETE last_name FROM test_user WHERE first_name='test';
SELECT * FROM test_user WHERE first_name='test';

 first_name | last_name
------------+-----------
       test |      null

Delete a row — remove the entire row, then verify:

DELETE FROM test_user WHERE first_name='test';
SELECT * FROM test_user WHERE first_name='test';

 first_name | last_name
------------+-----------

(0 rows)

Step 7: Truncate or drop a table

Only superusers can run TRUNCATE, DROP TABLE, and DROP KEYSPACE.

TRUNCATE test_user;
DROP TABLE test_user;

Search index

Use Lindorm Cassandra Query Language (CQL) commands to create a search index on a wide table. Before creating a search index, make sure the table attributes meet the requirements. For requirements, submit a ticket to contact technical support.

The following example creates a table tb, builds a search index tbidx on columns cn2 and cn3, and runs a fuzzy query:

CREATE TABLE test_keyspace.tb (cn1 text PRIMARY KEY, cn2 text, cn3 text) WITH extensions = {'CONSISTENCY_TYPE':'strong', 'MUTABILITY':'MUTABLE_LATEST'};
CREATE SEARCH INDEX tbidx ON test_keyspace.tb WITH COLUMNS (cn2, cn3);
REBUILD SEARCH INDEX ON test_keyspace.tb;
INSERT INTO test_keyspace.tb (cn1, cn2, cn3) VALUES ('v11', 'v12', 'v13');
SELECT * FROM test_keyspace.tb WHERE cn2 like '%v1';

Secondary index

Use Lindorm CQL commands to create a secondary index on a wide table. Before creating a secondary index, make sure the table attributes meet the requirements. For requirements, see Secondary index.

The following example creates a table tb, adds a secondary index tbidx on cn2, and queries by that column:

CREATE TABLE test_keyspace.tb (cn1 text PRIMARY KEY, cn2 text, cn3 text) WITH extensions = {'CONSISTENCY_TYPE':'strong', 'MUTABILITY':'MUTABLE_LATEST'};
CREATE INDEX tbidx ON test_keyspace.tb (cn2);
INSERT INTO test_keyspace.tb (cn1, cn2, cn3) VALUES ('v11', 'v12', 'v13');
SELECT * FROM test_keyspace.tb WHERE cn2 = 'v12';