Re: desuscribe

Did you mean "unsubscribe" ? One more time : http://wiki.apache.org/cassandra/FAQ#unsubscribe. Message to all : You can unsubscribe, that's up to you, but please stop flooding people that continue using this mailing list. Alain 2012/5/2 Daniel Gimenez > >

Re: Using CNAMEs for broadcast_address

You can use a host name in config, but it will be resolved to an IP at startup and IP address will be broadcast. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 2/05/2012, at 2:55 PM, Tom Duffield wrote: > Hey, > There is a push to use

SSTableWriter and Bulk Loading life cycle enhancement

Hi All, I'm bulk loading (a lot of) data from Hadoop into Cassandra 1.0.x. The provided CFOutputFormat is not the best case here, I wanted to use the bulk loading feature. I know 1.1 comes with a BulkOutputFormat but I wanted to propose a simple enhancement to SSTableSimpleUnsortedWriter that coul

count after truncate NOT zero

Hi guys, I got a weird thingy popping up twice today, I run a test where I insert a milion records via YCSB and edited it to allow me to adjust the consistency level: the write operations are done with ConsistencyLevel.ALL. This is send to a 4 (virtual) node cluster with a keyspace 'test' set up w

Bulk loading and timestamps

Hello, group Will the bulk loader preserve original column timestamps? Thank you very much, Oleg

Problem with Keyspace after drop

Hi, I'm doing testing and wanted to drop a keyspace (with a column family) to re-add it with a different strategy. So I ran in cqlsh: DROP KEYSPACE PlayLog; CREATE KEYSPACE PlayLog WITH strategy_class = 'SimpleStrategy' AND strategy_options:replication_factor = 2; And everything seemed to be

odd CQL behavior

I can't believe I have to ask this but I have a CF with about 10 rows and the keys are literally 1 through 9. Why does this not work if I want the row where the key is ascii('5')? cqlsh:Keyspace1> select first 1 * from CF where key = '5'; KEY - 05 * I saw the Jira about the sort of phant

Re: odd CQL behavior

On Thu, May 3, 2012 at 12:46 PM, Eric Czech wrote: > I can't believe I have to ask this but I have a CF with about 10 rows and > the keys are literally 1 through 9. > > Why does this not work if I want the row where the key is ascii('5')? > > cqlsh:Keyspace1> select first 1 * from CF where key

Re: odd CQL behavior

Gotcha, I probably should have guessed that much. Does CQL have any functions to convert ascii to hex so that I don't have to do that conversion elsewhere (I don't see one in the docs)? On Thu, May 3, 2012 at 2:09 PM, paul cannon wrote: > On Thu, May 3, 2012 at 12:46 PM, Eric Czech wrote: > >>

Re: Write performance compared to Postgresql

Just to follow this up, I repeated the test with a multi-threaded java (Hector) client and was able to get much better performance - 10,000 rows in just over a second. So it looks like the client latency was the killer and I have since read that the ruby thrift implementation is not the fastest.

Re: odd CQL behavior

Very sadly, no. It's not (yet?) meant to be a particularly good interactive language, so the only "function" in cql is COUNT(), and that's really just special syntax. It seems, though, that you might actually be better off with a key of type 'ascii' or 'text', if that's how you expect to work with

Re: Problem with Keyspace after drop

As a follow up, I am running version 1.1 and have tried nodetool repair, cleanup, compact. I can create other keyspaces, but still can't create a keyspace called PlayLog even though it is not listed anywhere. On May 3, 2012, at 6:35 PM, Jeff Williams wrote: > Hi, > > I'm doing testing and want

Re: odd CQL behavior

Alright, thanks again! I guess I'll stick to the CLI since I'd rather not make schema changes for the sake of querying (we have hundreds of column families and I don't want to make that change everywhere). On Thu, May 3, 2012 at 2:41 PM, paul cannon wrote: > Very sadly, no. It's not (yet?) mea

Re: Problem with Keyspace after drop

Would you mind opening a ticket on JIRA (https://issues.apache.org/jira/browse/CASSANDRA). This is definitively a bug and it's be easier to follow up there. Did you try restarting the node on which you try the create keyspace? -- Sylvain On Thu, May 3, 2012 at 8:43 PM, Jeff Williams wrote: > As

RE: Taking a Cluster Wide Snapshot

I finally tried the global snapshots stuff below is what I did. I have taken data from all individual nodes from a single DC after changing the numerical part(this numerical part can have only a max value of 2147483647). 1.My individual nodes were having 12Gb odd data so after combining it was