Re: How many BATCH inserts in to many?

2013-01-14 Thread Vitalii Tymchyshyn
Well, for me it was better to use async operations then batches. So, you are not bitten by latency, but can control everything per-operation. You will need to support a kind of window thought. But this windows can be quite low, like 10-20 ops. 2013/1/14 Wei Zhu wz1...@yahoo.com Another

Re: Cassandra 1.2 Thrift and CQL 3 issue

2013-01-14 Thread Sylvain Lebresne
On Sun, Jan 13, 2013 at 5:59 PM, Shahryar Sedghi shsed...@gmail.com wrote: Since new cql3 methods require ConsistencyLevel.xxx, is consistency level at the query has precedence over this level at the api or not. There is no consistency level at the query level anymore. That's one of the

Re: Astyanax

2013-01-14 Thread Everton Lima
Thanks to everyone, especially to Brian. I wiil continue my studies and if I have some problem I post here. I was looking, Astyanax use cassandra 1.1.1, is it possible to use 1.2.0? How? Thanks. 2013/1/8 Brian O'Neill b...@alumni.brown.edu Not sure where you are on the learning curve, but I've

Re: Cassandra 1.2 Thrift and CQL 3 issue

2013-01-14 Thread Sylvain Lebresne
On Mon, Jan 14, 2013 at 12:48 PM, Vivek Mishra mishra.v...@gmail.comwrote: I am getting an issue, where key attribute's in byte[] is returned as empty value. We don't return this anymore as this doesn't make much sense for CQL3. Same as in CqlMetadata we don't return a default_name_type and

Re: Cassandra 1.2 Thrift and CQL 3 issue

2013-01-14 Thread Vivek Mishra
Is it documented somewhere? How to fetch and populate row key from CqlRow api then? -Vivek On Mon, Jan 14, 2013 at 7:18 PM, Sylvain Lebresne sylv...@datastax.comwrote: On Mon, Jan 14, 2013 at 12:48 PM, Vivek Mishra mishra.v...@gmail.comwrote: I am getting an issue, where key attribute's in

Re: Cassandra 1.2 Thrift and CQL 3 issue

2013-01-14 Thread Sylvain Lebresne
How to fetch and populate row key from CqlRow api then? If you want the row key, just query it (we prefer the term partition key in CQL3 and that's the term you'll find in documents like http://cassandra.apache.org/doc/cql3/CQL.html but it's the same thing) and it'll be part of the return

Re: Cassandra 1.2 Thrift and CQL 3 issue

2013-01-14 Thread Vivek Mishra
If you want the row key, just query it (we prefer the term partition key in CQL3 and that's the term you'll find in documents like http://cassandra.apache.org/doc/cql3/CQL.html but it's the same thing) and it'll be part of the return columns. I understand that, as i am able to fetch partition key

Cassandra 1.2, wide row and secondary index question

2013-01-14 Thread Shahryar Sedghi
CQL 3 in Cassandra 1.2 does not allow order by when it is a wide row and a column with secondary index is used in a where clause which makes sense. So the question is: I have a test table like this: CREATE TABLE test( interval int, id uuid, severity int, PRIMARY KEY

Re: is there a way to list who is connected to my cluster?

2013-01-14 Thread Hiller, Dean
User ClusterIT tools specifically the clush program clush -g datanodes netstat -anp grep {port} And it will run it on all nodes so you can get the ips of who is connected. Dean On 1/11/13 8:42 PM, Rob Coli rc...@palominodb.com wrote: On Fri, Jan 11, 2013 at 10:32 AM, Brian Tarbox

Retrieving all columns from a result

2013-01-14 Thread Renato Marroquín Mogrovejo
Hi all, I am trying to get all columns from a certain number of records I am fetching. I am using the RangeSlicesQuery to achieve this, but it forces me to set how many columns I want to be retrieved. RangeSlicesQueryUUID, String, String rangeSlicesQuery = HFactory

Re: Retrieving all columns from a result

2013-01-14 Thread Vivek Mishra
RangeSlicesQueryUUID, String, String rangeSlicesQuery = HFactory .createRangeSlicesQuery( keyspace, uuidSerializer, stringSerializer, stringSerializer) .setColumnFamily(columnFamily1) .setRowCount(pCount) .setRange(, , true,

Re: Cassandra 1.2, wide row and secondary index question

2013-01-14 Thread Sylvain Lebresne
On Mon, Jan 14, 2013 at 5:04 PM, Shahryar Sedghi shsed...@gmail.com wrote: Can I always count on this order, or it may change in the future? I would personally rely on it. I don't see any reason why we would change that internally and besides I suspect you won't be the only one to rely on it

[VOTE] Release Apache Cassandra 1.1.9

2013-01-14 Thread Sylvain Lebresne
We've fixed our fair share of bugs since 1.1.8 so I propose the following artifacts for release as 1.1.9. sha1: 7eb47c50c394f0aefdfd4ac9170ce51e2e4be549 Git: http://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=shortlog;h=refs/tags/1.1.9-tentative Artifacts:

Re: Retrieving all columns from a result

2013-01-14 Thread Renato Marroquín Mogrovejo
Thanks Vivek that worked! But I can't use a ColumnSliceIterator with this type of query? Renato M. 2013/1/14 Vivek Mishra mishra.v...@gmail.com: RangeSlicesQueryUUID, String, String rangeSlicesQuery = HFactory .createRangeSlicesQuery( keyspace, uuidSerializer,

Re: [VOTE] Release Apache Cassandra 1.1.9

2013-01-14 Thread Eric Evans
On Mon, Jan 14, 2013 at 1:36 PM, Sylvain Lebresne sylv...@datastax.com wrote: We've fixed our fair share of bugs since 1.1.8 so I propose the following artifacts for release as 1.1.9. sha1: 7eb47c50c394f0aefdfd4ac9170ce51e2e4be549 Git:

Re: [VOTE] Release Apache Cassandra 1.1.9

2013-01-14 Thread Alain RODRIGUEZ
Shouldn't this vote be addressed to the Developers mailing list instead of the Users one ? Just in case it wasn't done on purpose and to be sure that you reach those concerned about this vote :). Alain 2013/1/14 Sylvain Lebresne sylv...@datastax.com We've fixed our fair share of bugs since

Re: change cluster name retaining keypsace

2013-01-14 Thread aaron morton
That looks technically correct for pre 1.2, in 1.2 the name of the column has changed to cluster_name. Note that you are diving into internals and that way be danger. Cheers - Aaron Morton Freelance Cassandra Developer New Zealand @aaronmorton http://www.thelastpickle.com

Re: Starting Cassandra

2013-01-14 Thread aaron morton
DSE includes hadoop files. It looks like the installation is broken. I would start again if possible and/or ask the peeps at Data Stax about your particular OS / JVM configuration. In the past I've used this to set a particular JVM when multiple ones are installed… update-alternatives --set

Re: Cassandra 1.2, wide row and secondary index question

2013-01-14 Thread Shahryar Sedghi
Aaron If you have order buy whit a column with a secondary index in a where clause it fails with: Bad Request: ORDER BY with 2ndary indexes is not supported. Best Regards Shahryar On Mon, Jan 14, 2013 at 5:55 PM, aaron morton aa...@thelastpickle.comwrote: Sylvain, Out of interest if the

Re: Pagination over row Keys in Cassandra using Kundera/CQL queries

2013-01-14 Thread aaron morton
Its the same idea. If you want to get 50 columns ask for 51, iterate over the first 50 and use the 51st as the first column for the next page. If you get 51 column then you are at the end of the page. I've not used Kundera so cannot talk about specifics. Cheers - Aaron

Re: Collecting of tombstones columns during read query fills up heap

2013-01-14 Thread aaron morton
Just so I understand, the file contents are *not* stored in the column value ? No, on that particular CF the columns are SuperColumns with 5 sub columns (size, is_dir, hash, name, revision). Each super column is small, I didn't mention super columns before because they don't seem to be

Re: [VOTE] Release Apache Cassandra 1.1.9

2013-01-14 Thread Sylvain Lebresne
On Mon, Jan 14, 2013 at 11:00 PM, Alain RODRIGUEZ arodr...@gmail.comwrote: Shouldn't this vote be addressed to the Developers mailing list instead of the Users one ? Yep, I screwed up. Fixed by the present email but feel free to now skip the user mailing list from replies. Sorry for the spam