Cassandra no viable alternative at input

Question

I am trying to insert a simple row into the table  Can someone point out what is happening here         CREATE TABLE recommendation engine poc user by category           game category text          customer id text          amount double          game date timestamp          PRIMARY KEY  game category  customer id        WITH CLUSTERING ORDER BY  customer id ASC          AND bloom filter fp chance   0 01         AND caching      keys   ALL    rows per partition   NONE            AND comment              AND compaction     class    org apache cassandra db compaction SizeTieredCompactionStrategy           AND compression     sstable compression    org apache cassandra io compress LZ4Compressor           AND dclocal read repair chance   0 1         AND default time to live   0         AND gc grace seconds   864000         AND max index interval   2048         AND memtable flush period in ms   0         AND min index interval   128         AND read repair chance   0 0         AND speculative retry    99 0PERCENTILE        cqlsh recommendation engine poc gt  insert into user by category    game category   customer id   VALUES   Goku   12         SyntaxException   lt ErrorMessage code 2000  Syntax error in CQL query  message  line 1 31 no viable alternative at input  game category   insert into user by category     game categor       gt

User · Accepted Answer

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

[cassandra] Cassandra "no viable alternative at input"

Examples related to cassandra

Examples related to cassandra-2.0