Re: Wide row column slicing - row size shard limit

ng the wide row will increase the application complexity, > it would be better if Cassandra can handle it transparently. > it's not that hard :) > > Cheers > > - > Aaron Morton > Freelance Developer > @aaronmorton > http://www.thelastpickle.com > >

Re: Is this the correct data model thinking?

Yes. Think in queries. • Break your normalization habit • Roughly ~one CF per query • Denormalize! •

Composite primary key does not work on Cassandra 1.1.0-beta1

Howdy, Here is the the CQL and error. Did I do something wrong? /home/cassandra>cqlsh Connected to Test Cluster at localhost:9160. [cqlsh 2.1.0 | Cassandra 1.1.0-beta1 | CQL spec 2.0.0 | Thrift protocol 19.28.0] Use HELP for help. cqlsh> use demo; cqlsh:demo> CREATE TABLE timeline ( ... user_id

Re: Combining Cassandra with some SQL language

Agree. That is Transactional database API. Orthogonality: Modular programming, implement Transactional database API as database access interface. Thanks, Charlie | DBA On Sun, Feb 26, 2012 at 6:21 AM, Adam Haney wrote: > I've been using a combination of MySQL and Cassandra for about a year now

Re: Performance overhead when using start and end columns

Hi Aaron, Thanks for the benchmark. The matrix is valuable. Thanks, Charlie (@mujiang) 一个 木匠 === Data Architect Developer http://mujiang.blogspot.com On Mon, Mar 26, 2012 at 10:53 AM, aaron morton wrote: > See the test's in the article. > > The code I used for profiling is also available.

Server side scripting support in Cassandra - go Python !

Howdy, Some Polyglot Persistence(NoSQL) products started support server side scripting, similar to RDBMS store procedure. E.g. Redis Lua scripting. I wish it is Python when Cassandra has the server side scripting feature. FYI, http://antirez.com/post/250 http://nosql.mypopescu.com/post/1994927

Re: Server side scripting support in Cassandra - go Python !

Just like the Oracle Store Procedure. 2012/3/26 Data Craftsman : > Howdy, > > Some Polyglot Persistence(NoSQL) products started support server side > scripting, similar to RDBMS store procedure. > E.g. Redis Lua scripting. > > I wish it is Python when Cassandra has the

Re: Materialized Views or Index CF - data model question

. Then build a small > proof of concept to see if Cassandra will work for you. > > Hope that helps. > > - > Aaron Morton > Freelance Developer > @aaronmorton > http://www.thelastpickle.com > > On 6/04/2012, at 6:46 AM, Data Craftsman wrote: > > Howdy, &g

Re: Is this possible.

Data model: REM CQL 3.0 $> cqlsh --cql3 drop COLUMNFAMILY user_score_v3; CREATE COLUMNFAMILY user_score_v3 (name varchar, highscore float, x int, y varchar, z varchar, PRIMARY KEY (name, highscore) ); DML is as usual, as commom, as RDBMS SQL. Query: Top 3, SELECT name, highscore,

Re: Is this possible.

DML example, insert into user_score_v3(name, highscore, x,y,z) values ('abc', 299.76, 1001, '*', '*'); ... 2012/4/26 Data Craftsman : > Data model: > > REM CQL 3.0 > > > $> cqlsh --cql3 > > drop COLUMNFAMILY user_score_v3; > >

Re: Server Side Logic/Script - Triggers / StoreProc

Howdy, Some Polyglot Persistence(NoSQL) products started support server side scripting, similar to RDBMS store procedure. E.g. Redis Lua scripting. I wish it is Python when Cassandra has the server side scripting feature. FYI, http://antirez.com/post/250 http://nosql.mypopescu.com/post/1994927

Re: Error deleting column families with 1.1

We have similar issue. I'll try to reproduce it and upload logs soon. On Wed, May 9, 2012 at 3:30 AM, André Cruz wrote: > Here it is: https://issues.apache.org/jira/browse/CASSANDRA-4230 > > Please let me know if you need further info. > > Best regards, > André > > On May 8, 2012, at 23:55 , aaro

When will CQL BATCH support binding variable (Query substitution use named parameters)?

Hello, CQL BATCH is good for INSERT/UPDATE performance. But it cannot do binding variable, exposed to SQL injection. Is there a plan to make CQL BATCH to support binding variable in near future? e.g. http://code.google.com/a/apache-extras.org/p/cassandra-dbapi2/ Query substitution Use named pa

Re: When will CQL BATCH support binding variable (Query substitution use named parameters)?

a1, ls_a2 ) Thanks, Charlie | DBA developer On Wed, Jun 20, 2012 at 11:56 PM, Sylvain Lebresne wrote: > On Thu, Jun 21, 2012 at 12:06 AM, Data Craftsman > wrote: >> Hello, >> >> CQL BATCH is good for INSERT/UPDATE performance. >> >> But it cannot do binding

How to create a COLUMNFAMILY with Leveled Compaction?

Sorry for my stupid simple question. How to create a COLUMNFAMILY with Leveled Compaction? There is no example in documentation: http://www.datastax.com/docs/1.1/configuration/storage_configuration#compaction-strategy I try it on Cassandra 1.1.0 and 1.1.2, both failed. The COLUMNFAMILY is still '

Re: How to create a COLUMNFAMILY with Leveled Compaction?

Nobody use Leveled Compaction with CQL 3.0 ? -Z On Tue, Jul 31, 2012 at 11:17 AM, Data Craftsman 木匠 wrote: > Sorry for my stupid simple question. How to create a COLUMNFAMILY with > Leveled Compaction? > > There is no example in documentation: > http://www.datastax.com/docs/1.

Re: CQL connections

I want to know it too. http://www.datastax.com/support-forums/topic/when-will-pycassa-support-cql Connection pool and load balance is a necessary feature for multi-user production application. Thanks, Charlie | DBA On Fri, Aug 10, 2012 at 6:47 AM, David McNelis wrote: > In using CQL (the pytho

Re: How to set LeveledCompactionStrategy for an existing table

We have same problem. On Friday, August 31, 2012, Jean-Armel Luce wrote: > Hello Aaron. > > Thanks for your answer > > Jira ticket 4597 created : https://issues.apache.org/jira/browse/CASSANDRA-4597 > > Jean-Armel > > 2012/8/31 aaron morton > > Looks like a bug. > Can you please create a ticket

Number of columns per row for Composite Primary Key CQL 3.0

Hello experts. Should I limit the number of rows per Composite Primary Key's leading column? I think it falls into the same wide row good practice for number of columns per row for CQL 2.0, e.g. 10M or less. Any comments will be appreciated. -- Thanks, Charlie (@mujiang) 木匠 === Data Archi

Re: Number of columns per row for Composite Primary Key CQL 3.0

you > probably have gone too far. Remember the byte size of the row is also > important; larger rows churn memory more and take longer to compact / > repair. > > Hope that helps. > > - > Aaron Morton > Freelance Developer > @aaronmorton > http://www.

Re: Using the commit log for external synchronization

This will be a good new feature. I guess the development team don't have time on this yet. ;) On Thu, Sep 20, 2012 at 1:29 PM, Ben Hood <0x6e6...@gmail.com> wrote: > Hi, > > I'd like to incrementally synchronize data written to Cassandra into > an external store without having to maintain an ind