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

["koray sariteke (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-9301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14530782#comment-14530782 ] 

koray sariteke edited comment on CASSANDRA-9301 at 5/7/15 8:09 AM:
-------------------------------------------------------------------

Tried the same scenario on empty table. Then able to query missed data over cqlsh for a short period of time. Then data was disapeared(probably after compaction).


was (Author: ksaritek):
Observe one thing, for a while, able to query missed data for a short period of time after inserted data. Then data was disapeared.

> 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)