when 0.8.1 will be released?

Hi, Is there a time planed for 0.8.1 release? I want to use the CompositeType comparer : https://issues.apache.org/jira/browse/CASSANDRA-2231 Thanks! Donal

get_indexed_slices count api

Hi, I'm query on cassandra like select count(*) from table where column1 = v1 and ..., based on a secondary index on column1. But using get_indexed_slices(), I have to fetch all the rows and count on them, which is not needed. So a get_indexed_slices count api [1] would be very helpful, but it

slow insertion rate with secondary index

I did a insertion test with and without secondary indexes, and found that: Without secondary index: ~10864 rows inserted per second With secondary index on one column(BytesType): ~1515 rows inserted per second Is this normal? why secondary index would have so much affect? I noticed that If I

Re: [SPAM] Re: slow insertion rate with secondary index

out from time to time (with pycassa.ConnectionPool('keyspace1', ['host1','host2'], timeout=600, pool_size=1) ). Does some one else have some same experiences using the secondary indexes? -- Donal Zang Computing Center, IHEP 19B YuquanLu, Shijingshan District,Beijing, 100049 zan...@ihep.ac.cn

Re: insert slowdown with secondary indexes

the secondary index. (this method may need the CompositeType [3]) [1] https://issues.apache.org/jira/browse/CASSANDRA-1472 [2] http://www.anuff.com/2010/07/secondary-indexes-in-cassandra.html [3] https://issues.apache.org/jira/browse/CASSANDRA-2231 -- Donal Zang Computing Center, IHEP 19B YuquanLu

Re: Querying superColumn

{* *Name: Vivs* *country: USA* *}* Now if I want to retrieve a super column whose rowkey is 'DEPT1' and employee name is 'Vivek'. Can I get only 'EMPLOYEE1' ? -- Donal Zang Computing Center, IHEP 19B YuquanLu, Shijingshan District,Beijing, 100049 zan...@ihep.ac.cn 86 010 8823 6018

Re: Counter Column

. -- Donal Zang Computing Center, IHEP 19B YuquanLu, Shijingshan District,Beijing, 100049 zan...@ihep.ac.cn 86 010 8823 6018

Re: Counter Column

is replicate_on_write=false, you have to declare it explicitly. -- Donal Zang Computing Center, IHEP 19B YuquanLu, Shijingshan District,Beijing, 100049 zan...@ihep.ac.cn 86 010 8823 6018

Re: CompositeType for row Keys

specific use case, what would work best is to have a composite key that is a CompositeType with thousands of columns each. -- Donal Zang Computing Center, IHEP 19B YuquanLu, Shijingshan District,Beijing, 100049 zan...@ihep.ac.cn 86 010 8823 6018

Re: CompositeType for row Keys

)? In my specific use case, what would work best is to have a composite key that is a CompositeType with thousands of columns each. -- Donal Zang Computing Center, IHEP 19B YuquanLu, Shijingshan District,Beijing, 100049 zan...@ihep.ac.cn 86 010 8823 6018 -- Donal Zang Computing Center, IHEP 19B

Re: [SPAM] Fwd: Counter consistency - are counters idempotent?

of counters. If counters are not idempotent, are there examples of effective uses of counters that will prevent inconsistent counts? Thank you for your help. -- Donal Zang Computing Center, IHEP 19B YuquanLu, Shijingshan District,Beijing, 100049 zan...@ihep.ac.cn 86 010 8823 6018

how to see how many rows in each node?

RT. Is there any command or api? Thanks!

Can super column family use column_metadata?

Hi, I'm using 0.7.0-rc1,and when I use cassandra-cli to create a column family with metadata, I got null,and no column family is created. The command I use is: /create keyspace test; use test; create column family test1 with column_type = 'Super' and comparator = 'LongType' and

Re: Between Clause

On 17/01/2011 11:55, kh jo wrote: What is the best way to model a query with between clause.. given that you have a large number of entries... thanks Jo In my experience,for the row based 'between clause' with a random partition, you should design the column family carefully, So that you

should nodetool repair run periodic to keep consistency?

Just to ensure. So this should be done manually by the cluster operators? Thanks! --

Re: Cassandra automatic startup script on ubuntu

On 20/01/2011 17:51, Sébastien Druon wrote: Hello! I am using cassandra on a ubuntu machine and installed it from the binary found on the cassandra home page. However, I did not find any scripts to start it up at boot time. Where can I find this kind of script? Thanks a lot in advance

apache.org down?

rt -- Donal Zang

NullPointerException with 0.7.4

(MessageDeliveryTask.java:72) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) at java.lang.Thread.run(Thread.java:636) -- Donal Zang CERN PH-ADP-DDM 40-3-D16 CH-1211 Geneve 23

statistcs query on cassandra

Can we do count like this? /count cf[startKey:endKey] where column = value/ -- Donal Zang Computing Center, IHEP 19B YuquanLu, Shijingshan District,Beijing, 100049 zan...@ihep.ac.cn 86 010 8823 6018