[jira] [Updated] (CASSANDRA-9301) can not insert properly for compound primary key

[Carl Yeksigian (JIRA)]

     [ 
https://issues.apache.org/jira/browse/CASSANDRA-9301?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Carl Yeksigian updated CASSANDRA-9301:
--------------------------------------
    Description: 
Schema:

{code}
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'};
{code}

Tried many times for 3 million data and same data(49 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


  was:
have a table like 

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(49 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



> can not insert properly for compound primary key
> ------------------------------------------------
>
>                 Key: CASSANDRA-9301
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-9301
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Core
>         Environment: cassandra 2.1.3, oracle jdk 1.7, linux
>            Reporter: koray sariteke
>
> Schema:
> {code}
> 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'};
> {code}
> Tried many times for 3 million data and same data(49 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



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)