unsubscribe

2013-10-30 Thread Leonid Ilyevsky
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 intend

Unsibscribe

2013-10-09 Thread Leonid Ilyevsky
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

unsubscribe

2013-01-16 Thread Leonid Ilyevsky
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

RE: Cannot create CF in Cassandra 1.1.2

2012-07-31 Thread Leonid Ilyevsky
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 To

RE: Cannot create CF in Cassandra 1.1.2

2012-07-31 Thread Leonid Ilyevsky
ady. I am positive that my data is corrupted in some way, so the question is, how do I repair it. -Original Message----- From: Leonid Ilyevsky [mailto:lilyev...@mooncapital.com] Sent: Tuesday, July 31, 2012 2:55 PM To: 'user@cassandra.apache.org' Subject: RE: Cannot create CF in Ca

RE: Cannot create CF in Cassandra 1.1.2

2012-07-31 Thread Leonid Ilyevsky
/DataModel/ for cassandra datamodel. Also, the flushing events are expected. For example run "create keyspace " , "use " , "create column family " This should work with default settings.. On Tue, Jul 31, 2012 at 11:34 PM, Leonid Ilyevsky wrote: > My cassandra

Cannot create CF in Cassandra 1.1.2

2012-07-31 Thread Leonid Ilyevsky
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 bro

Batch update efficiency with composite key

2012-07-18 Thread Leonid Ilyevsky
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 p

How to speed up data loading

2012-07-12 Thread Leonid Ilyevsky
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 row

RE: help using org.apache.cassandra.cql3

2012-07-11 Thread Leonid Ilyevsky
NSERT ...; ... 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 wrote: > Is it OK to

RE: help using org.apache.cassandra.cql3

2012-07-11 Thread Leonid Ilyevsky
, 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 mailto:lilyev...@mooncapital.com>> wrote: I am

help using org.apache.cassandra.cql3

2012-07-10 Thread Leonid Ilyevsky
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

RE: Dynamic CF

2012-07-10 Thread Leonid Ilyevsky
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

RE: Dynamic CF

2012-07-10 Thread Leonid Ilyevsky
-Original Message- 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 wrote: > So I guess, in the batch_mutate call, in the map t

RE: Dynamic CF

2012-07-10 Thread Leonid Ilyevsky
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 wrote: > At this poin

RE: Dynamic CF

2012-07-06 Thread Leonid Ilyevsky
:58 PM To: user@cassandra.apache.org Subject: Re: Dynamic CF On Fri, Jul 6, 2012 at 2:49 PM, Leonid Ilyevsky mailto: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, but no dynamic colu

RE: Dynamic CF

2012-07-06 Thread Leonid Ilyevsky
hat batch_mutate would 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.c

RE: Dynamic CF

2012-07-06 Thread Leonid Ilyevsky
validation'. 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 tabl

Dynamic CF

2012-07-06 Thread Leonid Ilyevsky
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 v

RE: Composite key in thrift java api - still need help!!

2012-07-06 Thread Leonid Ilyevsky
is: what is the required format of the key buffer? From: Leonid Ilyevsky [mailto:lilyev...@mooncapital.com] Sent: Friday, July 06, 2012 10:05 AM To: 'user@cassandra.apache.org' Subject: RE: Composite key in thrift java api Thanks Aaron, I guess, you suggest I just borrow the logic

RE: Composite key in thrift java api

2012-07-06 Thread Leonid Ilyevsky
veloper @aaronmorton http://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 buf

Composite key in thrift java api

2012-07-05 Thread Leonid Ilyevsky
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 gett

RE: batch_mutate

2012-07-05 Thread Leonid Ilyevsky
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: b

batch_mutate

2012-07-05 Thread Leonid Ilyevsky
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 batch_mutate(java.util.Map>>> mutation_map, Consistenc

Column names overhead

2012-06-22 Thread Leonid Ilyevsky
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. _

Help with configuring replication

2012-06-13 Thread Leonid Ilyevsky
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 co

RE: Number format in cqlsh

2012-06-12 Thread Leonid Ilyevsky
, 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

select count(*) returns 10000

2012-06-12 Thread Leonid Ilyevsky
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 disclo

Number format in cqlsh

2012-06-12 Thread Leonid Ilyevsky
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 disclosur

RE: Setting column to null

2012-06-12 Thread Leonid Ilyevsky
gards, Roshni On 11/06/12 7:20 PM, "Leonid Ilyevsky" 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

RE: Setting column to null

2012-06-11 Thread Leonid Ilyevsky
stpickle.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 t

Setting column to null

2012-06-07 Thread Leonid Ilyevsky
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