Cassandra: missing ')' at '<missing '

Question

tried to create the following table:

    CREATE TABLE customTableSchema(
        id UUID PRIMARY KEY,
        table_id UUID,
        schema text,
        created_at timestamp,
        last_modified_at timestamp,
    );

came up with this error:

SyntaxException: line 4:8 missing ')' at '<missing '

Answer 1

The schema is reserved keyword in the Cassandra Query Language, so you can't use it (see this table in the docs).