incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matt Hollingsworth <m...@crabice.com>
Subject Re: double and float in CQL
Date Thu, 11 Aug 2011 03:40:09 GMT
:)  Sure, I'll create one, thanks for the help.

-Matt

On Wed, Aug 10, 2011 at 11:35 PM, Jonathan Ellis <jbellis@gmail.com> wrote:

> I wasn't aware that we had the cql driver in the cheese shop :)  It's
> probably of recent vintage, 1.04 is the "next" version.
>
> Can you create a ticket on
> https://issues.apache.org/jira/browse/CASSANDRA and we'll have a look?
>
> On Wed, Aug 10, 2011 at 10:16 PM, Matt Hollingsworth <matt@crabice.com>
> wrote:
> > Neither actually, I installed the python cql driver with
> > pip install cql
> > and it came with it.  Looks like it's version 1.0.4
> > pip search cql
> > cql                       - Cassandra Query Language driver
> >   INSTALLED: 1.0.4 (latest)
> > Too old?
> > -Matt
> > On Wed, Aug 10, 2011 at 11:11 PM, Jonathan Ellis <jbellis@gmail.com>
> wrote:
> >>
> >> Are you using the most recent version of cqlsh from svn, or an old one
> >> shipped with a 0.8 Cassandra release?
> >>
> >> On Wed, Aug 10, 2011 at 9:48 PM, Matt Hollingsworth <matt@crabice.com>
> >> wrote:
> >> > Hi,
> >> > I'm just getting started with CQL, and decided to do a simple test
> >> > create/insert/select thing to check that everything was working.  Most
> >> > everything seems to work, but it appears that double/floats do not
> work
> >> > properly.  Here's what I did:
> >> > test.cql
> >> > --------------------------
> >> > CREATE KEYSPACE test with strategy_class = 'SimpleStrategy' and
> >> > strategy_options:replication_factor=1;
> >> > USE test;
> >> > CREATE COLUMNFAMILY testvals (
> >> >     key varchar PRIMARY KEY,
> >> >     value float
> >> >    );
> >> > INSERT INTO testvals (key,value) VALUES ('k1',341.32355);
> >> > SELECT key, value FROM testvals;
> >> > --------------------------
> >> > The output is this:
> >> > cqlsh localhost < scripts/test.cql
> >> >  key |    value |
> >> >   k1 | @uU-B??? |
> >> > Same thing happens when I do value double.  I also tried to do this
> from
> >> > the
> >> > python driver, gives the same weirdness:
> >> > In [2]: import cql
> >> > In [3]: con = cql.connect("localhost",keyspace="test")
> >> > In [4]: cursor = con.cursor()
> >> > In [5]: cursor.execute("SELECT * from testvals")
> >> > Out[5]: True
> >> > In [6]: for r in cursor: print r
> >> >    ...:
> >> > [u'k1', '?\xf8\x00\x00\x00\x00\x00\x00']
> >> > Any idea what's going on?
> >> > Thanks,
> >> > -Matt
> >> >
> >> >
> >>
> >>
> >>
> >> --
> >> Jonathan Ellis
> >> Project Chair, Apache Cassandra
> >> co-founder of DataStax, the source for professional Cassandra support
> >> http://www.datastax.com
> >
> >
>
>
>
> --
> Jonathan Ellis
> Project Chair, Apache Cassandra
> co-founder of DataStax, the source for professional Cassandra support
> http://www.datastax.com
>

Mime
View raw message