Re: How to add secondary index to existing column family with CLI?

the ascii code for title and use that. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 21/08/2012, at 5:15 AM, Ryabin, Thomas thomas.rya...@mckesson.com wrote: I want to add a secondary index to an existing column family, but am running

Re: Heap size question

How do I know if my off-heap memory is not used? If you are using the default memory mapped file access memory not used by the cassandra JVM will be used to cache files. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 22/08/2012, at 5

Re: Why the StageManager thread pools have 60 seconds keepalive time?

that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 22/08/2012, at 6:38 AM, Guillermo Winkler gwink...@inconcertcc.com wrote: Aaron, thanks for your answer. We do have big batch updates not always with the columns belonging to the same

Re: OutOfMemory log in Cassandra

CASSANDRA_HEAPDUMP_DIR Is for JVM out of memory. You were seeing the OS kill the JVM because of low os memory. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 22/08/2012, at 4:28 PM, Xu Renjie xrjxrjxrj...@gmail.com wrote: Guille

Re: Facing problem while configuring key and row cache

- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 23/08/2012, at 2:18 AM, Amit Handa amithand...@gmail.com wrote: hi all, I am exploring apache cassandra 1.1.3. I am facing problem with how to improve performance of cassandra using caching configurations. I

Re: nodetool repair - when is it not needed ?

. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 23/08/2012, at 6:59 AM, Rob Coli rc...@palominodb.com wrote: On Wed, Aug 22, 2012 at 8:37 AM, Senthilvel Rangaswamy senthil...@gmail.com wrote: We are running Cassandra 1.1.2 on EC2. Our

Re: Deleting a row from a counter CF

I would guess that Pelops has called remove() on the Thrift API rather than remove_counter(). Check the code in Pelops. If you turn server side logging up to DEBUG it will log remove for the non counter call and remove_counter for the counter one. Cheers - Aaron Morton

Re: Cassandra 1.1.4 RPM required

See step 1 here http://wiki.apache.org/cassandra/GettingStarted Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 23/08/2012, at 7:40 PM, Adeel Akbar adeel.ak...@panasiangroup.com wrote: Hi, I would like to install Apache Cassandra 1.1.4

Re: nodetool repair - when is it not needed ?

is sending hints it waits the normal rpc_timeout. If there is a time out hint delivery for that endpoint is aborted. It will be re-tried the in the next HH round, which is every 10 minutes. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 23/08

Re: Commit log periodic sync?

a sync messages is added to the queue. Not that the commit log segment may rotate at any time which requires a sync. A loss of data across all nodes in a DC seems odd. If you can provide some more information we may be able to help. Cheers - Aaron Morton Freelance Developer

Re: Data Modelling Suggestions

, and build a time ordered custom index to show them in order. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 24/08/2012, at 6:28 AM, Guillermo Winkler gwink...@inconcertcc.com wrote: I think you need another CF as index. user_itemid

Re: Node forgets about most of its column families

If this is still a test environment can you try to reproduce the fault ? Or provide some more details on the sequence of events? If you still have the logs around can you see if any ERROR level messages were logged? Cheers - Aaron Morton Freelance Developer @aaronmorton http

Re: are asynchronous schema updates possible ?

Concurrent schema changes are coming in 1.2. I could not find a single issue that covered it, that may be my bad search fu. The issues for 1.2 are here https://issues.apache.org/jira/browse/CASSANDRA/fixforversion/12319262 Cheers - Aaron Morton Freelance Developer

Re: two-node cassandra cluster

? How long will it take to transfer ? What will the network latency be like between the nodes ? Latency between new nodes can be a lottery. If you are storing the data on a single node that uses RAID 0, how will you handle disk failure ? Hope that helps. - Aaron Morton Freelance

Re: Order of the cyclic group of hashed partitioners

AbstractHashedPartitioner does not exist in the trunk. https://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=commitdiff;h=a89ef1ffd4cd2ee39a2751f37044dba3015d72f1 Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 24/08/2012, at 10:51

Re: Cluster temporarily split into segments

3 with QUOURM / QUOURM. If it's important that reads continue and consistency can be relaxed I would look at RF 3 (or 6) and read ONE write QUOURM Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 24/08/2012, at 11:00 PM

Re: Data Modelling Suggestions

Timeseries modelling ... Sorry I do not understand this question. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 24/08/2012, at 11:17 PM, Roshni Rajagopal roshni.rajago...@wal-mart.com wrote: Thank you Aaron Guillermo, I find composite

Re: Secondary index partially created

If you are still having problems can you post the query and the output from nodetool cfstats on one of the nodes that fails ? cfstats will tell us if the secondary index was built. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 25/08

Re: Commit log periodic sync?

to reproduce the problem ? If possible can you reproduce it with a single node ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 25/08/2012, at 11:00 AM, rubbish me rubbish...@googlemail.com wrote: Thanks, Aaron, for your reply - please see

Re: optimizing use of sstableloader / SSTableSimpleUnsortedWriter

/src/java/org/apache/cassandra/io/sstable/SSTableSimpleWriter.java Right now my Cassandra data store has about 4 months of data and we have 5 years of historical ingest all the histories! Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com

Re: unsubscribe

http://wiki.apache.org/cassandra/FAQ#unsubscribe - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 26/08/2012, at 4:12 AM, Shen szs...@gmail.com wrote:

Re: Expanding cluster to include a new DR datacenter

I did a quick test on a clean 1.1.4 and it worked Can you check the logs for errors ? Can you see your schema change in there ? Also what is the output from show schema; in the cli ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 25/08

Re: QUORUM writes, QUORUM reads -- and eventual consistency

is isolated and all the other nodes are UP and happy. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 26/08/2012, at 5:03 AM, Guillermo Winkler gwink...@inconcertcc.com wrote: Isn't it cheaper to retry the mutation on _any exception_

Re: Dynamic Column Families in CQLSH v3

/msg23636.html Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 24/08/2012, at 2:24 PM, Erik Onnen eon...@gmail.com wrote: Hello All, Attempting to create what the Datastax 1.1 documentation calls a Dynamic Column Family (http

Re: Order of the cyclic group of hashed partitioners

Sorry I don't understand your question. Can you explain it a bit more or maybe someone else knows. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 27/08/2012, at 7:16 PM, Romain HARDOUIN romain.hardo...@urssaf.fr wrote: Thank you

Re: Cassandra 1.1.4 RPM required

- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 27/08/2012, at 8:14 PM, Marco Schirrmeister ma...@schirrmeister.net wrote: On Aug 23, 2012, at 12:15 PM, Adeel Akbar wrote: Dear Aaron, Its required username and password which I have not. Can yo share

Re: can you use hostnames in the topology file?

. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 28/08/2012, at 5:00 AM, Hiller, Dean dean.hil...@nrel.gov wrote: In the example, I see all ips being used, but our machines are on dhcp so I would prefer using hostnames for everything(plus

Re: optimizing use of sstableloader / SSTableSimpleUnsortedWriter

dataset... just under 4 months of data is less then 2GB! I'm pretty thrilled. Be thrilled by all the compressions ! :) Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 28/08/2012, at 6:10 AM, Aaron Turner synfina...@gmail.com wrote

Re: sstableloader error

: INFO 21:40:30,335 Node /192.168.11.11 is now part of the cluster This is the bulk load process joining the ring to send the file around. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 28/08/2012, at 10:56 AM, Swathi Vikas swat.vi

Re: Commit log periodic sync?

then multiple DC's until it fails. If the single node test fails check your test and then grab someone on IRC (I'm aaron_morton and there are plenty of other smart helpful people there). Sorry it's sometimes hard to diagnose problems over email. Cheers - Aaron Morton Freelance

Re: Expanding cluster to include a new DR datacenter

what the error is it's hard to say if it would work. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 29/08/2012, at 9:10 AM, Bryce Godfrey bryce.godf...@azaleos.com wrote: I believe what may be really going on is that my schema

Re: Automating nodetool repair

Staggering the repairs also gives the DynamicSnitch a chance to route around nodes which maybe running slow. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 29/08/2012, at 11:19 AM, Omid Aladini omidalad...@gmail.com wrote: Secondly

Re: Row level statistics

But does cassandra provide statistics at the granularity of rows. No. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 29/08/2012, at 12:05 PM, Shankaranarayanan P N shankarp...@gmail.com wrote: Hello, I have seen that cassandra gives

Re: Node forgets about most of its column families

please create a ticket on https://issues.apache.org/jira/browse/CASSANDRA Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 29/08/2012, at 8:38 AM, Edward Sargisson edward.sargis...@globalrelay.net wrote: For the record, we just had

Re: Node forgets about most of its column families

Thanks Peter. This is 1.1.X ? Any thoughts on how recent the last schema change was ? Had the schema started in a pre 1.1X cluster? If so had their been a migration change after 1.1 upgrade? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com

Re: keyspace and column family creationŠhow to use ConsistencyLevel.ALL with creation?

describe_schema_versions on the thrift API (SystemManager.describe_schema_versions() on pycassa) is what you are after. Call it before hand to know what's what, and then call until all nodes converge on the new schema. Cheers - Aaron Morton Freelance Developer @aaronmorton

Re: Why Cassandra secondary indexes are so slow on just 350k rows?

*from 12 to 20 seconds (!!!) to find 5000 rows*. More is not always better. Cassandra must materialise the full 5000 rows and send them all over the wire to be materialised on the other side. Try asking for a few hundred at a time and see how it goes. Cheers - Aaron

Re: performance is drastically degraded after 0.7.8 -- 1.0.11 upgrade

information on your use case we may be able to help. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 30/08/2012, at 5:18 AM, Илья Шипицин chipits...@gmail.com wrote: in terms of our high-rate write load cassandra1.0.11 is about 3 (three

Re: Node forgets about most of its column families

For those playing along at home Edwards ticket was marked as a dup of Problem with creating keyspace after drop https://issues.apache.org/jira/browse/CASSANDRA-4219 Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 30/08/2012, at 4:43 AM

Re: Store a timeline with uniques properties

to 6789, NULL, NULL Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 30/08/2012, at 11:32 PM, Morgan Segalis msega...@gmail.com wrote: Sorry for the scheme that has not keep the right tabulation for some people... Here's a space-version instead

Re: performance is drastically degraded after 0.7.8 -- 1.0.11 upgrade

in the log ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 31/08/2012, at 3:30 AM, Edward Capriolo edlinuxg...@gmail.com wrote: If you move from 7.X to 0.8X or 1.0X you have to rebuild sstables as soon as possible. If you have large

Re: How to set LeveledCompactionStrategy for an existing table

Looks like a bug. Can you please create a ticket on https://issues.apache.org/jira/browse/CASSANDRA and update the email thread ? Can you include this: CFPropDefs.applyToCFMetadata() does not set the compaction class on CFM Thanks - Aaron Morton Freelance Developer

Re: performance is drastically degraded after 0.7.8 -- 1.0.11 upgrade

that are taking longer ? There are full request metrics available on the StorageProxy JMX object. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 31/08/2012, at 4:45 PM, Илья Шипицин chipits...@gmail.com wrote: we are using functional tests

Re: Composite row keys with SSTableSimpleUnsortedWriter for Cassandra 1.0?

I think you want the o.a.c.db.marshal.TypeParser. You can pass a CLI format composite type to the parse() func. It's in 1.0X Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 1/09/2012, at 6:44 AM, Jeff Schmidt j...@535consulting.com

Re: force gc?

tiers. Expanding from 5GB to 70Gb is out of the normal expections I would say. You may want to check it the db contains what you expect it to. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 3/09/2012, at 5:32 PM, Alexander Shutyaev shuty

Re: Order of the cyclic group of hashed partitioners

I believe the question is why is the maximum 2**127 and not 0x The maximum is the size of the digest created by MD5. Does that answer the question? - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 3/09/2012, at 8:20 PM, Tim

Re: Text searches and free form queries

. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 4/09/2012, at 3:00 AM, Andrey V. Panov panov.a...@gmail.com wrote: Some one did search on Lucene, but for very fresh data they build search index in memory so data become available for search without delays

Re: configure KeyCahce to use Non-Heap memory ?

keys it contains Vs the number of rows on the box and the hit rate. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 4/09/2012, at 3:01 PM, Ananth Gundabattula agundabatt...@threatmetrix.com wrote: Is there any way I can configure KeyCahce

Re: java.lang.NoClassDefFoundError when trying to do anything on one CF on one node

of the NodeIdInfo and LocationInfo CF's from system ? I *think* a work around may be to: * stop the node * remove LocationInfo and NodeInfo cfs. * restart Note this will read the token from the yaml file again, so make sure it's right. cheers - Aaron Morton Freelance

Re: performance is drastically degraded after 0.7.8 -- 1.0.11 upgrade

stats can help with that as they provide a spread of latencies. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 5/09/2012, at 12:27 AM, Илья Шипицин chipits...@gmail.com wrote: it was good idea to have a look at StorageProxy

Re: anyone know how to lookup non-continguous columns BUT for prefixes?

- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 5/09/2012, at 4:56 AM, Hiller, Dean dean.hil...@nrel.gov wrote: I have a row that is an index like so Index row - value1.pk99, value1.pk20, value2.pk32, value2.pk7 , value3.pk24, value4.pk54, value5.pk31 I would

Re: keyspace not propagated to a new node?

What version are you on ? Anything in the logs from MigrationManager ? You could try nodetool resetlocalschema . Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 5/09/2012, at 7:02 AM, Yang tedd...@gmail.com wrote: I let a new node

Re: why do I have to use internal IP for EC2 nodes?

- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 5/09/2012, at 7:37 AM, Yang tedd...@gmail.com wrote: http://www.datastax.com/docs/1.1/initialize/cluster_init says: Note In the - seeds list property, include the internal IP addresses

Re: performance is drastically degraded after 0.7.8 -- 1.0.11 upgrade

or a known edge case. Whatever the cause we would need more details to help you. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 5/09/2012, at 4:19 PM, Илья Шипицин chipits...@gmail.com wrote: all tests use similar data access patterns, so

Re: java.lang.NoClassDefFoundError when trying to do anything on one CF on one node

it. I created https://issues.apache.org/jira/browse/CASSANDRA-4626 can you please add more information there if you can and/or watch the ticket incase there are other questions. Thanks - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 5/09/2012, at 10

Re: configure KeyCahce to use Non-Heap memory ?

The hit rate is pretty low 0.451 recent hit rate, A bigger cache would not help too much. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 5/09/2012, at 11:31 PM, Ananth Gundabattula agundabatt...@threatmetrix.com wrote: Hello Aaron

Re: Secondary index read/write explanation

token range if you have a key restriction in the query. If there is any article/blog that can help understand this better, please let me know. I think this is still mostly relevant http://www.datastax.com/docs/0.7/data_model/secondary_indexes Cheers - Aaron Morton Freelance

Re: Monitoring replication lag/latency in multi DC setup

/org/apache/cassandra/db/HintedHandOffManagerMBean.java Note that counting the number of hits involves counting the number of hits, so that can take a while. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 6/09/2012, at 5:33 PM, Venkat

Re: Helenos - web based gui tool

Thanks Tomek, Feel free to add it to http://wiki.apache.org/cassandra/Administration%20Tools Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 5/09/2012, at 9:54 AM, Tomek Kuprowski tomekkuprow...@gmail.com wrote: Dear all

Re: Practical node size limits

. (It wont help reduce the time taken to calculate merkle trees though). Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 7/09/2012, at 7:28 AM, Dustin Wenz dustinw...@ebureau.com wrote: This is actually another problem that we've encountered

Re: Issue after upgraded Cassandra 1.1.4

This is a server side timeout. Consistent Level nodes did not respond to the coordinator within rpc_timeout. The nodes may have been overloaded, check the nodetool tpstats. It will tell you if the node is backing up and if it has dropped messages. Cheers - Aaron Morton

Re: Replication factor 2, consistency and failover

availability rather than say in general we want to achieve strong consistency. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 9/09/2012, at 9:09 PM, Sergey Tryuber stryu...@gmail.com wrote: Hi We have to use Cassandra

Re: Number of columns per row for Composite Primary Key CQL 3.0

would suggest 1MM cols is fine, if you get to 10MM cols per row you probably have gone too far. Remember the byte size of the row is also important; larger rows churn memory more and take longer to compact / repair. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton

Re: Suggestions for tuning and monitoring.

commit log sizes, …. I would try to find some indication of what's going on before tweaking. Have you checked iostat ? Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 11/09/2012, at 2:05 AM, Henrik Schröder skro...@gmail.com wrote

Re: any way to prefer just 3 column families for partial row caching

- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 11/09/2012, at 3:54 AM, Hiller, Dean dean.hil...@nrel.gov wrote: We have 3 tables for all indexing we do called IntegerIndexing DecimalIndexing StringIndexing playOrm would prefer that only these rows are cached

Re: Assertions running Cleanup on a 3-node cluster with Cassandra 1.1.4 and LCS

or just one ? * If you can identify the CF can you include the .json file that is kept on disk. It contains information about levelled compaction. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 11/09/2012, at 4:37 AM, Rudolf van der Leeden

Re: replace_token code?

appeared in the logs ? If it does can you include the output from nodetool gossipinfo ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 11/09/2012, at 5:59 AM, Yang tedd...@gmail.com wrote: Thanks Jim, looks I'll have to read

Re: Number of columns per row for Composite Primary Key CQL 3.0

What is MM stands for? million ? Yup. No idea why I do that. cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 12/09/2012, at 11:25 AM, Data Craftsman 木匠 database.crafts...@gmail.com wrote: Hi Aaron, Thanks for the suggestion

Re: how to enter float value from cassandra-cli ?

It's not supported, yet. Can you create a ticket on https://issues.apache.org/jira/browse/CASSANDRA ? You could try cqlsh http://www.datastax.com/docs/1.1/dml/using_cql Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 12/09/2012, at 11:29

Re: nodetool connection refused

Thanks for updating the Wiki :) Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 12/09/2012, at 1:14 PM, Manu Zhang owenzhang1...@gmail.com wrote: problems solved. I didn't add the jmx_host and jmx_port to vm_arguments in Eclipse. How

Re: Astyanax InstantiationException when accessing ColumnList

- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 12/09/2012, at 2:04 PM, Ran User ranuse...@gmail.com wrote: Oops, forgot to mention Cassandra version - 1.1.4 On Tue, Sep 11, 2012 at 5:54 AM, Ran User ranuse...@gmail.com wrote: Stuck for hours

Re: hadoop inserts blow out heap

if mutations are pending, and will say how many have been dropped. The log may also contain entries about pending and dropped messages. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 12/09/2012, at 11:52 PM, Brian Jeltema brian.jelt

Re: thoughts on this feature request

- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 12/09/2012, at 11:59 PM, Hiller, Dean dean.hil...@nrel.gov wrote: Using wide rows for indexing is extremely common. I was wondering if we could get some type of command like so for index rows Remove value1.pkX

Re: Composite Column Types Storage

that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 13/09/2012, at 2:30 AM, Ravikumar Govindarajan ravikumar.govindara...@gmail.com wrote: Thanks for the clarification. Even though compression solves disk space issue, we might still have

Re: nodetool connection refused

Yes. If your IDE is starting cassandra the settings from cassandra-env.sh will not be used. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 13/09/2012, at 12:41 PM, Manu Zhang owenzhang1...@gmail.com wrote: I'm afraid we have to include

Re: Schema consistently not propagating to a node.

Out of interest, how out of sync where they ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 14/09/2012, at 6:53 AM, Ben Frank b...@airlust.com wrote: Hi Sergey, That was exactly it, thank you! -Ben On Thu, Sep 13, 2012 at 12

Re: secondery indexes TTL - strange issues

with SiezedTieredCompaction ? Are you able to replicate the problem with a fresh testing CF and some test Data? If it's only a problem with imported data can you provide a sample of the failing query ? Any maybe the CF definition ? Cheers - Aaron Morton Freelance Developer @aaronmorton

Re: Composite Column Query Modeling

/blog/cql3_collections Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 14/09/2012, at 8:31 AM, Adam Holmberg adam.holmberg.l...@gmail.com wrote: I'm modeling a new application and considering the use of SuperColumn vs. Composite

Re: Data Model

is the student ID. * Column value may be blank or some useful value. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 14/09/2012, at 3:19 PM, Michael Morris michael.m.mor...@gmail.com wrote: I'm fairly new to Cassandra myself

Re: Changing bloom filter false positive ratio

I have a hunch that the SSTable selection based on the Min and Max keys in ColumnFamilyStore.markReferenced() means that a higher false positive has less of an impact. it's just a hunch, i've not tested it. Cheers - Aaron Morton Freelance Developer @aaronmorton http

Re: hadoop inserts blow out heap

Hi Brian did you see my follow up questions here http://www.mail-archive.com/user@cassandra.apache.org/msg24840.html Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 12/09/2012, at 11:52 PM, Brian Jeltema brian.jelt...@digitalenvoy.net

Re: Reading column names only

It's not possible to read just the column names. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 14/09/2012, at 9:05 PM, Robin Verlangen ro...@us2.nl wrote: Hi there, Would it be possible to read only the column names, instead

Re: Reading column names only

. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 14/09/2012, at 9:32 PM, Robin Verlangen ro...@us2.nl wrote: Hi Aaron, Is this something that's worth becoming a feature in the future? Or should I rework my data model? If so, do you have any suggestions? Best

Re: Query advice to prevent node overload

. Otherwise a lot of data get's dragged through cassandra, the network and finally Python. You may want to consider a CF like the inode CF it the article above. Where the parent dir is a column with a secondary index. Cheers - Aaron Morton Freelance Developer @aaronmorton http

Re: Is it possible to create a schema before a Cassandra node starts up ?

I have a script that needs to set up a schema first before starting up the cassandra node. Is this possible ? No. A node must be running to make a DDL change. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 15/09/2012, at 2:05 AM, Xu

Re: cassandra does not close the stdout console on startup

Starting with -f backgrounds the process. By default logging is configured to write to stdout, maybe update log4j-server.properties. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 15/09/2012, at 2:49 AM, Xu, Zaili z

Re: Composite Column Query Modeling

for the s value. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 15/09/2012, at 3:08 AM, Adam Holmberg adam.holmberg.l...@gmail.com wrote: I think what you're describing might give me what I'm after, but I don't see how I can pass different

Re: nodetool cfstats and compression

Yes. It is the space taken up on disk, including compaction. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 15/09/2012, at 6:30 AM, Jim Ancona j...@anconafamily.com wrote: Do the row size stats reported by 'nodetool cfstats' include

Re: minor compaction and delete expired column-tombstones

- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 15/09/2012, at 6:32 AM, Rene Kochen rene.koc...@schange.com wrote: Hi all, Does minor compaction delete expired column-tombstones when the row is also present in another table which is not subject to the minor

Re: Disk configuration in new cluster node

. These are simply soft limits that provide a good rule of thumb for HDD based systems with 1 GigE networking. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 15/09/2012, at 7:39 AM, Casey Deccio ca...@deccio.net wrote: I'm building

Re: Query advice to prevent node overload

Could you explain the usage of the sentinel? Queries that use a secondary index must include an equality clause. That's the sentinel is there for… select filename from inode where filename ‘/tmp’ and filename ‘/tmq’ and sentinel = ‘x’; Cheers - Aaron Morton Freelance

Re: Cassandra Messages Dropped

- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 18/09/2012, at 2:16 AM, Michael Theroux mthero...@yahoo.com wrote: Hello, While under load, we have occasionally been seeing messages dropped errors in our cassandra log. Doing some research, I

Re: Composite Column Types Storage

. No. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 18/09/2012, at 2:44 AM, Ravikumar Govindarajan ravikumar.govindara...@gmail.com wrote: Yes Aaron, I was not clear about Bloom Filters. I was thinking about the column bloom filters

Re: Disk configuration in new cluster node

. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 18/09/2012, at 3:53 AM, Casey Deccio ca...@deccio.net wrote: On Mon, Sep 17, 2012 at 1:19 AM, aaron morton aa...@thelastpickle.com wrote: 4 drives for data and 1 drive for commitlog, How are you

Re: Cassandra supercolumns with same name

They are. Can you provide some more information ? What happens when you read the super column ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 18/09/2012, at 5:33 AM, Cyril Auburtin cyril.aubur...@gmail.com wrote: First sorry but I'm

Re: Cassandra Messages Dropped

- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 18/09/2012, at 3:46 PM, Michael Theroux mthero...@yahoo.com wrote: Thanks for the response. We are on version 1.1.2. We don't see the MutationStage back up. The dump from the messages dropped

Re: persistent compaction issue (1.1.4 and 1.1.5)

What Compaction Strategy are you using ? Are there any errors in the logs ? If you restart a node how long does it take for the numbers to start to rise ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 18/09/2012, at 7:39 AM, Michael

Re: Is Cassandra right for me?

of infrastructure. Hope that helps. - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 18/09/2012, at 10:28 AM, Marcelo Elias Del Valle mvall...@gmail.com wrote: Hello, I am new to Cassandra and I am in doubt if Cassandra is the right technology

Re: Bloom Filters in Cassandra

Some more background http://spyced.blogspot.com/2009/01/all-you-ever-wanted-to-know-about.html In additional to the SSTable bloom filter for keys, there are row level bloom filters for columns. Cheers - Aaron Morton Freelance Developer @aaronmorton http

Re: Stream definition is lost after server restart

What is the query you are using to read the streams ? Can you reduce the fault to this query is not returning data but it's there ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 18/09/2012, at 4:11 PM, Ishan Thilina is...@ishans.info

  1   2   3   4   5   6   7   8   9   10   >