[CASSANDRA-9301] can not insert properly for compound primary key

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Invalid

Environment

cassandra 2.1.3, oracle jdk 1.7, linux

• Severity: Normal
• Assignee: Unassigned
• Reporter: koray sariteke
• Created: 05/May/15 14:29
• Updated: 16/Apr/19 09:31
• Resolved: 07/May/15 14:43

Description

Schema:

CREATE KEYSPACE tick WITH replication = {
'class': 'SimpleStrategy',
'replication_factor': '2'
};

CREATE TABLE trade (
    date_symbol text,
    symbol text,
    signal_time bigint,
    signal_time_text text,
    bidask int,
    price double,
    quantity bigint,
    order_no bigint,
    PRIMARY KEY (date_symbol, signal_time)
    ) WITH
    compaction={'sstable_size_in_mb': '160', 'class': 'LeveledCompactionStrategy'} AND
    compression={'sstable_compression': 'LZ4Compressor'};

Tried many times for 3 million data and same data are not inserted. Increase data frequency but result dont change.

sample data at https://drive.google.com/file/d/0BzHZ-rv0D5JxSDRpblFQcUdRaVU/view?usp=sharing