When I tried creating a table, I wasn’t able to keep certain variable names like token, from etc… I am adding the CQL for create table. Could you please look into it and suggest some alternatives that we can use if we want to keep the field name as token, from and similar to these?
CREATE TABLE email_template (
name text PRIMARY KEY,
service text,
text_body text,
html_body text,
subject text,
priority text,
from text,
country text,
sender_name text,
email_type text,
created_by text,
created_at bigint,
updated_at bigint
) WITH compaction = {
‘class’: ‘SizeTieredCompactionStrategy’
};
On executing the query getting an error: SyntaxException: line 8:4 : Missing ‘)’
I found some alternative of keeping the variable name as ‘_from’ but this also fails and gives SyntaxException as mentioned above.