Re: bug report - CQL3 grammar should ignore VARCHAR column length in CREATE statements

2013-03-05 Thread Andrew Prendergast
I think we agree then! The fact that people misuse Cassandra is a whole separate issue and shouldn't hold the rest of us back. Adding obfuscation to CQL3 isn't the solution. Give me a few more days to put a complete list together of what I think could be refined in CQL3 then we can pick this up a

Re: bug report - CQL3 grammar should ignore VARCHAR column length in CREATE statements

2013-03-05 Thread Edward Capriolo
yes. It doesn't use foreign keys or any constraints, they slow things down. Exactly what you do not want. Check the history of the "features" that do read before write. Counters, the old read before write secondary indexes, the new collection functions that impose read before write. Once people s

Re: bug report - CQL3 grammar should ignore VARCHAR column length in CREATE statements

2013-03-05 Thread Andrew Prendergast
Totally agree, simple is good. I want to refine the interface - the storage engine is fabulous as-is. ap On Wed, Mar 6, 2013 at 8:29 AM, Edward Capriolo wrote: > Not to say that you can not do it. Or that it is impossible to do > correctly, but currently Cassandra does not allow it's validat

Re: bug report - CQL3 grammar should ignore VARCHAR column length in CREATE statements

2013-03-05 Thread Andrew Prendergast
*> http://www.edwardcapriolo.com/roller/edwardcapriolo/entry/schema_vs_schema_less * Thanks for the link Ed, I'm aware of all that. *> Does your the tool handle the fact that foreign keys do not work? * yes. It doesn't use foreign keys or any constraints, they slow things down. *> how are your de

Re: bug report - CQL3 grammar should ignore VARCHAR column length in CREATE statements

2013-03-05 Thread Edward Capriolo
Not to say that you can not do it. Or that it is impossible to do correctly, but currently Cassandra does not allow it's validation to accept parameters per column. IE you can set a column to be varchar UTF8Type, or int int32Type but you CAN'T attach more properties to that type, such as the size o

Re: bug report - CQL3 grammar should ignore VARCHAR column length in CREATE statements

2013-03-05 Thread Edward Capriolo
http://www.edwardcapriolo.com/roller/edwardcapriolo/entry/schema_vs_schema_less Does your the tool handle the fact that foreign keys do not work? Or for that matter, how are your dealing with the fact that a "primary key" in cassandra is nothing like a "primary key" in a RDBMS? Generally under th

Re: bug report - CQL3 grammar should ignore VARCHAR column length in CREATE statements

2013-03-05 Thread Andrew Prendergast
Hi Tristan, I've spent the last couple weekends testing the CRUD DML stuff and its very close to meeting that objective (although NULL handling needs some tuning). The main hiccups are in the JDBC driver which I have been working through with Rick - once he accepts my patches it'll be pretty soli

Re: bug report - CQL3 grammar should ignore VARCHAR column length in CREATE statements

2013-03-05 Thread Andrew Prendergast
Sylvain, All I'm trying to do is make Cassandra work with existing ETL, ORM & desktop tools a bit better. I think that is a worthy cause. ap On Tue, Mar 5, 2013 at 8:20 PM, Sylvain Lebresne wrote: > > This is just one of a few small adjustments that can be made to the > grammar > > to make e

Re: Very slow inserts

2013-03-05 Thread Aleksey Yeschenko
cqlsh COPY is not designed for inserting millions of rows fast. If you need to do that, you should write your own tool, maybe in Java (and batch your inserts). -- AY On Tuesday, March 5, 2013 at 16:38 PM, Pushkar Prasad wrote: > Hi, > > > I'm using Cassandra 1.2.1, and I am using COPY comm

Very slow inserts

2013-03-05 Thread Pushkar Prasad
Hi, I'm using Cassandra 1.2.1, and I am using COPY command to insert millions of rows. Each row is 100 bytes long. The issue is that the insertion happens rather slowly, at rate of 1500 rows per second. We have 3 node cluster with 50 GB disk space each, and 4 GB RAM each. Cassandra process is r

Re: bug report - CQL3 grammar should ignore VARCHAR column length in CREATE statements

2013-03-05 Thread Tristan Tarrant
On Tue, Mar 5, 2013 at 10:20 AM, Sylvain Lebresne wrote: > > This is just one of a few small adjustments that can be made to the > grammar > > to make everyone's life easier while still maintaining the spirit of > NOSQL. > > To be clear, I am *not* necessarily against making CQL3 closer to the > A

Re: bug report - CQL3 grammar should ignore VARCHAR column length in CREATE statements

2013-03-05 Thread Sylvain Lebresne
> This is just one of a few small adjustments that can be made to the grammar > to make everyone's life easier while still maintaining the spirit of NOSQL. To be clear, I am *not* necessarily against making CQL3 closer to the ANSI-SQL as a convenience. But only if that doesn't compromise the langu