Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: error (athena.apache.org: encountered temporary error during SPF
 processing of domain of oberman@civicscience.com)
MIME-Version: 1.0
From: William Oberman <oberman@civicscience.com>
Date: Wed, 3 Jul 2013 14:15:29 -0400
Message-ID: 
 <CAAjbL_=AbV0SLZW0bWO044jx3g6-aDvmJNdMJvA+aiURzk9SdQ@mail.gmail.com>
Subject: cqlsh + existing cf's + query
To: "user@cassandra.apache.org" <user@cassandra.apache.org>
Content-Type: multipart/alternative; boundary=047d7b15ad2b87fbcf04e09f73b0

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

I've been running cassandra a while, and have used the PHP api and
cassandra-cli, but never gave cqlsh a shot.

I'm not quite getting it.  My most simple CF is a dumping ground for
testing things created as:
create column family stats;
I was putting random stats I was computing in it.  All keys, column names &
column values are really ascii.

Using cqlsh (1.1.12, default shell so CQL 2.0 I believe), I did:
USE my_keyspace_name;
ASSUME stats(KEY) VALUES are text, NAMES are text, VALUES are text;
SELECT * from stats LIMIT 10;

Looks great.  But, then I try to do:
SELECT * from stats WHERE KEY='KNOWN_KEY_NAME';

I get:
Bad Request: cannot parse 'KNOWN_KEY_NAME' as hex bytes

If I do the hex value for KNOWN_KEY_NAME, it works.  E.g.
SELECT * from stats WHERE KEY='various_0-9a-f_chars';

I can't find a "TO_HEX(string)" built in function for SQL.  Am I doing
something wrong?

DESCRIBE TABLE stats;

CREATE TABLE stats (
  KEY blob PRIMARY KEY
) WITH
  comment='' AND
  comparator=blob AND
  read_repair_chance=1.000000 AND
  gc_grace_seconds=864000 AND
  default_validation=blob AND
  min_compaction_threshold=4 AND
  max_compaction_threshold=32 AND
  replicate_on_write='false' AND
  compaction_strategy_class='SizeTieredCompactionStrategy';

--047d7b15ad2b87fbcf04e09f73b0
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">I&#39;ve been running cassandra a while, and have used the=
 PHP api and cassandra-cli, but never gave cqlsh a shot.<div><br></div><div=
 style>I&#39;m not quite getting it. =A0My most simple CF is a dumping grou=
nd for testing things created as:</div>

<div style>create column family stats;<br></div><div style>I was putting ra=
ndom stats I was computing in it. =A0All keys, column names &amp; column va=
lues are really ascii. =A0</div><div style><br></div><div style>Using cqlsh=
 (1.1.12, default shell so CQL 2.0 I believe), I did:</div>

<div style>USE my_keyspace_name;</div><div style>ASSUME stats(KEY) VALUES a=
re text, NAMES are text, VALUES are text;<br></div><div style>SELECT * from=
 stats LIMIT 10;<br></div><div style><br></div><div style>Looks great. =A0B=
ut, then I try to do:</div>

<div style>SELECT * from stats WHERE KEY=3D&#39;KNOWN_KEY_NAME&#39;;<br></d=
iv><div style><br></div><div style>I get:</div><div style><div>Bad Request:=
 cannot parse &#39;KNOWN_KEY_NAME&#39; as hex bytes</div><div><br></div>
<div style>
If I do the hex value for KNOWN_KEY_NAME, it works. =A0E.g.</div><div style=
>SELECT * from stats WHERE KEY=3D&#39;various_0-9a-f_chars&#39;;<br></div><=
div style><br></div><div style>I can&#39;t find a &quot;TO_HEX(string)&quot=
; built in=A0function=A0for SQL. =A0Am I doing something wrong?</div>

<div style><br></div><div style>DESCRIBE TABLE stats;<br></div><div style><=
br></div><div style><div>CREATE TABLE stats (</div><div>=A0 KEY blob PRIMAR=
Y KEY</div><div>) WITH</div><div>=A0 comment=3D&#39;&#39; AND</div><div>=A0=
 comparator=3Dblob AND</div>

<div>=A0 read_repair_chance=3D1.000000 AND</div><div>=A0 gc_grace_seconds=
=3D864000 AND</div><div>=A0 default_validation=3Dblob AND</div><div>=A0 min=
_compaction_threshold=3D4 AND</div><div>=A0 max_compaction_threshold=3D32 A=
ND</div><div>=A0 replicate_on_write=3D&#39;false&#39; AND</div>

<div>=A0 compaction_strategy_class=3D&#39;SizeTieredCompactionStrategy&#39;=
;</div></div><div style><br></div><div style><br></div><div><br></div></div=
></div>

--047d7b15ad2b87fbcf04e09f73b0--