> Compact storage is the schemaless of old.

Right. That comes with the downside of picking one :) It does not seem the compact storage is the default choice for the the future. As well as interop with the thrift/cli world, I also find it hard to reason about row caching with CQL defined tables. I still work through thrift/cli as a result, which is a pity because CQL has a nice surface.

Bill

On 28/11/12 01:32, Edward Capriolo wrote:
@Bill

Are you saying that now cassandra is less schema less ? :)

Compact storage is the schemaless of old.

On Tuesday, November 27, 2012, Bill de hÓra <b...@dehora.net
<mailto:b...@dehora.net>> wrote:
 >> I'm not sure I always
 >> understand what people mean by "schema less"
 >> exactly and I'm curious.
 >
 > For 'schema less', given this -
 >
 > {{{
 > cqlsh> use example;
 > cqlsh:example> CREATE TABLE users (
 > ...  user_name varchar,
 > ...  password varchar,
 > ...  gender varchar,
 > ...  session_token varchar,
 > ...  state varchar,
 > ...  birth_year bigint,
 > ...  PRIMARY KEY (user_name)
 > ... );
 > }}}
 >
 > I expect this would not cause an unknown identifier error -
 >
 > {{{
 > INSERT INTO users
 > (user_name, password, extra, moar)
 > VALUES
 > ('bob', 'secret', 'a', 'b');
 > }}}
 >
 > but definitions vary.
 >
 > Bill
 >
 > On 26/11/12 09:18, Sylvain Lebresne wrote:
 >>
 >> On Mon, Nov 26, 2012 at 8:41 AM, aaron morton
<aa...@thelastpickle.com <mailto:aa...@thelastpickle.com>
 >> <mailto:aa...@thelastpickle.com <mailto:aa...@thelastpickle.com>>>
wrote:
 >>  > > Is there any noticeable performance difference between thrift
or CQL3?
 >>  > Off the top of my head it's within 5% (maybe 10%) under stress tests.
 >> See Eric's talk at the Cassandra SF conference for the exact numbers.
 >>
 >> Eric's benchmark results was that "normal" queries were slightly slower
 >> but prepared one (and in real life, I see no good reason not to prepare
 >> statements) were actually slightly faster.
 >>
 >>  > CQL 3 requires a schema, however altering the schema is easier. And
 >> in 1.2 will support concurrent schema modifications.
 >>  > Thrift API is still schema less.
 >>
 >> Sorry to hijack this thread, but I'd be curious (like seriously, I'm not
 >> trolling) to understand what you mean by "CQL 3 requires a schema" but
 >> "Thrift API is still schema less". Basically I'm not sure I always
 >> understand what people mean by "schema less" exactly and I'm curious.
 >>
 >> --
 >> Sylvain
 >
 >

Reply via email to