Return-Path: 
 <user-return-27999-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org>
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 65A08DF29
	for <apmail-cassandra-user-archive@www.apache.org>;
 Wed,  8 Aug 2012 03:17:24 +0000 (UTC)
Received: (qmail 12273 invoked by uid 500); 8 Aug 2012 03:17:22 -0000
Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org
Received: (qmail 12061 invoked by uid 500); 8 Aug 2012 03:17:20 -0000
Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@cassandra.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@cassandra.apache.org>
List-Post: <mailto:user@cassandra.apache.org>
List-Id: <user.cassandra.apache.org>
Reply-To: user@cassandra.apache.org
Delivered-To: mailing list user@cassandra.apache.org
Received: (qmail 12031 invoked by uid 99); 8 Aug 2012 03:17:18 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 08 Aug 2012 03:17:18 +0000
X-ASF-Spam-Status: No, hits=-0.1 required=5.0
	tests=FSL_RCVD_USER,HK_RANDOM_ENVFROM,RCVD_IN_DNSWL_LOW,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of jasonhillpdx@gmail.com
 designates 209.85.160.44 as permitted sender)
Received: from [209.85.160.44] (HELO mail-pb0-f44.google.com) (209.85.160.44)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 08 Aug 2012 03:17:12 +0000
Received: by pbbrr4 with SMTP id rr4so685692pbb.31
        for <user@cassandra.apache.org>; Tue, 07 Aug 2012 20:16:52 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:from:date:message-id:subject:to:content-type;
        bh=nqfiyMn5njZ4H9q4Vg+LvCG0OMEwDQePm/U/7GM72kw=;
        b=lStIchl5QPnRxE5/KZJ044iU4uICCdK2YLdb6Rw6KqfLd2pCp8iEAdZSoyLI7N0G81
         ooR3YN6WcsYbJTKsb80opLtVSUPNL6j8S3YTDGGDbGY4uLUsYIUySJ6m3I4Hgl4HJ7z8
         +l597BmSrSeTyLJTe9n858sB23+ZROoAHC+6EhpZHXR+4dBd+YV+0MqeBlpgnA5Irs0W
         Yq8o9VnCRX6ywyQvvTskkG+DBeMoKaWzINV73FY7/SS2DVnsQ3hQu8H/GoLMzkACaRKQ
         5Alr0anOEZ8WnI5DTR1AzOIgADJRGFynzG87/XZMbh27j4uRzcCJCbzt7TTLWVr9lbsm
         iBag==
Received: by 10.66.83.129 with SMTP id q1mr30577847pay.4.1344395812294; Tue,
 07 Aug 2012 20:16:52 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.68.189.105 with HTTP; Tue, 7 Aug 2012 20:16:24 -0700 (PDT)
From: Jason Hill <jasonhillpdx@gmail.com>
Date: Tue, 7 Aug 2012 20:16:24 -0700
Message-ID: 
 <CAEumP-h8NT57cdpXHSh7kZRy2oq8g6FijPERwymL389FzH060Q@mail.gmail.com>
Subject: Assume Keys in cqlsh?
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1
X-Virus-Checked: Checked by ClamAV on apache.org

Hello,

I'm using:

[cqlsh 2.0.0 | Cassandra 1.0.10 | CQL spec 2.0.0 | Thrift protocol 19.20.0]

I have a column family with a key that is a blob so I query it like this:

    SELECT FIRST 10 1..1344385804 FROM <myCF> WHERE KEY =
'436170616369747943616c63756c61746f727c33';

Is there any way to avoid the hex I'm using for the key?

I tried the following

    ASSUME <myCF> KEYS ARE text;

but it gave this error:

    Improper assume command.


I'm thinking I've missed something here and hope a kind soul would
point me to a solution.

Cheers,
Jason