CQL query regarding indexes

2014-06-12 Thread Roshan
Hi Cassandra - 2.0.8 DataStax driver - 2.0.2 I have create a keyspace and a table with indexes like below. CREATE TABLE services.messagepayload ( partition_id uuid, messageid bigint, senttime timestamp, PRIMARY KEY (partition_id) ) WITH compression = { 'sstable_compression' :

Re: Cassandra Secondary Index implementation

2013-08-26 Thread Roshan
Hello First get some understanding about secondary indexes. http://www.datastax.com/docs/1.1/ddl/indexes Thanks. -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Cassandra-Secondary-Index-implementation-tp7589792p7589906.html Sent from the

Re: Decommission nodes starts to appear from one node (1.0.11)

2013-05-16 Thread Roshan
I found this bug, seems it is fixed. But I can see that in my situation, the decommission node still I can see from the JMX console LoadMap attribute. Might this is the reason why hector says not enough replica?? Experts, any thoughts?? Thanks. -- View this message in context:

Re: Decommission nodes starts to appear from one node (1.0.11)

2013-05-16 Thread Roshan
Thanks. This is kind of a expert advice for me. -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Decommission-nodes-starts-to-appear-from-one-node-1-0-11-tp7587842p7587876.html Sent from the cassandra-u...@incubator.apache.org mailing list

Re: Upgrade from 1.0.11 to 1.2.X

2013-05-14 Thread Roshan
) at org.apache.cassandra.service.StorageProxy.writeHintForMutation(StorageProxy.java:581) at org.apache.cassandra.service.StorageProxy$5.runMayThrow(StorageProxy.java:555) at org.apache.cassandra.service.StorageProxy$HintRunnable.run(StorageProxy.java:1643) ... 6 more Any reason? /Roshan -- View this message in context

Re: Upgrade from 1.0.11 to 1.2.X

2013-05-14 Thread Roshan
Thanks for your short answer. It explains lot. -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Upgrade-from-1-0-11-to-1-2-X-tp7587786p7587824.html Sent from the cassandra-u...@incubator.apache.org mailing list archive at Nabble.com.

Re: Upgrade from 1.0.11 to 1.2.X

2013-05-14 Thread Roshan
Thanks Aaron for the reply. I will need to upgrade 1.0.X to 1.1.X first. -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Upgrade-from-1-0-11-to-1-2-X-tp7587786p7587825.html Sent from the cassandra-u...@incubator.apache.org mailing list archive

Upgrade from 1.0.11 to 1.2.X

2013-05-13 Thread Roshan
Hi Haven't visit to this forum couple of months and want to upgrade our current production Cassandra cluster (4 nodes 1.0.11) to 1.2.X latest versions. Is this kind of the straight upgrade or different? Thanks Regards /Roshan -- View this message in context: http://cassandra-user

Re: Need help in updating metadata of an existing column family

2012-11-29 Thread Roshan Dawrani
Is it possible to update the column-metadata of a column family definition programmatically? If yes, can someone please point me to the right classes to use? Thanks. On Thu, Nov 29, 2012 at 3:58 PM, Roshan Dawrani roshandawr...@gmail.comwrote: Hi, I have an existing column family

How to change the seed node Cassandra 1.0.11

2012-10-23 Thread Roshan
Hi In our production, we have 3 Cassandra 1.0.11 nodes. Due to a reason, I want to move the current seed node to another node and once seed node change, the previous node want to remove from cluster. How can I do that? Thanks. -- View this message in context:

Re: How to purge the Hinted data from Cassandra 1.0.11

2012-08-08 Thread Roshan
I managed to delete the hints from JConsole by using HintedHadOffManager MBean. Thanks. -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/How-to-purge-the-Hinted-data-from-Cassandra-1-0-11-tp7581614p7581641.html Sent from the

How to purge the Hinted data from Cassandra

2012-08-07 Thread Roshan
for token: 113427455640312814857969558651062452224 with IP: /10.50.50.111 2012-08-08 08:56:54,383 INFO [HintedHandOffManager] Finished hinted handoff of 0 rows to endpoint /10.50.50.111 How can I remove this hints from node? Thanks /Roshan -- View this message in context: http://cassandra

One Cassandra 1.0.11 node continuously doing the hint hand off

2012-08-05 Thread Roshan
be safely ignore?? Thanks /Roshan -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/One-Cassandra-1-0-11-node-continuously-doing-the-hint-hand-off-tp7581599.html Sent from the cassandra-u...@incubator.apache.org mailing list archive at Nabble.com.

Re: Mixed cluster node with version 1.1.2 and 1.0.6 gives errors

2012-08-02 Thread Roshan
Thanks to point me the solution. So that means, I want to upgrade 1.0.6 cluster to 1.0.11 first, then upgrade to 1.1.2 version. Is I am right? Thanks /Roshan -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Mixed-cluster-node-with-version-1-1

Mixed cluster node with version 1.1.2 and 1.0.6 gives errors

2012-07-31 Thread Roshan
(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Any thoughts?? /Roshan -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Mixed-cluster

Error occures while doing the draing Cassandra 1.1.2

2012-07-29 Thread Roshan
Hi I got the below exception to Cassandra log while doing the *drain* via *nodetool* operation before shutting down one node in 3 node development Cassandra 1.1.2 cluster. 2012-07-30 09:37:45,347 ERROR [CustomTThreadPoolServer] Thrift error occurred during processing of message.

Cassandra 1.0.6 nodetool drain gives lots of batch_mutate exceptions

2012-07-29 Thread Roshan
should I need to do the drain without these exceptions? Thanks /Roshan -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Cassandra-1-0-6-nodetool-drain-gives-lots-of-batch-mutate-exceptions-tp7581497.html Sent from the cassandra-u

Cassandra Hector failover + load balancing not as expected with version 1.0-5

2012-07-22 Thread Roshan
statements, I am passing any configuration to hector to build up the connections. What I noticed is, every time hector uses zero element from the server list url and still try to connect to the same server, if it fails. Could someone help me to solve this hector fail over? Thanks /Roshan

Re: Concerns about Cassandra upgrade from 1.0.6 to 1.1.X

2012-07-12 Thread Roshan
Thanks Aaron. My major concern is upgrade node by node. Because currently we are using 1.0.6 in production and plan is to upgrade singe node to 1.1.2 at a time. Any comments? Thanks. -- View this message in context:

Concerns about Cassandra upgrade from 1.0.6 to 1.1.X

2012-07-11 Thread Roshan
). 2. How do we need to do upgrade process? Currently we have 3 node 1.0.6 cluster in production. Can we upgrade node by node? If we upgrade node by node, will the other 1.0.6 nodes identify 1.1.X nodes without any issue? Appreciate experts comments on this. Many Thanks. /Roshan -- View

Re: which high level Java client

2012-06-27 Thread Roshan
Hello We are using Hector and it perfectly matching to our case. https://github.com/hector-client/hector -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/which-high-level-Java-client-tp7580842p7580844.html Sent from the

Cassandra 1.0.6 data flush query

2012-06-21 Thread Roshan
: 200 in_memory_compaction_limit_in_mb: 16 (from 64MB) Key cache = 1 Row cache = 0 Could someone please help me on this. Thanks /Roshan -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Cassandra-1-0-6-data-flush-query-tp7580733.html Sent

Re: Subscribe

2012-06-12 Thread Roshan Dawrani
On Tue, Jun 12, 2012 at 8:56 PM, Jayesh Thakrar j_thak...@yahoo.com wrote: Subscribe Attempt unsuccessful, ** Was expecting a voice-command in mp3 format **

Re: Cassandra upgrade from 0.8.1 to 1.1.0

2012-06-03 Thread Roshan
Hi Hope this will help to you. http://www.datastax.com/docs/1.0/install/upgrading http://www.datastax.com/docs/1.1/install/upgrading Thanks. -- View this message in context:

Re: Cassandra 0.8.5: Column name mystery in create column family command

2012-05-23 Thread Roshan Dawrani
. Why am I seeing the error only now with this particular CF? Cheers, Roshan

Cassandra 0.8.5: Column name mystery in create column family command

2012-05-22 Thread Roshan Dawrani
be happening? I have created many such column families before and never run into this issue. -- Roshan http://roshandawrani.wordpress.com/

Re: Cassandra 0.8.5: Column name mystery in create column family command

2012-05-22 Thread Roshan Dawrani
-2012 4:32 PM, Roshan Dawrani roshandawr...@gmail.com wrote: Hi, I use Cassandra 0.8.5 and am suddenly noticing some strange behavior. I run a create column family command with some column meta-data and it runs fine, but when I do describe keyspace, it shows me different column names for those

Cassandra 1.0.6 multi data center read question

2012-05-17 Thread Roshan
a read operation on the production, will that read operation goes to DR as well? If so can I disable that call? My primary purpose is to keep the DR upto date and won't to communicate the production with DR. Thanks. /Roshan -- View this message in context: http://cassandra-user-incubator-apache-org

Re: Cassandra backup queston regarding commitlogs

2012-05-01 Thread Roshan
Many thanks Aaron. I will post a support issue for them. But will keep the snapshot + incremental backups + commitlogs to recover any failure situation. -- View this message in context:

Re: Cassandra backup queston regarding commitlogs

2012-04-30 Thread Roshan
the same keys with values? Appreciate your reply on this. Kind Regards /Roshan -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/deleted-tp7508823p7512499.html Sent from the cassandra-u...@incubator.apache.org mailing list archive at Nabble.com.

Re: Cassandra backup queston regarding commitlogs

2012-04-30 Thread Roshan
Many Thanks Aaron. According to the datastax restore documentation, they ask to remove the commitlogs before restoring (Clear all files the /var/lib/cassandra/commitlog (by default)). In that case better not to follow this step in a server rash situation. Thanks /Roshan -- View

Re: Cassandra backup queston regarding commitlogs

2012-04-29 Thread Roshan
Tamar Please don't jump to other users discussions. If you want to ask any issue, create a new one, please. Thanks. -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Cassandra-backup-question-regarding-commitlogs-tp7508823p7511913.html Sent

Cassandra backup question regarding commitlogs

2012-04-29 Thread Roshan
Hi Currently I am taking daily snapshot on my keyspace in production and already enable the incremental backups as well. According to the documentation, the incremental backup option will create an hard-link to the backup folder when new sstable is flushed. Snapshot will copy all the

Cassandra backup queston regarding commitlogs

2012-04-28 Thread Roshan
Hi Currently I am taking daily snapshot on my keyspace in production and already enable the incremental backups as well. According to the documentation, the incremental backup option will create an hard-link to the backup folder when new sstable is flushed. Snapshot will copy all the

Cassndra 1.0.6 GC query

2012-02-27 Thread Roshan
Hi Experts After getting an OOM error in production, I reduce the -XX:CMSInitiatingOccupancyFraction to .45 (from .75) and flush_largest_memtables_at to .45 (from .75). But still I am get an warning message in production for the same Cassandra node regarding OOM. Also reduce the concurrent

Re: Cassndra 1.0.6 GC query

2012-02-27 Thread Roshan
As a configuration issue, I haven't enable the heap dump directory. Is there another way to find the cause to this and identify possible configuration changes? Thanks. -- View this message in context:

Re: Best suitable value for flush_largest_memtables_at

2012-02-23 Thread Roshan
Thanks Aaron for the indormation. I increased the VM size to 2.4G from 1.4G. Please check my current CF in below. Keyspace: WCache: Replication Strategy: org.apache.cassandra.locator.SimpleStrategy Durable Writes: true Options: [replication_factor:3] Column Families: ColumnFamily:

Best suitable value for flush_largest_memtables_at

2012-02-22 Thread Roshan Pradeep
Hi Experts Under massive write load what would be the best value for Cassandra * flush_largest_memtables_at* setting? Yesterday I got an OOM exception in one of our production Cassandra node under heavy write load within 5 minute duration. I change the above setting value to .45 and also change

CQL query issue when fetching data from Cassandra

2012-02-15 Thread Roshan
Hi I am using Cassandra 1.0.6 version and having one column family in my keyspace. create column family TestCF with comparator = UTF8Type and column_metadata = [ {column_name : userid, validation_class : BytesType, index_name : userid_idx, index_type :

Re: Got fatal exception after upgrade to 1.0.7 from 1.0.6

2012-02-14 Thread Roshan
Issue seems related to https://issues.apache.org/jira/browse/CASSANDRA-3677 or exactly same. I am happy to create another if this is different. Please confirm. -- View this message in context:

Got fatal exception after upgrade to 1.0.7 from 1.0.6

2012-02-13 Thread Roshan
Hi I got the below exception to the system.log after upgrade to 1.0.7 from 1.0.6 version. I am using the same configuration files which I used in 1.0.6 version. 2012-02-14 10:48:12,379 ERROR [AbstractCassandraDaemon] Fatal exception in thread Thread[OptionalTasks:1,5,main]

Multiple data center nodetool ring output display 0% owns

2012-02-12 Thread Roshan
Hi I have deployed Cassandra 1.0.6 to a 2 data center and one data center (DC1) having one node and the other data center (DC2) having two nodes. But when I do a nodetool ring using one IP, the output says 0% owns of DC1 node. Please see the output below. # sh nodetool -h 10.XXX.XXX.XX ring

Re: Cassandra 1.0.6 multi data center question

2012-02-09 Thread Roshan Pradeep
Thanks Peter for the replies. Previously it was a typing mistake and it should be getting. I checked the DC2 (with having replica 0) and noticed that there is no SSTables created. I use java hector sample program to insert data to the keyspace. After I insert a data item, I 1) Login to one of

Lots of 0 Bytes tmp Data/Index files remain in data folder

2012-02-09 Thread Roshan
I have deployed 2 node Cassandra 1.0.6 cluster in production and it running almost t weeks without any issue. But I can see lots of (more than 90) 0 bytes tmp data and index files in the data directory. So far this is not a issue for me, but want to know why is that. Seems like this data/index

Cassandra 1.0.6 multi data center question

2012-02-08 Thread Roshan
Hi All I have 2 Cassandra data center (DC1=1 node, DC2=2 nodes). XXX.XXX.XXX.XXX DC2 RAC1Up Normal 44.3 KB 33.33% 0 YYY.YYY.YY.YYY DC1 RAC1Up Normal 48.71 KB 33.33%

Re: Cassandra 1.0.6 multi data center question

2012-02-08 Thread Roshan
I have create the Keyspace like below, but the result is same. All the data getting replicated to all over the cluster instead of DC1. create keyspace WSDC with placement_strategy = 'org.apache.cassandra.locator.NetworkTopologyStrategy' and strategy_options = {DC1:1,DC2:0}; -- View this

Re: Cassandra 1.0.6 multi data center question

2012-02-08 Thread Roshan
Thanks for the reply. But I can see the data setting inserted in DC1 in DC2. So that means data also getting replicated to DC2. Want to know how to restrict this? -- View this message in context:

Re: WARN [Memtable] live ratio

2012-02-07 Thread Roshan
It happens to me like this. I have 2 node Cassandra cluster with one column space. No super columns. Start server freshly (no commit logs, no SSTables, no saves caches, basically nothing). Then write process starts (not much write load). See what my log says: 2012-02-06 13:06:13,598 INFO

Re: WARN [Memtable] live ratio

2012-01-31 Thread Roshan
Thanks for the explanation. -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/WARN-Memtable-live-ratio-tp7238582p7242021.html Sent from the cassandra-u...@incubator.apache.org mailing list archive at Nabble.com.

Re: SSTable compaction issue in our system

2012-01-30 Thread Roshan Pradeep
compaction do it's thing. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 25/01/2012, at 12:47 PM, Roshan wrote: Thanks for the reply. Is the major compaction not recommended for Cassandra 1.0.6? -- View this message in context

WARN [Memtable] live ratio

2012-01-30 Thread Roshan
Hi All Time to time I am seen this below warning in Cassandra logs. WARN [Memtable] setting live ratio to minimum of 1.0 instead of 0.21084217381985554 Not sure what the exact cause for this and the solution to eliminate this. Any help is appreciated. Thanks. -- View this message in context:

Re: WARN [Memtable] live ratio

2012-01-30 Thread Roshan
Exactly, I am also getting this when server moving idle to high load. May be Cassandra Experts can help to us. -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/WARN-Memtable-live-ratio-tp7238582p7238603.html Sent from the

Re: How to speed up Waiting for schema agreement for a single node Cassandra cluster?

2011-10-04 Thread Roshan Dawrani
them is the fastest way Exactly the thing we also found out (and hence ditched truncate for DB cleanup between tests): http://roshandawrani.wordpress.com/2011/09/30/grails-cassandra-giving-each-test-a-clean-db-to-work-with/ . Worked much better for us this way. -- Roshan Blog: http

Re: [ANN] Usergrid, Open Source Mobile Data Platform built on Cassandra

2011-10-03 Thread Roshan Dawrani
you'll check it out and find it interesting. Even if it's not something you'd have use of yourself, please forward this on to people you know who are trying to build data-rich mobile apps. Thanks Ed -- Roshan Blog: http://roshandawrani.wordpress.com/ Twitter: @roshandawrani http

Re: Performance degradation observed through embedded cassandra server - pointers needed

2011-09-30 Thread Roshan Dawrani
, Cassandra: Giving each test a clean DB to work withhttp://roshandawrani.wordpress.com/2011/09/30/grails-cassandra-giving-each-test-a-clean-db-to-work-with/ For someone in a similar situation, it may present an alternative. Cheers. On Fri, Sep 23, 2011 at 1:29 PM, Roshan Dawrani roshandawr

Re: Performance degradation observed through embedded cassandra server - pointers needed

2011-09-23 Thread Roshan Dawrani
there in terms of performance. I was hoping data truncation leaving schema there would be faster than that. -- Roshan Blog: http://roshandawrani.wordpress.com/ Twitter: @roshandawrani http://twitter.com/roshandawrani Skype: roshandawrani

Performance degradation observed through embedded cassandra server - pointers needed

2011-09-22 Thread Roshan Dawrani
are in, is anyone aware of any cassandra 0.8.5 cofiguration that can be tweaked to at least get the performance we were getting with 0.7.2? Exactly after the upgrade, our test execution times have gone up at least by 60-70%. Some pointers please? Thanks. -- Roshan Blog: http://roshandawrani.wordpress.com

Re: segment fault with 0.8.5

2011-09-14 Thread Roshan Dawrani
migration of a simple cassandra DB from 0.7.0 to 0.8.5 and found quite a few differences in structure of cassandra.yaml - the biggest one that affected us was that cassandra.yaml couldn't hold the defintion of a keyspace, which we used for embedded cassandra we bring up for testing. -- Roshan Blog

Error in upgrading cassandra to 0.8.5

2011-09-13 Thread Roshan Dawrani
) at org.apache.cassandra.service.AbstractCassandraDaemon.activate(AbstractCassandraDaemon.java:341) at org.apache.cassandra.thrift.CassandraDaemon.main(CassandraDaemon.java:97) - -- Roshan Blog: http

Re: Error in upgrading cassandra to 0.8.5

2011-09-13 Thread Roshan Dawrani
remove the row cache files. On Tue, Sep 13, 2011 at 8:23 AM, Roshan Dawrani roshandawr...@gmail.com wrote: Hi, I am in the process of upgrading Cassandra to the recently released v0.8.5 and facing an issue. We had two Cassandra environments - one having 0.7.0 and another 0.7.2. The upgrade

Re: Error in upgrading cassandra to 0.8.5

2011-09-13 Thread Roshan Dawrani
On Tue, Sep 13, 2011 at 7:03 PM, Jonathan Ellis jbel...@gmail.com wrote: Just remove the row cache files. Thanks a lot. The 0.8.5 Cassandra started just fine after getting rid of those *KeyCache files. -- Roshan Blog: http://roshandawrani.wordpress.com/ Twitter: @roshandawrani http

Re: Cassandra -f problem

2011-09-12 Thread Roshan Dawrani
Hi, Do you have JAVA_HOME exported? If not, can you export it and retry? Cheers. On Tue, Sep 13, 2011 at 8:59 AM, Hernán Quevedo alexandros.c@gmail.comwrote: Hi, Roshan. This is great support, amazing support; not used to it :) Thanks for the reply. Well I think java is installed

Re: Cassandra -f problem

2011-09-11 Thread Roshan Dawrani
the process README file says it is suppose to start. Any help would be very appreciated. Thnx! -- Roshan Blog: http://roshandawrani.wordpress.com/ Twitter: @roshandawrani http://twitter.com/roshandawrani Skype: roshandawrani

Re: [RELEASE] Apache Cassandra 0.8.5 released

2011-09-08 Thread Roshan Dawrani
://issues.apache.org/jira/browse/CASSANDRA -- Roshan Blog: http://roshandawrani.wordpress.com/ Twitter: @roshandawrani http://twitter.com/roshandawrani Skype: roshandawrani

Re: Cassandra 0.8.4 - doesn't support defining keyspaces in cassandra.yaml?

2011-09-07 Thread Roshan Dawrani
application, and log4j configuration is initialized in a different way, and I do not want to feed embedded server a dummy log4j.properties file just to satisfy the chain above. Is there any way I can avoid it? -- Roshan Blog: http://roshandawrani.wordpress.com/ Twitter: @roshandawrani http

Any tentative data for 0.8.5 release?

2011-09-07 Thread Roshan Dawrani
Hi, Quick check: is there a tentative date for release of Cassandra 0.8.5? Thanks. -- Roshan Blog: http://roshandawrani.wordpress.com/ Twitter: @roshandawrani http://twitter.com/roshandawrani Skype: roshandawrani

Re: Any tentative data for 0.8.5 release?

2011-09-07 Thread Roshan Dawrani
to it. -- Roshan Blog: http://roshandawrani.wordpress.com/ Twitter: @roshandawrani http://twitter.com/roshandawrani Skype: roshandawrani

Cassandra 0.8.4 - doesn't support defining keyspaces in cassandra.yaml?

2011-09-06 Thread Roshan Dawrani
from cassandra.yaml. Is it not possible to do the same with Cassandra / Hector 0.8.x? Can someone throw some light please? Thanks. -- Roshan Blog: http://roshandawrani.wordpress.com/ Twitter: @roshandawrani http://twitter.com/roshandawrani Skype: roshandawrani

Re: Dropping a built in secondary index on a CF

2011-04-28 Thread Roshan Dawrani
-in secondary indexes, another Column Family is created behind the scenes, isn't it? Will that be automatically dropped when I update the column meta data to drop an index and keep others? -- Roshan Blog: http://roshandawrani.wordpress.com/ Twitter: @roshandawrani http://twitter.com/roshandawrani

Dropping a built in secondary index on a CF

2011-04-27 Thread Roshan Dawrani
Hi, Can someone please tell me how I can drop a built in secondary index on a column family attribute? I don't see any direct command to do that in the CLI help. -- Roshan Blog: http://roshandawrani.wordpress.com/ Twitter: @roshandawrani http://twitter.com/roshandawrani Skype: roshandawrani

How to change the seed node used to discover other nodes in the ring?

2011-04-21 Thread Roshan Dawrani
can I change it now? Through JMX? Some specific command? -- Roshan Blog: http://roshandawrani.wordpress.com/ Twitter: @roshandawrani http://twitter.com/roshandawrani Skype: roshandawrani

Re: How to change the seed node used to discover other nodes in the ring?

2011-04-21 Thread Roshan Dawrani
On Thu, Apr 21, 2011 at 9:10 PM, Nate McCall n...@datastax.com wrote: Roshan, See https://issues.apache.org/jira/browse/CASSANDRA-1777 for more details. Hi...I am not sure I fully understand the current state of auto-discovery of nodes. The impression I am getting looking at the issue

Re: How to change the seed node used to discover other nodes in the ring?

2011-04-21 Thread Roshan Dawrani
On Thu, Apr 21, 2011 at 9:30 PM, Nate McCall n...@datastax.com wrote: It will work as long as thrift and gossip are bound to the same interface. The discovery server in Hector also uses the CassandraHostConfigurator#getPort for the port in constructing the host URL. Can you please elaborate

Any way to get different unique time UUIDs for the same time value?

2011-03-30 Thread Roshan Dawrani
, but the problem is that I can get multiple values for the same timestamp. So, I am looking for some way where the time portion is same, but the other UUID half is different so that I can safely store 1 time UUID: 1 value. Any help there is appreciated. -- Roshan Blog: http://roshandawrani.wordpress.com

mutator.execute() timings - big variance noted - pointers needed on understanding/improving it

2011-03-10 Thread Roshan Dawrani
% 1075 99% 1215 100% 4442 -- Roshan Blog: http://roshandawrani.wordpress.com/ Twitter: @roshandawrani http://twitter.com/roshandawrani Skype: roshandawrani

Re: mutator.execute() timings - big variance noted - pointers needed on understanding/improving it

2011-03-10 Thread Roshan Dawrani
Hi All, Thanks for the inputs. I will start investigating this morning with the help of these. Regards, Roshan On Fri, Mar 11, 2011 at 2:49 AM, aaron morton aa...@thelastpickle.comwrote: http://wiki.apache.org/cassandra/FAQ#slows_down_after_lotso_inserts http://wiki.apache.org/cassandra/FAQ

Re: cant seem to figure out secondary index definition

2011-03-06 Thread Roshan Dawrani
-- Regards, Roshan On Sun, Mar 6, 2011 at 4:34 PM, Jürgen Link juergen.l...@googlemail.comwrote: Hi Roshan, could you please post a small sample from your yaml file

Re: cant seem to figure out secondary index definition

2011-03-06 Thread Roshan Dawrani
On Sun, Mar 6, 2011 at 4:54 PM, Roshan Dawrani roshandawr...@gmail.comwrote: -- keyspaces: - name: firstname validator_class: UTF8Type

Re: cant seem to figure out secondary index definition

2011-03-04 Thread Roshan Dawrani
On Fri, Mar 4, 2011 at 11:52 PM, Jürgen Link juergen.l...@googlemail.comwrote: Hi Jonathan, as Roland is already out of office, I'd like to jump in. Maybe this somehow got lost in the moddle of this thread, indexing works fine in our real cassandra cluster. For our test cases, we use an

Re: Is it possible to get list of row keys?

2011-02-23 Thread Roshan Dawrani
On Wed, Feb 23, 2011 at 7:17 PM, Ching-Cheng Chen cc...@evidentsoftware.com wrote: Actually, if you want to get ALL keys, I believe you can still use RangeSliceQuery with RP. Just use setKeys(,) as first batch call. Then use the last key from previous batch as startKey for next batch.

Re: Is it possible to get list of row keys?

2011-02-23 Thread Roshan Dawrani
Yes. But I don't think the retrieving keys in the right order was part of the original question. :-) On Wed, Feb 23, 2011 at 7:50 PM, Norman Maurer nor...@apache.org wrote: yes but be aware that the keys will not in the right order. Bye, Norman 2011/2/23 Roshan Dawrani roshandawr

Re: Is it possible to get list of row keys?

2011-02-23 Thread Roshan Dawrani
previously in this thread) -- Roshan Blog: http://roshandawrani.wordpress.com/ Twitter: @roshandawrani http://twitter.com/roshandawrani Skype: roshandawrani

Re: Is it possible to get list of row keys?

2011-02-22 Thread Roshan Dawrani
of slices. Thank you for your help. -- http://twitter.com/jpartogi -- Roshan Blog: http://roshandawrani.wordpress.com/ Twitter: @roshandawrani http://twitter.com/roshandawrani Skype: roshandawrani

Updating/inserting into multiple column families using one mutator batch

2011-02-17 Thread Roshan Dawrani
is that the smaller batches used to get executed perfectly, but with the combined one, the updates just hang ! I am not pin-pointing the issue anywhere at this time. I just want to know if it is normal to update multiple CFs in a batch and if there is deadlock situation that may arise if that is done. -- Roshan

Re: Updating/inserting into multiple column families using one mutator batch

2011-02-17 Thread Roshan Dawrani
could be other possibilities for it hanging? It's happening absolutely consistently. rgds, Roshan On Fri, Feb 18, 2011 at 1:50 AM, Nate McCall n...@datastax.com wrote: It is fine to use multiple coumn families via batch_mutate. The size of the batch itself will take some tunning. In what you

Re: indexedslicesQuery class error

2011-02-16 Thread Roshan Dawrani
, or dissemination) by persons other than the intended recipient(s) is prohibited. If you receive this e-mail in error, please notify the sender by phone or email immediately and delete it! -- Roshan Blog: http://roshandawrani.wordpress.com/ Twitter: @roshandawrani http://twitter.com

Re: indexedslicesQuery class error

2011-02-16 Thread Roshan Dawrani
: The method addGtEqualEpression(String,Long) in the type IndexedSlicesQueryString,String,Long is not applicable for the arguments(String,String) *From:* Roshan Dawrani [mailto:roshandawr...@gmail.com] *Sent:* Thursday, February 17, 2011 10:37 AM *To:* user@cassandra.apache.org *Subject:* Re

Re: indexedslicesQuery class error

2011-02-16 Thread Roshan Dawrani
:* Roshan Dawrani [mailto:roshandawr...@gmail.com] *Sent:* Thursday, February 17, 2011 10:48 AM *To:* user@cassandra.apache.org *Subject:* Re: indexedslicesQuery class error addGtEqual??? You are still making the same mistake. You are now saying that your values are going to be long

Re: Slow network writes

2011-02-03 Thread Roshan Dawrani
I think that was originally a voice command - for whoever happened to hear it first :-) On Fri, Feb 4, 2011 at 9:57 AM, buddhasystem potek...@bnl.gov wrote: Dude, are you asking me to unsubscribe? -- View this message in context:

Re: changing JMX port in 0.7

2011-02-02 Thread Roshan Dawrani
:-) On Wed, Feb 2, 2011 at 10:14 PM, Sasha Dolgy sdo...@gmail.com wrote: Silly me. On windows it has to be changed in $CASSANDRA_HOME/bin/cassandra.bat On Wed, Feb 2, 2011 at 5:39 PM, Sasha Dolgy sdo...@gmail.com wrote: An instance of Cassandra starts and is listening on the ports

Re: cassandra as session store

2011-02-01 Thread Roshan Dawrani
Please do keep this discussion on the mailing list and not take it offline. :-) I will be in the same boat very soon, I think. It will be great to hear from people who have already gone down this road and used Cassandra as a session store in a clustered environment. On Tue, Feb 1, 2011 at 10:56

Re: Cassandra events next week around Strata

2011-01-28 Thread Roshan Dawrani
HelloNo India-based Cassandra / NoSQL events? :-( :-) On Sat, Jan 29, 2011 at 8:31 AM, Jonathan Ellis jbel...@gmail.com wrote: Next week is the Strata conference and not one, not two, but five Cassandra events! In chronological order: 1. My Strata Cassandra tutorial Tuesday afternoon:

Re: Basic question on a write operation immediately followed by a read

2011-01-25 Thread Roshan Dawrani
2011/1/25 Wangpei (Peter) peter.wang...@huawei.com for your 1-node cluster, ANY is the only consistency level that client may returns BEFORE node write to memory table. And read op on the node read both the memory table and SSTable. It real puzzle me. :( Please don't be puzzled just

Re: get_range_slices getting deleted rows

2011-01-25 Thread Roshan Dawrani
No, checking the key will not do. You will need to check if row.getColumnSlice().getColumns() is empty or not. That's what I do and it works for me. On Wed, Jan 26, 2011 at 4:53 AM, Nick Santini nick.sant...@kaseya.comwrote: thanks, so I need to check the returned slice for the key to verify

Basic question on a write operation immediately followed by a read

2011-01-24 Thread Roshan Dawrani
to readers and flusing, etc is independent of all this and happens in background? Thanks. -- Roshan Blog: http://roshandawrani.wordpress.com/ Twitter: @roshandawrani http://twitter.com/roshandawrani Skype: roshandawrani

Re: Basic question on a write operation immediately followed by a read

2011-01-24 Thread Roshan Dawrani
app level issues, and wanted to rule out this one as a possibility. Cheers, Roshan On Tue, Jan 25, 2011 at 9:23 AM, Victor Kabdebon victor.kabde...@gmail.comwrote: Hello, Roshan basically what happens to your one node server is : Your insert operation is recorded in the commitlog

Re: Basic question on a write operation immediately followed by a read

2011-01-24 Thread Roshan Dawrani
On Tue, Jan 25, 2011 at 9:32 AM, Victor Kabdebon victor.kabde...@gmail.comwrote: Roshan, just remember, what you do on a one node cluster might not be valid on a 5 node cluster. Depending on the way your insert and query (QUORUM, ALL, ... ) your data might not be available to get, yet

Re: Basic question on a write operation immediately followed by a read

2011-01-24 Thread Roshan Dawrani
On Tue, Jan 25, 2011 at 9:57 AM, Victor Kabdebon victor.kabde...@gmail.comwrote: As far as I remember, please correct me if I am wrong, on a one node cluster : First Commitlog is updated then almost immediatly after order is send to the memtable to add this new insert. You might have a very

Re: Basic question on a write operation immediately followed by a read

2011-01-24 Thread Roshan Dawrani
2011/1/25 Wangpei (Peter) peter.wang...@huawei.com What is the ConsistencyLevel value? Is it ConsistencyLevel.ANY? I am using Hector 0.7.0-22 and getting keyspace as * HFactory.createKeyspace()*, which seems to be defaulting the consistency level to QUORAM for both reads and writes. Nowhere

Embedded Cassandra server startup question

2011-01-20 Thread Roshan Dawrani
-data from phase 1 server start that is affecting the server startup in 2nd phase? Any way I can cleanly start the server 2 times in my case? Any other suggestion? Thanks. -- Roshan Blog: http://roshandawrani.wordpress.com/ Twitter: @roshandawrani http://twitter.com/roshandawrani Skype

  1   2   >