Re: Read Consistency

2015-06-23 Thread Philip Thompson
Anuj, In the first scenario, the data from the single node holding data is returned. The query will not fail if the consistency level is met, even if the read was inconsistent. On Tue, Jun 23, 2015 at 2:16 PM, Anuj Wadehra anujw_2...@yahoo.co.in wrote: Why would it fail and with what Thrift

Re: Read Consistency

2015-06-23 Thread Philip Thompson
Yes, that is what he means. CL is for how many nodes need to respond, not agree. On Tue, Jun 23, 2015 at 2:26 PM, arun sirimalla arunsi...@gmail.com wrote: So do you mean with CL set to QUORUM, if data is only on one node, the query still succeeds. On Tue, Jun 23, 2015 at 11:21 AM, Philip

Re: Inserting null values

2015-04-29 Thread Philip Thompson
In a way, yes. A tombstone will only be removed after gc_grace iff the compaction is sure that it contains all rows which that tombstone might shadow. When two non-tombstone conflicting rows are compacted, it's always just LWW. On Wed, Apr 29, 2015 at 2:42 PM, Eric Stevens migh...@gmail.com

Re: Delete-only work loads crash Cassandra

2015-04-13 Thread Philip Thompson
Did the original patch make it into upstream? That's unclear. If so, what was the JIRA #? Have you filed a JIRA for the new problem? On Mon, Apr 13, 2015 at 12:21 PM, Robert Wille rwi...@fold3.com wrote: Back in 2.0.4 or 2.0.5 I ran into a problem with delete-only workloads. If I did lots of

Re: Writing the same column frequently - anti pattern?

2015-02-05 Thread Philip Thompson
You are correct. If an overwrite occurs while the original is still in the memtable, only the newest will be flushed to disk. On Thu, Feb 5, 2015 at 6:15 PM, Andreas Finke andreas.fi...@solvians.com wrote: Hi, we are currently writing the same column within a row multiple times (up to 10

Re: Timeouts but returned consistency level is invalid

2015-01-30 Thread Philip Thompson
Jan is incorrect. Keyspaces do not have consistency levels set on them. Consistency Levels are always set by the client. You are almost certainly running into https://issues.apache.org/jira/browse/CASSANDRA-7947 which is fixed in 2.1.3 and 2.0.12. On Fri, Jan 30, 2015 at 8:37 AM, Michał Łowicki

Re: get partition key from tombstone warnings?

2015-01-22 Thread Philip Thompson
likely to be *counter*productive. - Ian On Wed, Jan 21, 2015 at 5:02 PM, Philip Thompson philip.thomp...@datastax.com wrote: There is an open ticket for this improvement at https://issues.apache.org/jira/browse/CASSANDRA-8561 On Wed, Jan 21, 2015 at 4:55 PM, Ian Rose ianr

Re: get partition key from tombstone warnings?

2015-01-21 Thread Philip Thompson
There is an open ticket for this improvement at https://issues.apache.org/jira/browse/CASSANDRA-8561 On Wed, Jan 21, 2015 at 4:55 PM, Ian Rose ianr...@fullstory.com wrote: When I see a warning like Read 9 live and 5769 tombstoned cells in ... etc is there a way for me to see the partition key

Re: setting up prod cluster

2015-01-12 Thread Philip Thompson
I might be misinterpreting you, but it seems you are only using one seed per node. Is there a specific reason for that? A node can have multiple seeds in its seed list. It is my understanding that typically, every node in a cluster has the same seed list. On Sun, Jan 11, 2015 at 10:03 PM, Tim

Re: Stable cassandra build for production usage

2014-12-31 Thread Philip Thompson
2.0.11 is the current oldstable version, and is probably what you are looking for. On Wed, Dec 31, 2014 at 11:38 AM, Ajay ajay.ga...@gmail.com wrote: Hi All, For my research and learning I am using Cassandra 2.1.2. But I see couple of mail threads going on issues in 2.1.2. So what is the

Re: [Consitency on cqlsh command prompt]

2014-12-17 Thread Philip Thompson
I believe the problem here is that the consistency level it is showing you is not the number of nodes that need to respond, but the enum value that corresponds to QUORUM internally. If you would like, you can file an improvement request on the Apache Cassandra Jira. On Wed, Dec 17, 2014 at 12:47

Re: java.lang.AssertionError in cqlsh

2014-12-11 Thread Philip Thompson
There is a definitely a problem here, but without the entire stack trace, it is unclear what exactly may be wrong. On Thu, Dec 11, 2014 at 7:37 AM, Chamila Wijayarathna cdwijayarat...@gmail.com wrote: Hello all, I have a column family with following schema. CREATE TABLE

Re: java.lang.AssertionError in cqlsh

2014-12-11 Thread Philip Thompson
, Philip Thompson philip.thomp...@datastax.com wrote: There is a definitely a problem here, but without the entire stack trace, it is unclear what exactly may be wrong. On Thu, Dec 11, 2014 at 7:37 AM, Chamila Wijayarathna cdwijayarat...@gmail.com wrote: Hello all, I have a column family

Re: java.lang.AssertionError in cqlsh

2014-12-11 Thread Philip Thompson
] Thank you! On Thu, Dec 11, 2014 at 8:35 PM, Philip Thompson philip.thomp...@datastax.com wrote: The full error should be in that node's system.log file. What version are you running? On Thu, Dec 11, 2014 at 9:42 AM, Chamila Wijayarathna cdwijayarat...@gmail.com wrote: Hi Philip, I

Re: Get column family size

2014-12-11 Thread Philip Thompson
I assume the query you are sending is through cqlsh. You are actually getting a client-side timeout error, which is unclear in 2.1.2, but I believe the error message will be more helpful as of 2.1.3. On Thu, Dec 11, 2014 at 1:52 PM, Chamila Wijayarathna cdwijayarat...@gmail.com wrote: Hello

Re: Get column family size

2014-12-11 Thread Philip Thompson
in the user list can provide, as I have never needed to do that. On Thu, Dec 11, 2014 at 1:59 PM, Chamila Wijayarathna cdwijayarat...@gmail.com wrote: Hi Philip, Yes, I'm using cqlsh. Is there any way I can solve this? Thank You! On Fri, Dec 12, 2014 at 12:26 AM, Philip Thompson

Re: Performance Difference between Batch Insert and Bulk Load

2014-12-05 Thread Philip Thompson
What progress are you trying to be aware of? All of the features Tyler discussed are implemented and can be used. On Fri, Dec 5, 2014 at 2:41 PM, Dong Dai daidon...@gmail.com wrote: On Dec 5, 2014, at 11:23 AM, Tyler Hobbs ty...@datastax.com wrote: On Fri, Dec 5, 2014 at 1:15 AM, Dong Dai

Re: Performance Difference between Batch Insert and Bulk Load

2014-12-05 Thread Philip Thompson
thought Tyler is going to add some codes to split unlogged batch and make the batch insertion token aware. it is already done? or else i can do it too. thanks, - Dong On Dec 5, 2014, at 2:06 PM, Philip Thompson philip.thomp...@datastax.com wrote: What progress are you trying to be aware

Re: max ttl for column

2014-11-21 Thread Philip Thompson
With the newest versions of Cassandra, cql is not hanging, but returns the same Invalid Query Exception you are seeing through hector. I would assume from the exception that 63072 is in fact that largest TTL you can use. What are you doing that you need to set a TTL of approximately 30 years?

Re: replication_factor mismatch

2014-11-11 Thread Philip Thompson
This question probably belongs in the python driver's mailing list. However, if your RF is in fact 3, then that failed query is running at CL.ALL, not CL.QUORUM, which you can see because the required_responses is 3. The consistency: 5 is because consistency levels are an enum class, as seen

CCM 2.0 Announcement

2014-10-28 Thread Philip Thompson
immediately on PyPI. Future updates will also be published to PyPI, allowing easy installation via pip. In a future release of CCM, ownership of the project will be transferred to DataStax. CCM will remain open source and Apache licensed. Thank you, Philip Thompson

Re: How do you run integration tests for your cassandra code?

2014-10-13 Thread Philip Thompson
Kevin, Have you looked at the Cassandra integration tests used by the Cassandra development team: https://github.com/riptano/cassandra-dtest ? They make use of CCM for integration testing: https://github.com/pcmanus/ccm Philip Thompson On Mon, Oct 13, 2014 at 2:50 PM, Kevin Burton bur

Re: Authentication is failing.

2014-09-28 Thread Philip Thompson
You are running into https://issues.apache.org/jira/browse/CASSANDRA-7967 . This is fixed in 2.0.11 and 2.1.1, until then I believe you will need to explicitly grant select permission onto system.schema_triggers to the user as a workaround. On Sun, Sep 28, 2014 at 12:53 PM, Jens Rantil

Re: Concurrents deletes and updates

2014-09-17 Thread Philip Thompson
Could you be experiencing https://issues.apache.org/jira/browse/CASSANDRA-7801 ? On Wed, Sep 17, 2014 at 2:09 PM, Jonathan Haddad j...@jonhaddad.com wrote: Make sure your clocks are synced. If they aren't, the writetime that determines the most recent value will be incorrect. On Wed, Sep