Cassandra “no viable alternative at input”

Wrong syntax. Here you are:

insert into user_by_category (game_category,customer_id) VALUES
(‘Goku’,’12’);

or:

insert into user_by_category (“game_category”,”customer_id”) VALUES
(‘Kakarot’,’12’);

The second one is normally used for case-sensitive column names.