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

2015-05-07 Thread koray sariteke (JIRA) 

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

koray sariteke commented on CASSANDRA-9301:
---

Try 3 scenarios and get same missing data result below,

scenario 1 -  three cluster and replication factor 2, consistency level one
scenario 2 - three cluster and replication factor 2, consistency level ALL
scenario 3 - one node

ALCTL 124989 27042015-110002
VKGYO 389702 27042015-170004
YKBNK 389712 27042015-170004
GLYHO 124985 27042015-110002
VKGYO 389700 27042015-170004
YKBNK 389719 27042015-170004
BJKAS 124981 27042015-110002
SANFM 389697 27042015-170004
YKBNK 389706 27042015-170004
BOYNR 389721 27042015-170004
TMSN 124978 27042015-110001 
GLYHO 124982 27042015-110002
SANFM 389698 27042015-170004
YKBNK 389709 27042015-170004
YKBNK 389710 27042015-170004
TMSN 124987 27042015-110002 
ODAS 114602 27042015-105048 
YKBNK 389708 27042015-170004
YKBNK 389716 27042015-170004
ODAS 109575 27042015-104700 
SODA 124980 27042015-110002 
SANFM 389692 27042015-170004
YKBNK 389714 27042015-170004
TMSN 124979 27042015-110001 
GLYHO 124983 27042015-110002
EUHOL 389701 27042015-170004
SODA 124986 27042015-110002 
SANFM 389699 27042015-170004
YKBNK 389715 27042015-170004
YKBNK 389707 27042015-170004
KARTN 389724 27042015-170004
SANFM 389695 27042015-170004
YKBNK 389703 27042015-170004
VADYTV 389720 27042015-170004
TMSN 124977 27042015-110001 
YKBNK 389704 27042015-170004
BOYNR 389722 27042015-170004
NTHOL 124988 27042015-110002
SANFM 389693 27042015-170004
YKBNK 389713 27042015-170004
YKBNK 389717 27042015-170004
YKBNK 389718 27042015-170004
SANFM 389694 27042015-170004
SANFM 389696 27042015-170004
DOAS 124976 27042015-110001 
GLYHO 124984 27042015-110002
YKBNK 389705 27042015-170004
YKBNK 389711 27042015-170004
KARTN 389723 27042015-170004
 

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

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

2015-05-06 Thread koray sariteke (JIRA) 

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

koray sariteke commented on CASSANDRA-9301:
---

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)

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

2015-05-05 Thread koray sariteke (JIRA) 

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

koray sariteke commented on CASSANDRA-9301:
---

provided data

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



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

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

2015-05-05 Thread Brandon Williams (JIRA) 

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

Brandon Williams commented on CASSANDRA-9301:
-

Please provide examples of your insert statements, or give us a simple way to 
reproduce this.

> 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
>
> have a table like 
> CREATE TABLE tickdata (
> key text,
> signal_time bigint,
> quantity bigint,
> PRIMARY KEY (key, 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.



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