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
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
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
*>
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
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
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
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
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
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
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
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
> 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
12 matches
Mail list logo