Mailing-List: contact dev-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Received-SPF: neutral (athena.apache.org: local policy)
MIME-Version: 1.0
In-Reply-To: 
 <CAGkFMwBfsFSm2XJy0SzkFZ9hLxdycSjKhWK0k5NA1hXXA_MXyA@mail.gmail.com>
References: 
 <CALKREE63v4e7GLOZCR7E+uiUgErpvU4qOFk9v-b4RwqVs+buRw@mail.gmail.com>
	<CAKkz8Q270wpRGGDMaZCd1craKgwY6o-NROneKmL6Yc=xoV3GMA@mail.gmail.com>
	<CALKREE6u-cvuWy27pn8=aUeP7ro-1QNQ3Q5Vnc42ksn4-Yex5g@mail.gmail.com>
	<CAKkz8Q0OKa14srRri7-5g6dr7GavgXVyrqxo4dKLoqW9rhbMOw@mail.gmail.com>
	<CAGkFMwBfsFSm2XJy0SzkFZ9hLxdycSjKhWK0k5NA1hXXA_MXyA@mail.gmail.com>
Date: Wed, 6 Mar 2013 07:46:13 +1100
Message-ID: 
 <CALKREE7hoW2naOeksjUObnFdSHO=MZB8c7rs6tP1VnN2ib+Muw@mail.gmail.com>
Subject: Re: bug report - CQL3 grammar should ignore VARCHAR column length in
 CREATE statements
From: Andrew Prendergast <ap@andrewprendergast.com>
To: dev@cassandra.apache.org
Content-Type: multipart/alternative; boundary=e0cb4efe34447afb5704d73390ac

--e0cb4efe34447afb5704d73390ac
Content-Type: text/plain; charset=ISO-8859-1

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 solid in terms of
cross-platform compatibility.

On the DDL, I personally have a need for similar compatibility. One app I'm
working on  programmatically creates the schema for a rather big ETL
environment. It includes a very nice abstraction that creates databases and
tables to accommodate tuples as they pass through the pipeline and behaves
the same regardless of which DBMS is being used as the storage engine.

This is possible because it turns out there is a subset of DDL that is
common to all of the DBMS platforms and it would be very useful to see that
in Cassandra.

ap


On Tue, Mar 5, 2013 at 8:26 PM, Tristan Tarrant
<tristan.tarrant@gmail.com>wrote:

> On Tue, Mar 5, 2013 at 10:20 AM, Sylvain Lebresne <sylvain@datastax.com
> >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
> > ANSI-SQL
> > as a convenience. But only if that doesn't compromise the language
> > "integrity"
> > and is justified. Adding a syntax with a well known semantic but without
> >
>
> To me database DDL (such as the CREATE statement we are talking about) is
> always going to be handled in a custom fashion by applications.
> While ANSI SQL compatibility for CRUD operations is a great objective, I
> don't think it really matters for DDL.
>
> Tristan
>

--e0cb4efe34447afb5704d73390ac--