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.