Cassandra: missing ')' at '<missing '

user_14155178 0
Viewed 318

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 '
scylla cql cqlsh cassandra
2 Answers

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

Alex_Ott_186270

Since "schema" is a reserverd keyword, you cannot use your query in current form. If you intend to use it then you can do it as below

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

You can refer this page for reserved cql keywords.

user_29308120
Related