Cassandra "ninguna alternativa viable en la entrada"

cassandra-2.0

Question

Estoy tratando de insertar una fila simple en la tabla. ¿Alguien puede señalar lo que está pasando aquí?

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> insert into user_by_category (''game_category'',''customer_id'') VALUES (''Goku'',''12'') ;
SyntaxException: <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]...)">

Answer 1

Sintaxis incorrecta. Aquí estás:

inserte en user_by_category (game_category, customer_id) VALUES (''Goku'', ''12'');

o:

insertar en user_by_category ("game_category", "customer_id") VALUES (''Kakarot'', ''12'');

El segundo se usa normalmente para nombres de columna que distinguen entre mayúsculas y minúsculas.