RE: group by select queries

2018-02-01 Thread Modha, Digant
:41, Modha, Digant <digant.mo...@tdsecurities.com<mailto:digant.mo...@tdsecurities.com>> wrote: It was local quorum. There’s no difference with CONSISTENCY ALL. Consistency level set to LOCAL_QUORUM. cassandra@cqlsh> select * from wp.position where account_id = 'user_1'; account_i

RE: group by select queries

2018-01-30 Thread Modha, Digant
It was local quorum. There’s no difference with CONSISTENCY ALL. Consistency level set to LOCAL_QUORUM. cassandra@cqlsh> select * from wp.position where account_id = 'user_1'; account_id | security_id | counter | avg_exec_price | pending_quantity | quantity | transaction_id | update_time

group by select queries

2018-01-25 Thread Modha, Digant
HI, I get two different out with these 2 queries. The only difference between the 2 queries is that one does 'select *' and other does 'select specific fields' without any aggregate functions. Does group by pick any record? It seems to pick either the first or the last record. I expected

RE: reiserfs - DirectoryNotEmptyException

2015-10-15 Thread Modha, Digant
.org Subject: Re: reiserfs - DirectoryNotEmptyException On 10/13/2015 01:58 PM, Modha, Digant wrote: > I am running Cassandra 2.1.10 and noticed intermittent > DirectoryNotEmptyExceptions during repair. My cassandra data drive is > reiserfs. Why? I'm genuinely interested in this filesys

reiserfs - DirectoryNotEmptyException

2015-10-13 Thread Modha, Digant
Hi, I am running Cassandra 2.1.10 and noticed intermittent DirectoryNotEmptyExceptions during repair. My cassandra data drive is reiserfs. I noticed that on reiserfs wiki site https://en.m.wikipedia.org/wiki/ReiserFS#Criticism, it states that unlink operation is not synchronous. Is that the

cassandra repair error

2015-07-16 Thread Modha, Digant
Hi, We're using Cassandra 2.0.10 ( 2 DC, 3 Nodes each RF=3 for each DC). During one of the weekly repairs, we received the following error: ERROR [ValidationExecutor:1280] 2015-07-12 22:18:10,992 Validator.java (line 242) Failed creating a merkle tree for [repair

RE: cassandra repair error

2015-07-16 Thread Modha, Digant
, 2015 at 2:45 PM, Modha, Digant digant.mo...@tdsecurities.commailto:digant.mo...@tdsecurities.com wrote: Hi, We’re using Cassandra 2.0.10 ( 2 DC, 3 Nodes each RF=3 for each DC). During one of the weekly repairs, we received the following error: ERROR [ValidationExecutor:1280] 2015-07-12 22:18

RE: Delete By Partition Key Implementation

2014-08-21 Thread Modha, Digant
If you delete entire row, do the records in the row still get counted towards computing TombstoneOverwhelmingException? It seems like they still do. From: DuyHai Doan [mailto:doanduy...@gmail.com] Sent: Saturday, August 09, 2014 3:21 AM To: user@cassandra.apache.org Subject: Re: Delete By

Delete row, TombstoneOverwhelmingException and multiple datacenters

2014-08-20 Thread Modha, Digant
Hi All, We have two data centers running Cassandra 2.0.9. Using local quorum consistency, I deleted an entire row that had 52,509 records by doing delete using only the partition key.When I count number of records for that row, I get 0 in the local datacenter from where the row was