Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id CD85CE029 for ; Wed, 28 Nov 2012 01:32:57 +0000 (UTC) Received: (qmail 31810 invoked by uid 500); 28 Nov 2012 01:32:55 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 31782 invoked by uid 500); 28 Nov 2012 01:32:55 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 31774 invoked by uid 99); 28 Nov 2012 01:32:55 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 28 Nov 2012 01:32:55 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of edlinuxguru@gmail.com designates 209.85.223.172 as permitted sender) Received: from [209.85.223.172] (HELO mail-ie0-f172.google.com) (209.85.223.172) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 28 Nov 2012 01:32:49 +0000 Received: by mail-ie0-f172.google.com with SMTP id c13so12895628ieb.31 for ; Tue, 27 Nov 2012 17:32:28 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=Xj7XF/dSLODi9mu1+m9mJtfnec25HdJijfuhGLKlCX0=; b=aOudSzb4J5m3Eg2n71iPdeCPmKTq2OhyGW5/gc/mYAxmGaeGwmfDv0WaV6sVZKyAXk k18/Jz9qoO+E8dkQKVxMyTco3WRHKZt6LxsJ7yCC0SDRa/emlDBrnLT/EZIfN9SGmRDh OWGzFVgz92okdXxwzEx61IPqecPrzZPX0VPVnbXUiXjB0wvfFxvkKrpm3yfwG/l0QWbt 9vm8wui3A3I6SCftpxtbMvp6wgqoNwrD3dlXGtfXwlWBBm5abVx5ksYOVDpGSBxBReH4 ZS/Mdjbmy0ebpR5FDSjVaRmcykWFICenzU2622QtKtyuTWbdJ8aphJqPYea4JupDT6ie ejzQ== MIME-Version: 1.0 Received: by 10.50.237.103 with SMTP id vb7mr17649399igc.29.1354066348098; Tue, 27 Nov 2012 17:32:28 -0800 (PST) Received: by 10.64.97.106 with HTTP; Tue, 27 Nov 2012 17:32:28 -0800 (PST) In-Reply-To: <50B533D2.3090508@dehora.net> References: <30197689.409821353884331038.JavaMail.defaultUser@defaultHost> <50B533D2.3090508@dehora.net> Date: Tue, 27 Nov 2012 20:32:28 -0500 Message-ID: Subject: Re: Generic questions over Cassandra 1.1/1.2 From: Edward Capriolo To: "user@cassandra.apache.org" Content-Type: multipart/alternative; boundary=14dae9341205ae431204cf842372 X-Virus-Checked: Checked by ClamAV on apache.org --14dae9341205ae431204cf842372 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable @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=D3ra 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 > > 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 > > --14dae9341205ae431204cf842372 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable @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=D3ra <bill@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 (<= br>> ... =A0user_name varchar,
> ... =A0password varchar,
> = ... =A0gender varchar,
> ... =A0session_token varchar,
> ... = =A0state varchar,
> ... =A0birth_year bigint,
> ... =A0PRIMARY KEY (user_name)
&g= t; ... );
> }}}
>
> I expect this would not cause an unkn= own identifier error -
>
> {{{
> INSERT INTO users
>= ; (user_name, password, extra, moar)
> VALUES
> ('bob', 'secret', 'a', 'b&#= 39;);
> }}}
>
> but definitions vary.
>
> Bil= l
>
> On 26/11/12 09:18, Sylvain Lebresne wrote:
>> >> On Mon, Nov 26, 2012 at 8:41 AM, aaron morton <aaron@thelastpickle.com
>> <mail= to:aaron@thelastpickle.com&g= t;> wrote:
>> =A0> > Is there any noticeable performance difference betwee= n thrift or CQL3?
>> =A0> Off the top of my head it's withi= n 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&quo= t; queries were slightly slower
>> but prepared one (and in real l= ife, I see no good reason not to prepare
>> statements) were actua= lly slightly faster.
>>
>> =A0> CQL 3 requires a schema, however altering the = schema is easier. And
>> in 1.2 will support concurrent schema mod= ifications.
>> =A0> Thrift API is still schema less.
>>= ;
>> Sorry to hijack this thread, but I'd be curious (like seriousl= y, I'm not
>> trolling) to understand what you mean by "C= QL 3 requires a schema" but
>> "Thrift API is still sche= ma less". Basically I'm not sure I always
>> understand what people mean by "schema less" exactly and= I'm curious.
>>
>> --
>> Sylvain
>> --14dae9341205ae431204cf842372--