From user-return-31546-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Thu Jan 31 14:16:52 2013 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 55630E228 for ; Thu, 31 Jan 2013 14:16:52 +0000 (UTC) Received: (qmail 40297 invoked by uid 500); 31 Jan 2013 14:16:49 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 40218 invoked by uid 500); 31 Jan 2013 14:16:46 -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 40195 invoked by uid 99); 31 Jan 2013 14:16:46 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 31 Jan 2013 14:16:46 +0000 X-ASF-Spam-Status: No, hits=-0.1 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [134.36.36.11] (HELO uncle.computing.dundee.ac.uk) (134.36.36.11) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 31 Jan 2013 14:16:38 +0000 Received: from mailex2.computing.dundee.ac.uk (mailex2.computing.dundee.ac.uk [134.36.36.9]) by uncle.computing.dundee.ac.uk (8.13.1/8.13.1) with ESMTP id r0VEFgoN002885 for ; Thu, 31 Jan 2013 14:15:42 GMT Received: from webmail.computing.dundee.ac.uk ([134.36.36.25]) by mailex2.computing.dundee.ac.uk with Microsoft SMTPSVC(6.0.3790.4675); Thu, 31 Jan 2013 14:15:43 +0000 Received: from lifeintheairage.home ([109.150.77.49]) by webmail.computing.dundee.ac.uk over TLS secured channel with Microsoft SMTPSVC(6.0.3790.4675); Thu, 31 Jan 2013 14:15:42 +0000 From: Andy Cobley Content-Type: multipart/alternative; boundary="Apple-Mail=_FE3FFEE3-114A-4DA4-80B6-59C4E206CC0B" Message-Id: Mime-Version: 1.0 (Mac OS X Mail 6.2 \(1499\)) Subject: Re: JDBC, Select * Cql2 vs Cql3 problem ? Date: Thu, 31 Jan 2013 14:15:27 +0000 References: <80939C67-7B75-4A58-9144-91788DA8F430@computing.dundee.ac.uk> <0D2940A5-26F2-4185-A2AA-F6CE904E79DE@thelastpickle.com> <21372ED3-6679-4724-8A05-70094915A61F@computing.dundee.ac.uk> To: user@cassandra.apache.org In-Reply-To: X-Mailer: Apple Mail (2.1499) X-OriginalArrivalTime: 31 Jan 2013 14:15:43.0097 (UTC) FILETIME=[746F5E90:01CDFFBD] X-DD-AC-MailScanner-Information: Contact NickDawes@computing.dundee.ac.uk for more information X-DD-AC-MailScanner: Found to be clean X-DD-AC-MailScanner-From: acobley@computing.dundee.ac.uk X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail=_FE3FFEE3-114A-4DA4-80B6-59C4E206CC0B Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=iso-8859-1 Hi Edward, I've used Hector for years now myself and know how good it is. I think I'v= e tracked this to a problem in the JDBC driver, I'll post a message and rai= se a ticket over there. (there is still a possibility that Cassandra 1.2 i= s sending an incorrect CQLresult set) Andy On 30 Jan 2013, at 14:26, Edward Capriolo wrote: > Darn auto correct cql2 , is only good for compact tables. Make sure you a= re setting you cql version. Or frankly just switch to Hector / thrift and u= se things that are know to work for years now. >=20 > On Wednesday, January 30, 2013, Edward Capriolo w= rote: > > You really can't mix cql2 and cql3. Cql2 does not understand cql3s spar= se tables. Technically it ,barfs all over the place. Cql2 is only good for = contact tables. > > > > On Wednesday, January 30, 2013, Andy Cobley wrote: > >> Well this is getting stranger, for me with this simple table defini= tion,=20 > >> select key,gender from users > >> is also failing with a null pointer exception > >> Andy > >> On 29 Jan 2013, at 13:50, Andy Cobley = wrote: The University of Dundee is a Scottish Registered Charity, No. SC015096. --Apple-Mail=_FE3FFEE3-114A-4DA4-80B6-59C4E206CC0B Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=iso-8859-1
Hi Edward,

I've used Hector for years now myself and know how good i= t is.  I think I've tracked this to a problem in the JDBC driver, I'll= post a message and raise a ticket over there.  (there is still a poss= ibility that Cassandra 1.2 is sending an incorrect CQLresult set)

Andy



On 30= Jan 2013, at 14:26, Edward Capriolo <edlinuxguru@gmail.com> wrote:

Darn auto correct cql2 , is only go= od for compact tables. Make sure you are setting you cql version. Or frankl= y just switch to Hector / thrift and use things that are know to work for y= ears now.

On Wednesday, January 30, 2013, Edward Capriolo <edlinuxguru@gmail.com> wrote:
> You really can't mix cql2 and cql3. Cql2 does not understand cql3s spa= rse tables. Technically it ,barfs all over the place. Cql2 is only good for= contact tables.
>
> On Wednesday, January 30, 2013, Andy Coble= y <acobley@computing.d= undee.ac.uk> wrote:
>> Well this is getting stranger,   for me  with this simpl= e table definition, 
>> select key,gender from users
>&= gt; is also failing with a null pointer exception
>> Andy
>&= gt; On 29 Jan 2013, at 13:50, Andy Cobley <acobley@computing.dundee.ac.uk> wrote:

The University of Dundee is a Scottish Registered Charity, No. SC015096.
--Apple-Mail=_FE3FFEE3-114A-4DA4-80B6-59C4E206CC0B--