Unsubscribe
This email, along with any attachments, is confidential and may be legally
privileged or otherwise protected from disclosure. Any unauthorized
dissemination, copying or use of the contents of this email is strictly
prohibited and may be in violation of law. If you are not the
Unsubscribe
This email, along with any attachments, is confidential and may be legally
privileged or otherwise protected from disclosure. Any unauthorized
dissemination, copying or use of the contents of this email is strictly
prohibited and may be in violation
Leonid Ilyevsky
Moon Capital Management, LP
499 Park Avenue
New York, NY 10022
P: (212) 652-4586
F: (212) 652-4501
E: lilyev...@mooncapital.com
[cid:image001.png@01CDF3EE.E9EA60F0]
This email, along with any attachments, is confidential and may be legally
My cassandra used to work fine, now it does not create a table. No error
message, but the table is not there. I execute create table statement many
times, the same thing. When I do it, I see in the system.log the the lines
below.
What can be the problem?
Pre-history: before I noticed it is
/ for cassandra datamodel.
Also, the flushing events are expected.
For example
run create keyspace name1
, use name1
, create column family name2
This should work with default settings..
On Tue, Jul 31, 2012 at 11:34 PM, Leonid Ilyevsky
lilyev...@mooncapital.com wrote:
My cassandra used to work
Now I got tired of this, so I cleaned up everything and started from the empty
keyspace. Everything is ok so far.
How can I prevent this from happening in the future?
-Original Message-
From: Leonid Ilyevsky [mailto:lilyev...@mooncapital.com]
Sent: Tuesday, July 31, 2012 3:11 PM
I have a question about efficiency of updates to a CF with composite key.
Let say I have 100 of logical rows to update, and they all belong to the same
physical wide row. In my naïve understanding (correct me if I am wrong), in
order to update a logical row, Cassandra has to retrieve the whole
I am loading a large set of data into a CF with composite key. The load is
going pretty slow, hundreds or even thousands times slower than it would do in
RDBMS.
I have a choice of how granular my physical key (the first component of the
primary key) is, this way I can balance between smaller
, just to see if it works at all.
From: Derek Williams [mailto:de...@fyrie.net]
Sent: Tuesday, July 10, 2012 7:19 PM
To: user@cassandra.apache.org
Subject: Re: help using org.apache.cassandra.cql3
On Tue, Jul 10, 2012 at 3:04 PM, Leonid Ilyevsky
lilyev...@mooncapital.commailto:lilyev
...;
...
APPLY BATCH;
If you want to that from java, you will want to look at the jdbc
driver (http://code.google.com/a/apache-extras.org/p/cassandra-jdbc/),
though I don't know what is the status of the support for CQL3.
On Wed, Jul 11, 2012 at 2:18 PM, Leonid Ilyevsky
lilyev...@mooncapital.com wrote
waiting for your confirmation, I am going to try it.
-Original Message-
From: Sylvain Lebresne [mailto:sylv...@datastax.com]
Sent: Tuesday, July 10, 2012 8:24 AM
To: user@cassandra.apache.org
Subject: Re: Dynamic CF
On Fri, Jul 6, 2012 at 10:49 PM, Leonid Ilyevsky
lilyev...@mooncapital.com
-
From: Sylvain Lebresne [mailto:sylv...@datastax.com]
Sent: Tuesday, July 10, 2012 10:37 AM
To: user@cassandra.apache.org
Subject: Re: Dynamic CF
On Tue, Jul 10, 2012 at 4:17 PM, Leonid Ilyevsky
lilyev...@mooncapital.com wrote:
So I guess, in the batch_mutate call, in the map that I pass
I see now there is a package org.apache.cassandra.cql3.statements, with
BatchStatement class. Is this what I should use?
-Original Message-
From: Leonid Ilyevsky [mailto:lilyev...@mooncapital.com]
Sent: Tuesday, July 10, 2012 11:45 AM
To: user@cassandra.apache.org
Subject: RE: Dynamic CF
I am trying to use the org.apache.cassandra.cql3 package. Having problem
connecting to the server using ClientState.
I was not sure what to put in the credentials map (I did not set any
users/passwords on my server), so I tried setting empty strings for username
and password, setting them to
://www.thelastpickle.com
On 6/07/2012, at 10:40 AM, Leonid Ilyevsky wrote:
I need to create a ByteBuffer instance containing the proper composite key,
based on the values of the components of the key. I am going to use it for
update operation.
I tried to simply concatenate the buffers corresponding
Can I create a dynamic Cf using cql3? What is the syntax?
Here is what I tried:
cqlsh:test create table mytest (
... asset ascii, datetime int, count int, primary key(asset, datetime) )
... with default_validation_class = double;
Bad Request: default_validation_class is not a
'.
http://www.datastax.com/docs/1.0/references/cql/index#cql-column-family-storage-parameters
On Jul 6, 2012, at 2:13 PM, Leonid Ilyevsky wrote:
Can I create a dynamic Cf using cql3? What is the syntax?
Here is what I tried:
cqlsh:test create table mytest (
... asset ascii, datetime
not support composite key.
Then I thought of making wide rows, so I store many quotes in one row (few
thousand). For this I really need dynamic table.
I would appreciate any useful suggestion.
-Original Message-
From: Leonid Ilyevsky [mailto:lilyev...@mooncapital.com]
Sent: Friday, July
:58 PM
To: user@cassandra.apache.org
Subject: Re: Dynamic CF
On Fri, Jul 6, 2012 at 2:49 PM, Leonid Ilyevsky
lilyev...@mooncapital.commailto:lilyev...@mooncapital.com wrote:
At this point I am really confused about what direction Cassandra is going. CQL
3 has the benefit of composite keys
My current way of inserting rows one by one is too slow (I use cql3 prepared
statements) , so I want to try batch_mutate.
Could anybody give me more details about the interface? In the javadoc it says:
public void
to
update multiple column families using the same key? Shouldn't we design our
space in such a way that those columns live in the same column family?
From: Leonid Ilyevsky [mailto:lilyev...@mooncapital.com]
Sent: Thursday, July 05, 2012 10:39 AM
To: 'user@cassandra.apache.org'
Subject: batch_mutate
My
I need to create a ByteBuffer instance containing the proper composite key,
based on the values of the components of the key. I am going to use it for
update operation.
I tried to simply concatenate the buffers corresponding to the components, but
I am not sure this is correct, because I am
What is the penalty for using longer column names?
Should I sacrifice longer self-explanatory names for shorter cryptic ones to
save the disk space?
On one hand, I understand that Cassandra row id a key-value map, but on another
hand, it probably uses compression when storing them.
Before going into complex clustering topologies, I would like to try the most
simple configuration: just set up two nodes that will completely replicate each
other.
Could somebody tell me how to configure it?
Thanks!
This email, along with any attachments, is
,
Roshni
On 11/06/12 7:20 PM, Leonid Ilyevsky lilyev...@mooncapital.com wrote:
Thanks, I understand what you are telling me. Obviously deleting the
column is the proper way to do this in Cassandra.
What I was looking for, is some convenient wrapper on top of that which
will do it for me. Here is my
Is there a way to control the floating numbers format in the cqlsh output? I
need more digits than it gives by default (in my tests, I see only one digit
after the point).
This email, along with any attachments, is confidential and may be legally
privileged or otherwise protected from
The select count(*) ... query returns correct count only if it is = 1,
otherwise it returns exactly 1.
This happens in both Java API and cqlsh.
Can somebody verify?
This email, along with any attachments, is confidential and may be legally
privileged or otherwise protected from
, Leonid Ilyevsky wrote:
Is there a way to control the floating numbers format in the cqlsh output? I
need more digits than it gives by default (in my tests, I see only one digit
after the point).
This email, along with any attachments, is confidential and may be legally
privileged or otherwise
...@thelastpickle.com wrote:
You don't nee to set columns to null, delete the column instead.
Cheers
-
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com
On 8/06/2012, at 9:34 AM, Leonid Ilyevsky wrote:
Is it possible to explicitly set a column value to null?
I
Is it possible to explicitly set a column value to null?
I see that if insert statement does not include a specific column, that column
comes up as null (assuming we are creating a record with new unique key).
But if we want to update a record, how we set it to null?
Another situation is when I
30 matches
Mail list logo
