Re: Difference in retrieving data from cassandra

2014-09-26 Thread Umang Shah
Hey Jonathan, Thanks for your reply. i created schema structure in this manner CREATE SCHEMA schemaname WITH replication = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 }; and table according to requirement. I didn't used node structure. So will it be the reason for performance? And c

Re: Difference in retrieving data from cassandra

2014-09-25 Thread Jonathan Haddad
You'll need to provide a bit of information. To start, a query trace from would be helpful. http://www.datastax.com/documentation/cql/3.0/cql/cql_reference/tracing_r.html (self promo) You may want to read over my blog post regarding diagnosing problems in production. I've covered diagnosing slo

Difference in retrieving data from cassandra

2014-09-25 Thread Umang Shah
Hi All, I am using cassandra with Pentaho PDI kettle, i have installed cassandra in Amazon EC2 instance and in local-machine, so when i am trying to retrieve data from local machine using Pentaho PDI it is taking few seconds (not more then 20 seconds) and if i do the same using production data-bas