Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: neutral (nike.apache.org: local policy)
Date: Wed, 8 Feb 2012 11:16:57 -0600
From: Bryce Allen <ballen@ci.uchicago.edu>
To: user@cassandra.apache.org
Subject: Re: cli composite type literal with empty string component
Message-ID: <20120208111657.2cde22f6@bda-uc-laptop>
In-Reply-To: <20120208105937.15f51951@bda-uc-laptop>
References: <20120208102507.0d85849e@bda-uc-laptop>
	<20120208105937.15f51951@bda-uc-laptop>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=PGP-SHA1;
 boundary="Sig_/u_m7/6AaLyuC8/pBoQwUtnY"; protocol="application/pgp-signature"

--Sig_/u_m7/6AaLyuC8/pBoQwUtnY
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

In case anyone else is curious about what is going on here:
https://github.com/pycassa/pycassa/issues/112

The links to the Cassandra JIRA are instructive.

-Bryce

On Wed, 8 Feb 2012 10:59:37 -0600
Bryce Allen <ballen@ci.uchicago.edu> wrote:
> Never mind; the issue with addressing composite column names with
> empty components was fixed in the latest pycassa, which is why I was
> even able to create them in the Test3 schema below. I get an error in
> 1.2.1 which I used to be running, but it all seems to work in 1.4.0.
>=20
> -Bryce
>=20
> On Wed, 8 Feb 2012 10:25:07 -0600
> Bryce Allen <ballen@ci.uchicago.edu> wrote:
> > I have a CF defined like this in CLI syntax:
> >=20
> > create column family Test
> >     with key_validation_class =3D UTF8Type
> >     and comparator =3D 'CompositeType(AsciiType, UTF8Type)'
> >     and default_validation_class =3D UTF8Type
> >     and column_metadata =3D [
> >         { column_name : 'deleted:',
> >           validation_class : BooleanType },
> >         { column_name : 'version:',
> >           validation_class : LongType },
> >     ];
> >=20
> > I expected these columns to map to ("deleted", "") and ("version",
> > "") in pycassa, but this is not the case:
> >=20
> >   TEST.insert("r1", { ("deleted", ""): False, ("version", ""): 1,
> >    		      ("a", "b"): "c" })
> >   AttributeError: 'int' object has no attribute 'encode'
> >=20
> >   TEST.column_validators
> >   {'\x00\x07deleted\x00': 'BooleanType',
> >    '\x00\x07version\x00': 'LongType'}
> >=20
> > The obvious workaround is to use pycassa to define the schema:
> >=20
> >   SYSTEM_MANAGER.create_column_family("test", "Test2",
> >     key_validation_class=3DUTF8_TYPE,
> >     comparator_type=3DCompositeType(ASCII_TYPE, UTF8_TYPE),
> >     default_validation_class=3DUTF8_TYPE,
> >     column_validation_classes=3D{
> >       ("version", ""): LONG_TYPE,
> >       ("deleted", ""): BOOLEAN_TYPE })
> >=20
> > and this does really produce a different schema:
> >  =20
> >   TEST2.column_validators
> >   {'\x00\x07version\x00\x00\x00\x00': 'LongType',
> >    '\x00\x07deleted\x00\x00\x00\x00': 'BooleanType'}
> >=20
> > To mimic what CLI does, I leave off the last component instead of
> > using "":
> >=20
> >   SYSTEM_MANAGER.create_column_family("test", "Test3",
> >     key_validation_class=3DUTF8_TYPE,
> >     comparator_type=3DCompositeType(ASCII_TYPE, UTF8_TYPE),
> >     default_validation_class=3DUTF8_TYPE,
> >     column_validation_classes=3D{
> >       ("version",): LONG_TYPE,
> >       ("deleted",): BOOLEAN_TYPE })
> >=20
> >   TEST3.column_validators
> >   {'\x00\x07deleted\x00': 'BooleanType',
> >    '\x00\x07version\x00': 'LongType'}
> >=20
> > But I see no way to address these columns from pycassa. I have a
> > workaround, but I find the inconsistency perplexing, and would
> > rather not have to do the busywork to convert my schema syntax. Is
> > there a way to address columns with an empty string component in
> > the CLI?
> >=20
> > Thanks,
> > Bryce

--Sig_/u_m7/6AaLyuC8/pBoQwUtnY
Content-Type: application/pgp-signature; name=signature.asc
Content-Disposition: attachment; filename=signature.asc

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)

iQEcBAEBAgAGBQJPMq4JAAoJEH7TXFS3IEdZiyQH/1m20tdOfC3oepGxUJWAh4bX
52juZd/dpwCbDNxzzqYBl4WwT/RJEKUG5cIlw8nh22RBnFO7IiCBlyEPGhta6Aiz
TkM/W0ld+YXp+FsWl0hHykaegfNHBrezzpJqcRdeqILrwO78dnR3o532/UfIz4CT
me8qsoWpBAdia1M9PSfm5Ew/KWR0jFKKfOtYSZe3FjOMLV95iWmcOn+EFuSXhMFs
M77gSHMEI1Ajzp2pzYXYoSXlzEAgufNdWkeFdWkbU5w5AsuP8jQGC9KNp9Hy5QrU
engWzlSQlxEgGc57IPQM3GyFP0vMwurhThVhLl2DJmZYd8KatWTqySUkN5dCA5s=
=J4be
-----END PGP SIGNATURE-----

--Sig_/u_m7/6AaLyuC8/pBoQwUtnY--